DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 175: TYPE transaction_id_tbl IS TABLE OF mtl_material_transactions.transaction_id%TYPE

171: TYPE error_explanation_tbl IS TABLE OF mtl_transactions_interface.error_explanation%TYPE
172: INDEX BY PLS_INTEGER;
173: TYPE source_line_id_tbl IS TABLE OF mtl_transactions_interface.source_line_id%TYPE
174: INDEX BY PLS_INTEGER;
175: TYPE transaction_id_tbl IS TABLE OF mtl_material_transactions.transaction_id%TYPE
176: INDEX BY PLS_INTEGER;
177: TYPE transaction_line_id_tbl IS TABLE OF dpp_transaction_lines_all.transaction_line_id%TYPE
178: INDEX BY PLS_INTEGER;
179: TYPE transaction_subtype_tbl IS TABLE OF dpp_xla_lines.transaction_sub_type%TYPE

Line 1387: mtl_material_transactions mmt,

1383: transaction_ids,
1384: transaction_line_ids,
1385: transaction_subtypes
1386: FROM
1387: mtl_material_transactions mmt,
1388: DPP_OUTPUT_XML_GT dpp_gt
1389: WHERE
1390: mmt.transaction_source_type_id = 13 -- Inventory
1391: AND mmt.source_line_id = l_txn_hdr_rec.Execution_Detail_ID

Line 1438: mtl_material_transactions mmt,

1434: transaction_ids,
1435: transaction_line_ids,
1436: transaction_subtypes
1437: FROM
1438: mtl_material_transactions mmt,
1439: cst_cost_updates ccu,
1440: DPP_OUTPUT_XML_GT dpp_gt
1441: WHERE
1442: mmt.transaction_source_id = ccu.cost_update_id