DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 1048: Mtl_txn_request_headers mtrh

1044: BEGIN
1045: SELECT SUM((mtrl.quantity - (Nvl(mtrl.quantity_detailed,0) +
1046: Nvl(mtrl.quantity_delivered,0)))) INTO l_open_mo_qty
1047: FROM mtl_txn_request_lines mtrl,
1048: Mtl_txn_request_headers mtrh
1049: WHERE mtrl.header_id = mtrh.header_id
1050: AND mtrl.organization_id = mtrh.organization_id
1051: AND mtrl.organization_id = L_ORG_ID
1052: AND mtrl.inventory_item_id = L_item_id

Line 4425: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

4421: -- well AS untouched move ORDER qty
4422: (mtrl.QUANTITY - NVL(mtrl.QUANTITY_DELIVERED,0)) AS quantity,
4423: mtrl.uom_code,
4424: Nvl(mtrl.quantity_detailed,0) AS quantity_detailed
4425: from mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
4426: where mtrl.header_id = mtrh.header_id
4427: and mtrl.organization_id = P_ORG_ID
4428: and mtrl.inventory_item_id = p_item_id
4429: and mtrl.to_subinventory_code = P_FP_SUB

Line 6963: Mtl_txn_request_headers mtrh

6959: mtrl.uom_code,
6960: mtrl.header_id,
6961: mtrl.line_id
6962: FROM mtl_txn_request_lines mtrl,
6963: Mtl_txn_request_headers mtrh
6964: WHERE mtrl.header_id = mtrh.header_id
6965: And mtrl.organization_id = mtrh.organization_id
6966: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')
6967: And MTRH.move_order_type = 2