DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on INV_GLOBALS

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

2125: -- Select only Issue from Stores for org level planning
2126: -- Also select those lines for sub level planning.
2127: --
2128: -- Exclude move orders created for WIP Issue transaction
2129: -- (txn type = 35, INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE)
2130: -- since these are already taken into account (above) by
2131: -- directly querying the WIP tables for open component requirements
2132: --
2133:

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

2143: INTO qty
2144: FROM MTL_TXN_REQUEST_LINES MTRL,
2145: MTL_TRANSACTION_TYPES MTT
2146: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2147: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2148: AND MTRL.ORGANIZATION_ID = p_org_id
2149: AND MTRL.INVENTORY_ITEM_ID = p_item_id
2150: AND MTRL.LINE_STATUS NOT IN (5,6)
2151: AND MTT.TRANSACTION_ACTION_ID = 1

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

2169: INTO qty
2170: FROM MTL_TXN_REQUEST_LINES MTRL,
2171: MTL_TRANSACTION_TYPES MTT
2172: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2173: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2174: AND MTRL.ORGANIZATION_ID = p_org_id
2175: AND MTRL.INVENTORY_ITEM_ID = p_item_id
2176: AND MTRL.LINE_STATUS IN (3,7)--Changed for Bug 5330189: 3 = Approved 7 = Pre-Approved
2177: AND MTT.TRANSACTION_ACTION_ID = 1

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

3585: l_trolin_tbl(l_order_count).quantity := p_qty;
3586: l_trolin_tbl(l_order_count).status_date := sysdate;
3587: l_trolin_tbl(l_order_count).to_subinventory_code := p_subinv;
3588: l_trolin_tbl(l_order_count).uom_code := p_uom;
3589: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3590: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_REF_TYPE_MINMAX;-- kkoothan For Bug Fix:2756930
3591: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3592: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3593: /* ------INVCONV Change Added secondary qty and uom------ */

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

3588: l_trolin_tbl(l_order_count).uom_code := p_uom;
3589: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
3590: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_REF_TYPE_MINMAX;-- kkoothan For Bug Fix:2756930
3591: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
3592: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
3593: /* ------INVCONV Change Added secondary qty and uom------ */
3594: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
3595: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom;
3596: /* ------INVCONV Change Added secondary qty and uom------ */