DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SYSTEM_ITEMS

Line 438: MTL_SYSTEM_ITEMS_B MSI

434: mti.kanban_card_id,
435: mti.transaction_mode --J-dev
436: FROM MTL_TRANSACTIONS_INTERFACE MTI,
437: MTL_TRANSACTION_LOTS_INTERFACE MTLI,
438: MTL_SYSTEM_ITEMS_B MSI
439: WHERE mti.transaction_interface_id = p_interface_id
440: AND MTI.transaction_interface_id = mtli.transaction_interface_id
441: AND MTI.organization_id = msi.organization_id
442: AND mti.inventory_item_id = msi.inventory_item_id

Line 1106: SELECT_COMB_FROM_VIEW => 'MTL_SYSTEM_ITEMS_FVL') ;

1102: STRUCTURE_NUMBER => 101,
1103: CONCAT_SEGMENTS => l_itemsegs,
1104: VALUES_OR_IDS => 'I',
1105: DATA_SET => p_orgid,
1106: SELECT_COMB_FROM_VIEW => 'MTL_SYSTEM_ITEMS_FVL') ;
1107:
1108: if l_result then
1109: x_itemid := fnd_flex_keyval.combination_id;
1110: else

Line 1530: FROM mtl_system_items

1526: , tracking_quantity_ind
1527: , secondary_default_ind
1528: , secondary_uom_code
1529: , primary_uom_code /* Bug 5446542 */
1530: FROM mtl_system_items
1531: WHERE organization_id = org_id
1532: AND inventory_item_id = item_id;
1533:
1534: BEGIN

Line 1860: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

1856: l_revision VARCHAR(3);
1857: l_subinventory_code VARCHAR(10);
1858: l_locator_id NUMBER;
1859: l_rowid VARCHAR(31);
1860: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1861: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;
1862:
1863: l_qty_check BOOLEAN;
1864: l_lot_control_code number;

Line 1861: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;

1857: l_subinventory_code VARCHAR(10);
1858: l_locator_id NUMBER;
1859: l_rowid VARCHAR(31);
1860: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1861: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;
1862:
1863: l_qty_check BOOLEAN;
1864: l_lot_control_code number;
1865:

Line 1870: FROM mtl_system_items

1866: /* get lot control flag */
1867: CURSOR get_item_info( org_id IN NUMBER
1868: , item_id IN NUMBER) IS
1869: SELECT lot_control_code, tracking_quantity_ind, secondary_uom_code
1870: FROM mtl_system_items
1871: WHERE organization_id = org_id
1872: AND inventory_item_id = item_id;
1873:
1874: -- INVCONV end fabdi

Line 2085: FROM MTL_SYSTEM_ITEMS MSI

2081: -- AND ((TRANSACTION_SOURCE_TYPE_ID = 5 AND WIP_SUPPLY_TYPE <> 6) OR
2082: -- (transaction_source_type_id <>5))
2083: AND NOT EXISTS (
2084: SELECT NULL
2085: FROM MTL_SYSTEM_ITEMS MSI
2086: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2087: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2088: AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y');
2089:

Line 2115: FROM MTL_SYSTEM_ITEMS MSI

2111: OR TRANSACTION_SOURCE_TYPE_ID <> 5)
2112: AND PROCESS_FLAG = 1
2113: AND NOT EXISTS (
2114: SELECT NULL
2115: FROM MTL_SYSTEM_ITEMS MSI
2116: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2117: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2118: AND MSI.INVENTORY_ITEM_FLAG = 'Y');
2119:

Line 2146: FROM MTL_SYSTEM_ITEMS MSI

2142: AND PROCESS_FLAG = 1
2143: AND TRANSACTION_ACTION_ID = 24
2144: AND NOT EXISTS (
2145: SELECT NULL
2146: FROM MTL_SYSTEM_ITEMS MSI
2147: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2148: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2149: AND MSI.INVENTORY_ITEM_FLAG = 'Y'
2150: AND MSI.INVENTORY_ASSET_FLAG = 'Y'

Line 2211: FROM MTL_SYSTEM_ITEMS MS1,

2207: AND PROCESS_FLAG = 1
2208: AND TRANSACTION_ACTION_ID = 3
2209: AND EXISTS (
2210: SELECT NULL
2211: FROM MTL_SYSTEM_ITEMS MS1,
2212: MTL_SYSTEM_ITEMS MS2
2213: WHERE MS1.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2214: AND MS1.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2215: AND MS2.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2212: MTL_SYSTEM_ITEMS MS2

2208: AND TRANSACTION_ACTION_ID = 3
2209: AND EXISTS (
2210: SELECT NULL
2211: FROM MTL_SYSTEM_ITEMS MS1,
2212: MTL_SYSTEM_ITEMS MS2
2213: WHERE MS1.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2214: AND MS1.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2215: AND MS2.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2216: AND MS2.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION

Line 2254: FROM MTL_SYSTEM_ITEMS MSI

2250: AND PROCESS_FLAG = 1
2251: AND NVL(SHIPPABLE_FLAG,'Y') = 'Y'
2252: AND NOT EXISTS (
2253: SELECT NULL
2254: FROM MTL_SYSTEM_ITEMS MSI
2255: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2256: AND MSI.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2257: AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y');
2258:

Line 2381: MTL_SYSTEM_ITEMS MSI

2377: AND PROCESS_FLAG = 1
2378: AND NOT EXISTS (
2379: SELECT NULL
2380: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2381: MTL_SYSTEM_ITEMS MSI
2382: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2383: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2384: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
2385: AND MIS.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 2392: FROM MTL_SYSTEM_ITEMS ITM

2388: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
2389: AND MIS.SECONDARY_INVENTORY = MTI.SUBINVENTORY_CODE
2390: UNION
2391: SELECT NULL
2392: FROM MTL_SYSTEM_ITEMS ITM
2393: WHERE ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2394: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2395: AND ITM.RESTRICT_SUBINVENTORIES_CODE = 2);
2396:

Line 2429: MTL_SYSTEM_ITEMS MSI

2425: AND TRANSACTION_ACTION_ID in (2,21,3,5)
2426: AND NOT EXISTS (
2427: SELECT NULL
2428: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2429: MTL_SYSTEM_ITEMS MSI
2430: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID, 2,
2431: MTI.ORGANIZATION_ID,
2432: MTI.TRANSFER_ORGANIZATION)
2433: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2444: FROM MTL_SYSTEM_ITEMS ITM

2440: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
2441: AND MIS.SECONDARY_INVENTORY = MTI.TRANSFER_SUBINVENTORY
2442: UNION
2443: SELECT NULL
2444: FROM MTL_SYSTEM_ITEMS ITM
2445: WHERE ITM.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
2446: MTI.ORGANIZATION_ID,
2447: MTI.TRANSFER_ORGANIZATION)
2448: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2510: MTL_SYSTEM_ITEMS ITM

2506: OR (TRANSACTION_ACTION_ID = 21
2507: AND EXISTS (
2508: SELECT 'X'
2509: FROM MTL_SECONDARY_INVENTORIES MSI,
2510: MTL_SYSTEM_ITEMS ITM
2511: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2512: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2513: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2514: AND ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 2537: MTL_SYSTEM_ITEMS ITM

2533: AND TRANSACTION_ACTION_ID in (2,5)
2534: AND EXISTS (
2535: SELECT 'X'
2536: FROM MTL_SECONDARY_INVENTORIES MSI,
2537: MTL_SYSTEM_ITEMS ITM
2538: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2539: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2540: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
2541: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2547: MTL_SYSTEM_ITEMS ITM

2543: AND MSI.ASSET_INVENTORY = 2)
2544: AND EXISTS (
2545: SELECT 'X'
2546: FROM MTL_SECONDARY_INVENTORIES MSI,
2547: MTL_SYSTEM_ITEMS ITM
2548: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.TRANSFER_SUBINVENTORY
2549: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2550: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
2551: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2862: MTL_SYSTEM_ITEMS MSI

2858: AND TRANSACTION_ACTION_ID NOT IN (24,33,34)
2859: AND NOT EXISTS (
2860: SELECT NULL
2861: FROM MTL_ITEM_REVISIONS MIR,
2862: MTL_SYSTEM_ITEMS MSI
2863: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
2864: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2865: AND MIR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2866: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2873: FROM MTL_SYSTEM_ITEMS ITM

2869: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
2870: AND MIR.REVISION = MTI.REVISION
2871: UNION
2872: SELECT NULL
2873: FROM MTL_SYSTEM_ITEMS ITM
2874: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
2875: AND MTI.REVISION IS NULL
2876: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2877: AND ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID);

Line 2902: MTL_SYSTEM_ITEMS MSI

2898: AND TRANSACTION_ACTION_ID = 3
2899: AND NOT EXISTS (
2900: SELECT NULL
2901: FROM MTL_ITEM_REVISIONS MIR,
2902: MTL_SYSTEM_ITEMS MSI
2903: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
2904: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2905: AND MIR.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2906: AND MIR.REVISION = MTI.REVISION

Line 2913: FROM MTL_SYSTEM_ITEMS ITM

2909: AND MIR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
2910: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
2911: UNION
2912: SELECT NULL
2913: FROM MTL_SYSTEM_ITEMS ITM
2914: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
2915: -- AND MTI.REVISION IS NULL --Bug#3285134. No REVISION validation for Revision to Non-Revision Org Xfer
2916: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2917: AND ITM.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION);

Line 3259: FROM MTL_SYSTEM_ITEMS MSI,

3255: -- Added the above two lines for the bug # 5896859
3256: AND (TRANSACTION_ACTION_ID IN (1,27)
3257: AND EXISTS (
3258: SELECT NULL
3259: FROM MTL_SYSTEM_ITEMS MSI,
3260: mtl_secondary_inventories MSUB
3261: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3262: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3263: AND MSI.INVENTORY_ASSET_FLAG = 'Y'

Line 3809: FROM MTL_SYSTEM_ITEMS MSI

3805: LAST_UPDATED_BY = p_userid,
3806: LAST_UPDATE_LOGIN = p_loginid,
3807: PROGRAM_UPDATE_DATE = SYSDATE,
3808: SHIPPABLE_FLAG = (SELECT SHIPPABLE_ITEM_FLAG
3809: FROM MTL_SYSTEM_ITEMS MSI
3810: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3811: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
3812: WHERE TRANSACTION_HEADER_ID = p_header_id
3813: AND INVENTORY_ITEM_ID IS NOT NULL

Line 3928: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP

3924: AND PROCESS_FLAG = 1
3925: AND ((REBUILD_ITEM_ID IS NOT NULL
3926: AND NOT EXISTS (
3927: SELECT NULL
3928: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP
3929: WHERE MSI.INVENTORY_ITEM_ID = MTI.REBUILD_ITEM_ID
3930: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
3931: AND MP.MAINT_ORGANIZATION_ID = MTI.ORGANIZATION_ID
3932: AND MSI.EAM_ITEM_TYPE = 3

Line 3938: FROM MTL_SYSTEM_ITEMS MSI

3934:
3935: OR (REBUILD_ACTIVITY_ID IS NOT NULL
3936: AND NOT EXISTS (
3937: SELECT NULL
3938: FROM MTL_SYSTEM_ITEMS MSI
3939: WHERE MSI.INVENTORY_ITEM_ID = MTI.REBUILD_ACTIVITY_ID
3940: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3941: AND MSI.EAM_ITEM_TYPE = 2)));
3942:

Line 4060: from mtl_system_items

4056:
4057: /* get item information */
4058: CURSOR c_get_item_info IS
4059: SELECT COPY_LOT_ATTRIBUTE_FLAG , child_lot_flag
4060: from mtl_system_items
4061: WHERE inventory_item_id = p_itemid
4062: AND organization_id = p_orgid;
4063:
4064: -- nsinghi bug 5209065. Added the cursor.

Line 5481: table, then, MTL_SYSTEM_ITEMS is checked to fetch the 'default_lot_status_id'

5477:
5478: /*Bug#5125632. Added the following procedure to update the lot status
5479: of lots for a given line in MTLI, if they are NULL.
5480: Fist MTL_LOT_NUMBERS is checked to find the status. If there is no row in this
5481: table, then, MTL_SYSTEM_ITEMS is checked to fetch the 'default_lot_status_id'
5482: for the corresponding item*/
5483:
5484: Procedure update_status_id_in_mtli( p_txn_interface_id IN NUMBER
5485: ,p_org_id IN NUMBER

Line 5535: FROM mtl_system_items

5531: SELECT lot_status_enabled
5532: ,default_lot_status_id
5533: INTO l_status_enabled
5534: ,l_status_id
5535: FROM mtl_system_items
5536: WHERE organization_id = p_org_id
5537: AND inventory_item_id = p_inventory_item_id;
5538: IF (l_debug = 1) THEN
5539: inv_log_util.trace('After selecting from MSI, Values are:', 'INV_TXN_MANAGER_GRP','1');

Line 6558: FROM MTL_SYSTEM_ITEMS

6554: l_locctrl,
6555: l_lotctrl,
6556: l_serctrl,
6557: l_resloc
6558: FROM MTL_SYSTEM_ITEMS
6559: WHERE INVENTORY_ITEM_ID = l_itemid
6560: AND ORGANIZATION_ID = l_orgid;
6561:
6562: EXCEPTION

Line 6593: MTL_SYSTEM_ITEMS I

6589: l_shlfdays,
6590: l_lotuniq
6591: FROM MTL_PARAMETERS P,
6592: MTL_SECONDARY_INVENTORIES S,
6593: MTL_SYSTEM_ITEMS I
6594: WHERE I.INVENTORY_ITEM_ID = l_itemid
6595: AND S.SECONDARY_INVENTORY_NAME = l_subinv
6596: AND P.ORGANIZATION_ID = l_orgid
6597: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 6809: MTL_SYSTEM_ITEMS I

6805: l_xserctrl,
6806: l_xresloc
6807: FROM MTL_PARAMETERS P,
6808: MTL_SECONDARY_INVENTORIES S,
6809: MTL_SYSTEM_ITEMS I
6810: WHERE I.INVENTORY_ITEM_ID = l_itemid
6811: AND S.SECONDARY_INVENTORY_NAME = l_xsubinv
6812: AND P.ORGANIZATION_ID = l_xorgid
6813: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 8004: MTL_SYSTEM_ITEMS MSI

8000: AND LOCATOR_ID IS NOT NULL
8001: AND NOT EXISTS (
8002: SELECT NULL
8003: FROM MTL_SECONDARY_LOCATORS MSL,
8004: MTL_SYSTEM_ITEMS MSI
8005: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8006: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8007: AND MSI.RESTRICT_LOCATORS_CODE = 1
8008: AND MSL.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 8016: FROM MTL_SYSTEM_ITEMS ITM

8012: AND MSL.SUBINVENTORY_CODE = MTI.SUBINVENTORY_CODE
8013: AND MSL.SECONDARY_LOCATOR = MTI.LOCATOR_ID
8014: UNION
8015: SELECT NULL
8016: FROM MTL_SYSTEM_ITEMS ITM
8017: WHERE ITM.RESTRICT_LOCATORS_CODE = 2
8018: AND ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8019: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID);
8020:

Line 8078: MTL_SYSTEM_ITEMS MSI

8074: AND TRANSFER_LOCATOR IS NOT NULL
8075: AND NOT EXISTS (
8076: SELECT NULL
8077: FROM MTL_SECONDARY_LOCATORS MSL,
8078: MTL_SYSTEM_ITEMS MSI
8079: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
8080: MTI.ORGANIZATION_ID, MTI.TRANSFER_ORGANIZATION)
8081: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8082: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 8092: FROM MTL_SYSTEM_ITEMS MSI

8088: AND MSL.SUBINVENTORY_CODE = MTI.TRANSFER_SUBINVENTORY
8089: AND MSL.SECONDARY_LOCATOR = MTI.TRANSFER_LOCATOR
8090: UNION
8091: SELECT NULL
8092: FROM MTL_SYSTEM_ITEMS MSI
8093: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
8094: MTI.ORGANIZATION_ID, MTI.TRANSFER_ORGANIZATION)
8095: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8096: AND MSI.RESTRICT_LOCATORS_CODE = 2);

Line 12217: FROM mtl_system_items

12213: END IF;
12214:
12215: SELECT serial_number_control_code
12216: INTO l_serial_code
12217: FROM mtl_system_items
12218: WHERE inventory_item_id = l_mti_csr.inventory_item_id
12219: AND organization_id = l_mti_csr.organization_id;
12220: EXCEPTION
12221: WHEN OTHERS

Line 13610: MTL_SYSTEM_ITEMS MSI

13606: p_line_rec_type.TRANSFER_LOCATOR,
13607: p_line_rec_type.transaction_date,
13608: MP.NEGATIVE_INV_RECEIPT_CODE
13609: FROM MTL_PARAMETERS MP,
13610: MTL_SYSTEM_ITEMS MSI
13611: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
13612: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
13613: AND p_line_rec_type.PROCESS_FLAG = 1
13614: --Jalaj Srivastava 5010595

Line 13656: MTL_SYSTEM_ITEMS MSI

13652: p_line_rec_type.transaction_date,
13653: MP.NEGATIVE_INV_RECEIPT_CODE
13654: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
13655: MTL_PARAMETERS MP,
13656: MTL_SYSTEM_ITEMS MSI
13657: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
13658: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
13659: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID
13660: AND p_line_rec_type.PROCESS_FLAG = 1

Line 14784: from mtl_system_items

14780: MATURITY_DAYS,
14781: HOLD_DAYS,
14782: CHILD_LOT_FLAG ,
14783: GRADE_CONTROL_FLAG
14784: from mtl_system_items
14785: WHERE inventory_item_id = p_inventory_item_id
14786: AND organization_id = p_organization_id;
14787:
14788: