DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 1065: Mtl_txn_request_headers mtrh

1061: BEGIN
1062: SELECT SUM((mtrl.quantity - (Nvl(mtrl.quantity_detailed,0) +
1063: Nvl(mtrl.quantity_delivered,0)))) INTO l_open_mo_qty
1064: FROM mtl_txn_request_lines mtrl,
1065: Mtl_txn_request_headers mtrh
1066: WHERE mtrl.header_id = mtrh.header_id
1067: AND mtrl.organization_id = mtrh.organization_id
1068: AND mtrl.organization_id = L_ORG_ID
1069: AND mtrl.inventory_item_id = L_item_id

Line 4567: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

4563: -- well AS untouched move ORDER qty
4564: (mtrl.QUANTITY - NVL(mtrl.QUANTITY_DELIVERED,0)) AS quantity,
4565: mtrl.uom_code,
4566: Nvl(mtrl.quantity_detailed,0) AS quantity_detailed
4567: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
4568: where mtrl.header_id = mtrh.header_id
4569: and mtrl.organization_id = P_ORG_ID
4570: and mtrl.inventory_item_id = p_item_id
4571: and mtrl.to_subinventory_code = P_FP_SUB

Line 7138: Mtl_txn_request_headers mtrh

7134: mtrl.uom_code,
7135: mtrl.header_id,
7136: mtrl.line_id
7137: FROM mtl_txn_request_lines mtrl,
7138: Mtl_txn_request_headers mtrh
7139: WHERE mtrl.header_id = mtrh.header_id
7140: And mtrl.organization_id = mtrh.organization_id
7141: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')
7142: And MTRH.move_order_type = 2