Link between rcv_headers_interface and rcv_transactions_interface

Link between rcv_headers_interface and rcv_transactions_interface

In this post , We will be discuss about Link between rcv_headers_interface and rcv_transactions_interface. These tables helps to create PO receiving in oracle system from External Source. Here I will help to share the link between these rcv_headers_interface and rcv_transactions_interface table and how we can use both these tables to create the PO receipts in oracle system from External source.

 

 

Detail Link between rcv_headers_interface and rcv_transactions_interface

As below there are two Columns which helps to link between rcv_headers_interface and rcv_transactions_interface.

 

1.RCV_HEADERS_INTERFACE è HEADER_INTERFACE_ID , GROUP_ID

2.RCV_TRANSACTIONS_INTERFACE è HEADER_INTERFACE_ID , GROUP_ID

Sample Code using Link between these two tables in the Interface

INSERT INTO RCV_HEADERS_INTERFACE
(
HEADER_INTERFACE_ID ,
GROUP_ID ,
PROCESSING_STATUS_CODE ,
RECEIPT_SOURCE_CODE ,
TRANSACTION_TYPE ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_LOGIN ,
VENDOR_ID ,
EXPECTED_RECEIPT_DATE ,
VALIDATION_FLAG
)
SELECT
RCV_HEADERS_INTERFACE_S.NEXTVAL

RCV_INTERFACE_GROUPS_S.NEXTVAL ,
‘PENDING’ ,
‘VENDOR’ ,
‘NEW’ ,
SYSDATE ,
X_USER_ID ,
0 ,
X_VENDOR_ID ,
SYSDATE ,
‘Y’
FROM DUAL;

 

 

 

INSERT INTO RCV_TRANSACTIONS_INTERFACE
(
INTERFACE_TRANSACTION_ID ,
GROUP_ID ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_LOGIN ,
TRANSACTION_TYPE ,
TRANSACTION_DATE ,
PROCESSING_STATUS_CODE ,
PROCESSING_MODE_CODE ,
TRANSACTION_STATUS_CODE ,
PO_HEADER_ID,
PO_LINE_ID ,
ITEM_ID ,
QUANTITY ,
UNIT_OF_MEASURE ,

PO_LINE_LOCATION_ID ,
AUTO_TRANSACT_CODE ,
RECEIPT_SOURCE_CODE ,
TO_ORGANIZATION_CODE ,
SOURCE_DOCUMENT_CODE ,
HEADER_INTERFACE_ID ,
VALIDATION_FLAG
)
SELECT
RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL ,
RCV_INTERFACE_GROUPS_S.CURRVAL ,
SYSDATE ,
X_USER_ID ,
SYSDATE ,
X_USER_ID ,
0 ,
‘RECEIVE’ ,
SYSDATE ,
‘PENDING’ ,
‘BATCH’ ,
‘PENDING’ ,

X_PO_HEADER_ID,
CURSOR1.PO_LINE_ID ,
CURSOR1.ITEM_ID ,
CURSOR1.QUANTITY ,
CURSOR1.UNIT_MEAS_LOOKUP_CODE ,
CURSOR1.LINE_LOCATION_ID ,
‘RECEIVE’ ,
‘VENDOR’ ,
CURSOR1.ORGANIZATION_CODE ,
‘PO’ ,
RCV_HEADERS_INTERFACE_S.CURRVAL ,
‘Y’
FROM DUAL;