DBA Data[Home] [Help]

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_DISTRIBUTIONS_ALL

Line 185: po_distributions_all pod,

181: FROM
182: MTL_CONSUMPTION_TRANSACTIONS mct,
183: --MTL_MATERIAL_TRANSACTIONS mmt,
184: po_line_locations_all poll,
185: po_distributions_all pod,
186: po_lines_all pol
187: WHERE mct.transaction_id = l_transaction_id
188: AND mct.consumption_processed_flag = 'Y'
189: AND mct.inventory_item_id = pol.item_id

Line 228: po_distributions_all pod,

224: FROM
225: MTL_CONSUMPTION_TRANSACTIONS mct,
226: --MTL_MATERIAL_TRANSACTIONS mmt,
227: po_line_locations_all poll,
228: po_distributions_all pod,
229: po_lines_all pol
230: WHERE mct.transaction_id = l_transaction_id
231: AND mct.consumption_processed_flag = 'Y'
232: AND mct.inventory_item_id = pol.item_id

Line 2408: will later be joined to PO_DISTRIBUTIONS_ALL to fetch the

2404:
2405: /* Bug 5373370 - Start */
2406: /* The distribution_interface_ref that is inserted into
2407: PO_DISTRIBUTIONS_INTERFACE is inserted into MCT. This column
2408: will later be joined to PO_DISTRIBUTIONS_ALL to fetch the
2409: PO_DISTRIBUTION_ID */
2410:
2411: /* MMT no longer used in this query */
2412: