APPS.POS_ASN dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;

1126: BEGIN
1127:
1128: FOR c_rec in c_lines LOOP
1129:
1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;
1131:
1132: insert into rcv_transactions_interface
1133: ( INTERFACE_TRANSACTION_ID ,
1134: HEADER_INTERFACE_ID ,

Line 1132: insert into rcv_transactions_interface

1128: FOR c_rec in c_lines LOOP
1129:
1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;
1131:
1132: insert into rcv_transactions_interface
1133: ( INTERFACE_TRANSACTION_ID ,
1134: HEADER_INTERFACE_ID ,
1135: GROUP_ID ,
1136: TRANSACTION_TYPE ,

Line 1238: update rcv_transactions_interface

1234: into x_deliver_to_location_id
1235: from po_distributions_all
1236: where po_distribution_id = c_rec.PO_DISTRIBUTION_ID;
1237:
1238: update rcv_transactions_interface
1239: set deliver_to_location_id = x_deliver_to_location_id
1240: where INTERFACE_TRANSACTION_ID = l_line_id;
1241:
1242: IF x_deliver_to_location_id is null THEN

Line 1244: update rcv_transactions_interface

1240: where INTERFACE_TRANSACTION_ID = l_line_id;
1241:
1242: IF x_deliver_to_location_id is null THEN
1243:
1244: update rcv_transactions_interface
1245: set deliver_to_location_id =
1246: (select ship_to_location_id
1247: from po_line_locations_all
1248: where line_location_id = c_rec.PO_LINE_LOCATION_ID)

Line 1264: update rcv_transactions_interface

1260: asnd.asn_line_split_id = c_rec.asn_line_split_id;
1261:
1262: -- Bug 1345768. Document_line_num is required by the pre-processor but is
1263: -- not available from pos_asn_shop_cart_details.
1264: update rcv_transactions_interface
1265: set DOCUMENT_LINE_NUM =
1266: (select LINE_NUM
1267: from po_lines_all
1268: where po_line_id = c_rec.PO_LINE_ID)

Line 1272: update rcv_transactions_interface

1268: where po_line_id = c_rec.PO_LINE_ID)
1269: where INTERFACE_TRANSACTION_ID = l_line_id;
1270:
1271:
1272: update rcv_transactions_interface
1273: set DOCUMENT_SHIPMENT_LINE_NUM =
1274: (select SHIPMENT_NUM
1275: from po_line_locations_all
1276: where line_location_id = c_rec.PO_LINE_LOCATION_ID)

Line 1279: update rcv_transactions_interface

1275: from po_line_locations_all
1276: where line_location_id = c_rec.PO_LINE_LOCATION_ID)
1277: where INTERFACE_TRANSACTION_ID = l_line_id;
1278:
1279: update rcv_transactions_interface
1280: set po_release_id =
1281: (select po_release_id
1282: from po_line_locations_all
1283: where line_location_id = c_rec.PO_LINE_LOCATION_ID)

Line 1288: update rcv_transactions_interface

1284: where INTERFACE_TRANSACTION_ID = l_line_id;
1285:
1286: -- Dest subinventory is required by the pre-processor but is
1287: -- not available from pos_asn_shop_cart_details.
1288: update rcv_transactions_interface
1289: set SUBINVENTORY =
1290: (select destination_subinventory
1291: from po_distributions_all
1292: where po_distribution_id = c_rec.PO_DISTRIBUTION_ID)

Line 1393: update rcv_transactions_interface set

1389: validation_flag = 'N',
1390: processing_status_code = 'SUCCESS'
1391: where header_interface_id = l_header_id;
1392:
1393: update rcv_transactions_interface set
1394: PROCESSING_STATUS_CODE = 'PENDING',
1395: TRANSACTION_STATUS_CODE = 'PENDING'
1396: where header_interface_id = l_header_id;
1397: