APPS.GME_COMMON_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 2873: mtl_txn_request_lines l,

2869: IF p_invoke_mode = 'O' and l_dummy = 1 then
2870: BEGIN
2871: SELECT SUM(l.primary_quantity) into l_allocated_qty
2872: FROM mtl_material_transactions_temp t,
2873: mtl_txn_request_lines l,
2874: mtl_txn_request_headers h
2875: WHERE t.move_order_line_id = l.line_id
2876: AND t.move_order_header_id = h.header_id
2877: AND t.organization_id = l_mtl_dtl_rec.organization_id

Line 4252: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, gme_material_details d

4248: FTS and for better performance */
4249: CURSOR cur_get_mo_lines
4250: IS
4251: SELECT mtrl.line_id, mtrl.inventory_item_id
4252: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, gme_material_details d
4253: WHERE d.material_detail_id = p_material_detail_id
4254: AND mtrl.organization_id = d.organization_id
4255: AND mtrh.organization_id = d.organization_id
4256: AND mtrl.inventory_item_id = d.inventory_item_id

Line 4271: FROM mtl_txn_request_lines mtrl

4267: mtl_material_transactions_temp mmtt
4268: WHERE mmtt.move_order_line_id = p_line_id
4269: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id;
4270: /*SELECT mtlt.*
4271: FROM mtl_txn_request_lines mtrl
4272: ,mtl_transaction_lots_temp mtlt
4273: ,mtl_material_transactions_temp mmtt
4274: WHERE mtrl.line_id = p_line_id
4275: AND mtrl.txn_source_line_id = p_material_detail_id

Line 4286: TYPE l_mo_lines_tbl_typ IS TABLE OF mtl_txn_request_lines%ROWTYPE

4282: FROM mtl_lot_numbers lots
4283: WHERE lots.inventory_item_id = p_item_id
4284: AND lots.lot_number = p_lot_number;
4285:
4286: TYPE l_mo_lines_tbl_typ IS TABLE OF mtl_txn_request_lines%ROWTYPE
4287: INDEX BY BINARY_INTEGER;
4288:
4289: TYPE l_mo_line_allocations_tbl_typ IS TABLE OF mtl_transaction_lots_temp%ROWTYPE
4290: INDEX BY BINARY_INTEGER;