DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 2712: mtl_txn_request_headers h

2708: BEGIN
2709: SELECT SUM(l.primary_quantity) into l_allocated_qty
2710: FROM mtl_material_transactions_temp t,
2711: mtl_txn_request_lines l,
2712: mtl_txn_request_headers h
2713: WHERE t.move_order_line_id = l.line_id
2714: AND t.move_order_header_id = h.header_id
2715: AND t.organization_id = l_mtl_dtl_rec.organization_id
2716: AND t.inventory_item_id = l_mtl_dtl_rec.inventory_item_id

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

3989: FTS and for better performance */
3990: CURSOR cur_get_mo_lines
3991: IS
3992: SELECT mtrl.line_id, mtrl.inventory_item_id
3993: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh, gme_material_details d
3994: WHERE d.material_detail_id = p_material_detail_id
3995: AND mtrl.organization_id = d.organization_id
3996: AND mtrh.organization_id = d.organization_id
3997: AND mtrl.inventory_item_id = d.inventory_item_id