DBA Data[Home] [Help]

APPS.RCV_CREATEACCOUNTING_PVT dependencies on PO_DISTRIBUTIONS

Line 1299: PO_DISTRIBUTIONS POD

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

Line 1651: -- Get DESTINATION_TYPE_CODE from PO_DISTRIBUTIONS

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

Line 1656: FROM PO_DISTRIBUTIONS

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