APPS.RCV_CREATEACCOUNTING_PVT dependencies on PO_DISTRIBUTIONS

Line 1302: PO_DISTRIBUTIONS POD

1298: INTO
1299: L_RCV_AE_LINE.ITEM_DESCRIPTION
1300: FROM
1301: PO_LINES POL,
1302: PO_DISTRIBUTIONS POD
1303: WHERE
1304: POD.PO_DISTRIBUTION_ID = L_RCV_AE_LINE.DOC_DISTRIBUTION_ID
1305: AND POL.PO_LINE_ID = POD.PO_LINE_ID;
1306: EXCEPTION

Line 1654: -- Get DESTINATION_TYPE_CODE from PO_DISTRIBUTIONS

1650: INTO l_parent_rcv_txn_id
1651: FROM RCV_TRANSACTIONS
1652: WHERE transaction_id = L_RCV_AE_LINE.RCV_TRANSACTION_ID;
1653:
1654: -- Get DESTINATION_TYPE_CODE from PO_DISTRIBUTIONS
1655: l_stmt_num := 205;
1656:
1657: SELECT DESTINATION_TYPE_CODE
1658: INTO l_destination_type_code

Line 1659: FROM PO_DISTRIBUTIONS

1655: l_stmt_num := 205;
1656:
1657: SELECT DESTINATION_TYPE_CODE
1658: INTO l_destination_type_code
1659: FROM PO_DISTRIBUTIONS
1660: WHERE PO_DISTRIBUTION_ID = L_RCV_AE_LINE.DOC_DISTRIBUTION_ID;
1661:
1662: -- Get the parent transaction_type
1663: l_stmt_num := 210;