APPS.CSP_MINMAX_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 1258: -- and quantity delivered in mtl_txn_request_lines

1254: --
1255: IF p_level = 2 THEN
1256: -- kkoothan Part of Bug Fix: 2875583
1257: -- Converting the quantities to the primary uom as the quantity
1258: -- and quantity delivered in mtl_txn_request_lines
1259: -- are in transaction uom.
1260:
1261: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
1262: INTO l_qty

Line 1264: mtl_txn_request_lines mtrl

1260:
1261: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
1262: INTO l_qty
1263: FROM mtl_transaction_types mtt,
1264: mtl_txn_request_lines mtrl
1265: WHERE mtt.transaction_action_id IN (2,28)
1266: AND mtt.transaction_type_id = mtrl.transaction_type_id
1267: AND mtrl.organization_id = p_org_id
1268: AND mtrl.inventory_item_id = p_item_id

Line 1280: mtl_txn_request_lines mtrl

1276: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1277: ),0)
1278: INTO l_qty
1279: FROM mtl_transaction_types mtt,
1280: mtl_txn_request_lines mtrl
1281: WHERE mtt.transaction_action_id IN (2,28)
1282: AND mtt.transaction_type_id = mtrl.transaction_type_id
1283: AND mtrl.organization_id = p_org_id
1284: AND mtrl.inventory_item_id = p_item_id

Line 1886: -- and quantity delivered in mtl_txn_request_lines

1882: -- directly querying the WIP tables for open component requirements
1883:
1884: -- kkoothan Part of Bug Fix: 2875583
1885: -- Converting the quantities to the primary uom as the quantity
1886: -- and quantity delivered in mtl_txn_request_lines
1887: -- are in transaction uom.
1888: --
1889:
1890: /*SELECT SUM(MTRL.QUANTITY - NVL(MTRL.QUANTITY_DELIVERED,0))

Line 1892: FROM MTL_TXN_REQUEST_LINES MTRL,

1888: --
1889:
1890: /*SELECT SUM(MTRL.QUANTITY - NVL(MTRL.QUANTITY_DELIVERED,0))
1891: INTO qty
1892: FROM MTL_TXN_REQUEST_LINES MTRL,
1893: MTL_TRANSACTION_TYPES MTT
1894: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
1895: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1896: AND MTRL.ORGANIZATION_ID = p_org_id

Line 1918: FROM MTL_TXN_REQUEST_LINES MTRL,

1914: , mtrl.uom_code
1915: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1916: ),0)
1917: INTO qty
1918: FROM MTL_TXN_REQUEST_LINES MTRL,
1919: MTL_TRANSACTION_TYPES MTT
1920: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
1921: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
1922: AND MTRL.ORGANIZATION_ID = p_org_id

Line 1949: -- and quantity delivered in mtl_txn_request_lines

1945: --
1946: IF p_level = 2 THEN
1947: -- kkoothan Part of Bug Fix: 2875583
1948: -- Converting the quantities to the primary uom as the quantity
1949: -- and quantity delivered in mtl_txn_request_lines
1950: -- are in transaction uom.
1951:
1952: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
1953: INTO qty

Line 1955: mtl_txn_request_lines mtrl

1951:
1952: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
1953: INTO qty
1954: FROM mtl_transaction_types mtt,
1955: mtl_txn_request_lines mtrl
1956: WHERE mtt.transaction_action_id IN (2,28)
1957: AND mtt.transaction_type_id = mtrl.transaction_type_id
1958: AND mtrl.organization_id = p_org_id
1959: AND mtrl.inventory_item_id = p_item_id

Line 1971: mtl_txn_request_lines mtrl

1967: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1968: ),0)
1969: INTO qty
1970: FROM mtl_transaction_types mtt,
1971: mtl_txn_request_lines mtrl
1972: WHERE mtt.transaction_action_id IN (2,28)
1973: AND mtt.transaction_type_id = mtrl.transaction_type_id
1974: AND mtrl.organization_id = p_org_id
1975: AND mtrl.inventory_item_id = p_item_id

Line 2092: mtl_txn_request_lines mtrl

2088: --
2089: SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2090: INTO l_pick_released_qty
2091: FROM mtl_txn_request_headers mtrh,
2092: mtl_txn_request_lines mtrl
2093: WHERE mtrh.move_order_type = 3
2094: AND mtrh.header_id = mtrl.header_id
2095: AND mtrl.organization_id = p_org_id
2096: AND mtrl.inventory_item_id = p_item_id