INSERTINTO ra_interface_lines_all VALUES l_ar_iface_row; l_ar_iface_row.interface_line_context :='5211'; l_ar_iface_row.interface_line_attribute1 :='100'; l_ar_iface_row.interface_line_attribute2 :='TEST7531'; l_ar_iface_row.orig_system_bill_customer_id := 116744; l_ar_iface_r...
这个program用于处理Deffered状态的workflow,Workflow Background Process运行后,相关数据就会从Order表导入到RA Interface表中去(RA_INTERFACE_LINES_ALL,RA_INTERFACE_SALESCREDITS_ALL,RA_Interface_distribution) 你可以通过下边的SQL来查看RA Interface信息: 1.SELECT * FROM RA_INTERFACE_LINES_ALL WHERE sales_order ...
SELECT * FROMar.ra_interface_lines_all; --应收接口行表 select * from ra_interface_salescredits_all; --应收接口行表 销售业绩信息 SELECT * FROMar.ra_interface_distributions_all; --应收接口分配行表 接口相关表 收款临时表 SELECT * FROMar.ar_interim_cash_receipts_all; --收款标准接口 主数据相...
SELECT*FROMxla.xla_ae_lines;--子分类帐日记账行 SELECT*FROMxla.xla_distributions_link;--子分类帐日记帐行关联表 SELECT*FROMxla.xla_events_error;--会计事件错误提示表 接口相关表应收临时表 SELECT*FROMar.ra_interface_lines_all;--应收接口行表 SELECT*FROMar.ra_interface_distributions_all;--应收接口...
WHERE INTERFACE_LINE_ID IN (SELECT INTERFACE_LINE_ID FROM RA_INTERFACE_LINES_ALL WHERE sales_order = '65961' ); 数据插入到RA Interface之后,再看OE_ORDER_LINES_ALL的INVOICE_INTERFACE_STATUS_CODE字段变成了Yes,INVOICED_QUANTITY变为了订单行的数量。并且你会发现订单行的状态变成了Closed,订单头的状态仍...
这个program用于处理Deffered状态的workflow,Workflow Background Process运行后,相关数据就会从Order表导入到RA Interface表中去(RA_INTERFACE_LINES_ALL,RA_INTERFACE_SALESCREDITS_ALL,RA_Interface_distribution)你可以通过下边的SQL来查看RA Interface信息:1.SELECT * FROM RA_INTERFACE_LINES_ALL WHERE sales_order = ...
AR_INTEREST_BATCHES_ALL AR_INTEREST_HEADERS_ALL AR_INTEREST_LINES_ALL AR_INTERFACE_CONTS_ALL AR_INTERIM_CASH_RCPT_LINES_ALL AR_INTERIM_CASH_RECEIPTS_ALL AR_INTERIM_RECEIPTS_GT AR_INV_API_DIST_GT AR_INV_API_HEADERS_GT AR_INV_API_LINES_GT AR_IREC_APPLY_CREDIT_GT AR_JOURNAL_INTERIM_ALL ...
WHERE INTERFACE_LINE_ID IN (SELECT INTERFACE_LINE_ID FROM RA_INTERFACE_LINES_ALL WHERE sales_order = '65961' ); 数据插入到RA Interface之后,再看OE_ORDER_LINES_ALL的INVOICE_INTERFACE_STATUS_CODE字段变成了Yes,INVOICED_QUANTITY变为了订单行的数量。并且你会发现订单行的状态变成了Closed,订单头的状态仍...
invoice_interface_status_code=NULL,--fulfilled_quantity = ordered_quantity, --非销退不要更新open_flag='N', flow_status_code='CANCELLED', last_updated_by=-1, last_update_date=SYSDATEWHEREline_id=rec.line_id;DELETEFROMra_interface_lines_allWHEREinterface_line_attribute6=to_char(rec.line_id)...
SELECT*FROMar.ra_interface_lines_all;--应收接口行表 SELECT*FROMar.ra_interface_distributions_all;--应收接口分派行表 接口相关表收款临时表 SELECT*FROMar.ar_interim_cash_receipts_all;--收款标准接口 主数据相关表/视图 SELECT*FROMapps.po_vendors;--客户 SELECT*FROMapps.po_vendor_sites_all;--客户...