DBA Data[Home] [Help]

APPS.DPP_ITEMCOST_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

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

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

Line 1421: mtl_material_transactions mmt,

1417: transaction_ids,
1418: transaction_line_ids,
1419: transaction_subtypes
1420: FROM
1421: mtl_material_transactions mmt,
1422: DPP_OUTPUT_XML_GT dpp_gt
1423: WHERE
1424: mmt.transaction_source_type_id = 13 -- Inventory
1425: AND mmt.source_line_id = l_txn_hdr_rec.Execution_Detail_ID

Line 1474: mtl_material_transactions mmt,

1470: transaction_ids,
1471: transaction_line_ids,
1472: transaction_subtypes
1473: FROM
1474: mtl_material_transactions mmt,
1475: cst_cost_updates ccu,
1476: DPP_OUTPUT_XML_GT dpp_gt
1477: WHERE
1478: mmt.transaction_source_id = ccu.cost_update_id