eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_TPRICE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 80: l_ship_num MTL_MATERIAL_TRANSACTIONS.SHIPMENT_NUMBER%TYPE;

76: l_line_id NUMBER;
77: l_header_id NUMBER;
78: l_cust_id NUMBER;
79: l_order_type NUMBER;
80: l_ship_num MTL_MATERIAL_TRANSACTIONS.SHIPMENT_NUMBER%TYPE;
81: l_req_line NUMBER;
82: l_prf NUMBER;
83: l_cost_element NUMBER;
84: l_elem_cost NUMBER;

Line 86: l_err_code MTL_MATERIAL_TRANSACTIONS.ERROR_CODE%TYPE;

82: l_prf NUMBER;
83: l_cost_element NUMBER;
84: l_elem_cost NUMBER;
85: l_err_num NUMBER;
86: l_err_code MTL_MATERIAL_TRANSACTIONS.ERROR_CODE%TYPE;
87: l_err_msg MTL_MATERIAL_TRANSACTIONS.ERROR_EXPLANATION%TYPE;
88: l_stmt_num NUMBER;
89: l_concat_id VARCHAR2(2000);
90: l_concat_seg VARCHAR2(2000);

Line 87: l_err_msg MTL_MATERIAL_TRANSACTIONS.ERROR_EXPLANATION%TYPE;

83: l_cost_element NUMBER;
84: l_elem_cost NUMBER;
85: l_err_num NUMBER;
86: l_err_code MTL_MATERIAL_TRANSACTIONS.ERROR_CODE%TYPE;
87: l_err_msg MTL_MATERIAL_TRANSACTIONS.ERROR_EXPLANATION%TYPE;
88: l_stmt_num NUMBER;
89: l_concat_id VARCHAR2(2000);
90: l_concat_seg VARCHAR2(2000);
91: l_concat_desc VARCHAR2(2000);

Line 307: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

303: l_stmt_num := 120;
304:
305: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
306: INTO l_line_id, l_header_id, l_cust_id, l_order_type
307: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
308: WHERE MMT.transaction_id = p_txn_id
309: AND OEL.line_id = MMT.trx_source_line_id
310: AND OEL.header_id = OEH.header_id;
311: --

Line 323: FROM mtl_material_transactions MMT, rcv_transactions RT

319: -- points to receiving txn, not the shipping txn, because it got created after
320: -- goods are received.
321: decode(l_pd_txfr_ind, 1, 0, nvl(MMT.transfer_transaction_id, 0))
322: INTO l_ship_num, l_req_line, l_txf_txn_id
323: FROM mtl_material_transactions MMT, rcv_transactions RT
324: WHERE MMT.transaction_id = p_txn_id
325: AND RT.transaction_id = MMT.rcv_transaction_id;
326:
327: /* Bug 3482782: for R11i.10, we can find the sending txn based on the txf_txn_id;

Line 335: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

331: l_stmt_num := 135;
332:
333: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
334: INTO l_line_id, l_header_id, l_cust_id, l_order_type
335: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
336: WHERE MMT.transaction_id = l_txf_txn_id
337: AND MMT.trx_source_line_id = OEL.line_id
338: AND OEL.header_id = OEH.header_id;
339: else

Line 344: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

340: l_stmt_num := 140;
341:
342: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
343: INTO l_line_id, l_header_id, l_cust_id, l_order_type
344: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
345: WHERE MMT.transaction_action_id = 21
346: AND MMT.transaction_source_type_id = 8
347: AND MMT.organization_id = l_from_org
348: AND MMT.inventory_item_id = p_item_id

Line 425: UPDATE mtl_material_transactions

421:
422: /* PAC Enhancements for R12: Stamp the COGS and Intercompany accrual accounts in MMT */
423: l_stmt_num := 175;
424:
425: UPDATE mtl_material_transactions
426: SET distribution_account_id = l_om_ccid,
427: expense_account_id = l_inv_ccid
428: WHERE transaction_id = p_txn_id;
429: