eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MINMAX_PVT dependencies on INV_GLOBALS

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

2115: -- Select only Issue from Stores for org level planning
2116: -- Also select those lines for sub level planning.
2117: --
2118: -- Exclude move orders created for WIP Issue transaction
2119: -- (txn type = 35, INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE)
2120: -- since these are already taken into account (above) by
2121: -- directly querying the WIP tables for open component requirements
2122: --
2123:

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

2133: INTO qty
2134: FROM MTL_TXN_REQUEST_LINES MTRL,
2135: MTL_TRANSACTION_TYPES MTT
2136: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2137: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2138: AND MTRL.ORGANIZATION_ID = p_org_id
2139: AND MTRL.INVENTORY_ITEM_ID = p_item_id
2140: AND MTRL.LINE_STATUS NOT IN (5,6)
2141: AND MTT.TRANSACTION_ACTION_ID = 1

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

2159: INTO qty
2160: FROM MTL_TXN_REQUEST_LINES MTRL,
2161: MTL_TRANSACTION_TYPES MTT
2162: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2163: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2164: AND MTRL.ORGANIZATION_ID = p_org_id
2165: AND MTRL.INVENTORY_ITEM_ID = p_item_id
2166: AND MTRL.LINE_STATUS IN (3,7)--Changed for Bug 5330189: 3 = Approved 7 = Pre-Approved
2167: AND MTT.TRANSACTION_ACTION_ID = 1

Line 3582: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

3578: l_trolin_tbl(l_order_count).quantity := p_qty;
3579: l_trolin_tbl(l_order_count).status_date := sysdate;
3580: l_trolin_tbl(l_order_count).to_subinventory_code := p_subinv;
3581: l_trolin_tbl(l_order_count).uom_code := p_uom;
3582: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3583: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_REF_TYPE_MINMAX;-- kkoothan For Bug Fix:2756930
3584: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3585: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3586: /* ------INVCONV Change Added secondary qty and uom------ */

Line 3585: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;

3581: l_trolin_tbl(l_order_count).uom_code := p_uom;
3582: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3583: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_REF_TYPE_MINMAX;-- kkoothan For Bug Fix:2756930
3584: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3585: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3586: /* ------INVCONV Change Added secondary qty and uom------ */
3587: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
3588: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom;
3589: /* ------INVCONV Change Added secondary qty and uom------ */