APPS.CSP_MINMAX_PVT dependencies on INV_GLOBALS

Line 1880: -- (txn type = 35, INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE)

1876: -- Select only Issue from Stores for org level planning
1877: -- Also select those lines for sub level planning.
1878: --
1879: -- Exclude move orders created for WIP Issue transaction
1880: -- (txn type = 35, INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE)
1881: -- since these are already taken into account (above) by
1882: -- directly querying the WIP tables for open component requirements
1883:
1884: -- kkoothan Part of Bug Fix: 2875583

Line 1895: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

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
1897: AND MTRL.INVENTORY_ITEM_ID = p_item_id
1898: AND MTRL.LINE_STATUS NOT IN (5,6)
1899: AND MTT.TRANSACTION_ACTION_ID = 1

Line 1921: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE

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
1923: AND MTRL.INVENTORY_ITEM_ID = p_item_id
1924: AND MTRL.LINE_STATUS NOT IN (5,6)
1925: AND MTT.TRANSACTION_ACTION_ID = 1