DBA Data[Home] [Help]

APPS.POS_ASN dependencies on PO_DISTRIBUTIONS_ALL

Line 1235: from po_distributions_all

1231: IF c_rec.WIP_ENTITY_ID is not null THEN
1232:
1233: select deliver_to_location_id
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

Line 1291: from po_distributions_all

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)
1293: where INTERFACE_TRANSACTION_ID = l_line_id;
1294: END LOOP;
1295: