详解EBS接口开发之库事务处理带提前发运通知(ASN)采购接收入库-补充



A)   Via ROI Create a ASN [ship,ship]  for a quantity =3 on STANDARD PURCHASE ORDER Create  via ROI an Advanced Shipment Notice ASN number F-ASN-PO-17646-3
for  Standard Purchase Order Number 17646 (PO_HEADER_ID=97981) on Vendor =F_Supplier of 3 items in destination organization V1

1) Insert following Data:
. 1 record in RCV_HEADERS_INTERFACE
    RECEIPT_SOURCE_CODE = VENDOR
    ASN_TYPE  = ASN
    TRANSACTION_TYPE=   NEW
    AUTO_TRANSACT_CODE =  SHIP
    SHIPMENT_NUM  = F-ASN-PO-17646-3

. 1 record in RCV_TRANSACTIONS_INTERFACE
   TRANSACTION_TYPE =   SHIP
   AUTO_TRANSACT_CODE = SHIP
   RECEIPT_SOURCE_CODE = VENDOR
   QUANTITY  = 3

 Use the insert script of Document 225233.1 to create ASN shipment number
  'F-ASN-PO-17646-3' SHIPMENT_NUM with quantity shipped=3
  for Standard PO 17646 - Line 1 - Shipment line 1

INSERT INTO RCV_HEADERS_INTERFACE
            (HEADER_INTERFACE_ID,
             GROUP_ID,
             PROCESSING_STATUS_CODE,
             RECEIPT_SOURCE_CODE,
             ASN_TYPE,
             TRANSACTION_TYPE,
             AUTO_TRANSACT_CODE,
             LAST_UPDATE_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_LOGIN,
             CREATION_DATE,
             CREATED_BY,
             SHIPMENT_NUM,
             VENDOR_ID,
             SHIP_TO_ORGANIZATION_ID,
             SHIPPED_DATE,
             EXPECTED_RECEIPT_DATE,
             EMPLOYEE_ID,
             ORG_ID,
             VALIDATION_FLAG
            )
            VALUES
             (rcv_headers_interface_s.nextval , --Header_Interface_Id
             rcv_interface_groups_s.nextval,   --Group_Id
             'PENDING', --Processing_Status_Code
             'VENDOR', --Receipt_Source_Code
             'ASN', --ASN_TYPE
             'NEW', --Transaction_Type
             'SHIP',  --Auto_Transact_Code
             SYSDATE, --Last_Update_Date
             0,  --Last_Updated_By
             0,  --Last_Update_Login
             SYSDATE, --Creation_Date
             0, --Created_By
             'F-ASN-PO-17646-3', --SHIPMENT_NUM
             7927,   --Vendor_Id
             204, -- SHIP_TO_ORGANIZATION_ID
             SYSDATE, --SHIPPED_DATE
             SYSDATE+1, --Expected_Receipt_Date
             13706,    --Employee_Id
             204, --Operating_Unit_Id
             'Y'     --Validation_Flag
             );

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,
           QUANTITY,
           UNIT_OF_MEASURE,
           ITEM_ID,
           AUTO_TRANSACT_CODE,
           RECEIPT_SOURCE_CODE,
           SOURCE_DOCUMENT_CODE,
           DOCUMENT_NUM,
           DOCUMENT_LINE_NUM,
           SHIP_TO_LOCATION_ID,
           TO_ORGANIZATION_ID,
           HEADER_INTERFACE_ID,
           ORG_ID,
           VALIDATION_FLAG
          )
        SELECT
           rcv_transactions_interface_s.nextval, --Interface_Transaction_id
           rcv_interface_groups_s.currval,         --Group_id
           SYSDATE,              --Last_update_date
           0,                    --Last_updated_by
           SYSDATE,              --Creation_date
           0,                    --Created_by
           0,                    --Last_update_login
           'SHIP',               --TRANSACTION_TYPE_SHIP
           SYSDATE,              --TRANSACTION_DATE
           'PENDING',            --PROCESSING_STATUS_CODE
           'BATCH',              --PROCESSING_MODE_CODE
           'PENDING',            --TRANSACTION_STATUS_CODE
           3,                    --QUANTITY
           'Each',               --UNIT_OF_MEASURE
           26816,                --ITEM_ID
           'SHIP',               --AUTO_TRANSACT_CODE
           'VENDOR',