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_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 1116: SELECT_COMB_FROM_VIEW => 'MTL_SYSTEM_ITEMS_FVL') ;

1112: STRUCTURE_NUMBER => 101,
1113: CONCAT_SEGMENTS => l_itemsegs,
1114: VALUES_OR_IDS => 'I',
1115: DATA_SET => p_orgid,
1116: SELECT_COMB_FROM_VIEW => 'MTL_SYSTEM_ITEMS_FVL') ;
1117:
1118: if l_result then
1119: x_itemid := fnd_flex_keyval.combination_id;
1120: else

Line 1540: FROM mtl_system_items

1536: , tracking_quantity_ind
1537: , secondary_default_ind
1538: , secondary_uom_code
1539: , primary_uom_code /* Bug 5446542 */
1540: FROM mtl_system_items
1541: WHERE organization_id = org_id
1542: AND inventory_item_id = item_id;
1543:
1544: CURSOR check_gme_reversal IS

Line 1952: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

1948: l_revision VARCHAR(3);
1949: l_subinventory_code VARCHAR(10);
1950: l_locator_id NUMBER;
1951: l_rowid VARCHAR(31);
1952: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1953: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;
1954:
1955: l_qty_check BOOLEAN;
1956: l_lot_control_code number;

Line 1953: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;

1949: l_subinventory_code VARCHAR(10);
1950: l_locator_id NUMBER;
1951: l_rowid VARCHAR(31);
1952: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
1953: l_item_secondary_uom_code mtl_system_items_b.secondary_uom_code%TYPE;
1954:
1955: l_qty_check BOOLEAN;
1956: l_lot_control_code number;
1957:

Line 1962: FROM mtl_system_items

1958: /* get lot control flag */
1959: CURSOR get_item_info( org_id IN NUMBER
1960: , item_id IN NUMBER) IS
1961: SELECT lot_control_code, tracking_quantity_ind, secondary_uom_code
1962: FROM mtl_system_items
1963: WHERE organization_id = org_id
1964: AND inventory_item_id = item_id;
1965:
1966: -- INVCONV end fabdi

Line 2177: FROM MTL_SYSTEM_ITEMS MSI

2173: -- AND ((TRANSACTION_SOURCE_TYPE_ID = 5 AND WIP_SUPPLY_TYPE <> 6) OR
2174: -- (transaction_source_type_id <>5))
2175: AND NOT EXISTS (
2176: SELECT NULL
2177: FROM MTL_SYSTEM_ITEMS MSI
2178: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2179: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2180: AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y');
2181:

Line 2207: FROM MTL_SYSTEM_ITEMS MSI

2203: OR TRANSACTION_SOURCE_TYPE_ID <> 5)
2204: AND PROCESS_FLAG = 1
2205: AND NOT EXISTS (
2206: SELECT NULL
2207: FROM MTL_SYSTEM_ITEMS MSI
2208: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2209: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2210: AND MSI.INVENTORY_ITEM_FLAG = 'Y');
2211:

Line 2238: FROM MTL_SYSTEM_ITEMS MSI

2234: AND PROCESS_FLAG = 1
2235: AND TRANSACTION_ACTION_ID = 24
2236: AND NOT EXISTS (
2237: SELECT NULL
2238: FROM MTL_SYSTEM_ITEMS MSI
2239: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2240: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2241: AND MSI.INVENTORY_ITEM_FLAG = 'Y'
2242: AND MSI.INVENTORY_ASSET_FLAG = 'Y'

Line 2303: FROM MTL_SYSTEM_ITEMS MS1,

2299: AND PROCESS_FLAG = 1
2300: AND TRANSACTION_ACTION_ID = 3 AND TRANSACTION_TYPE_ID <> 54 --Bug 13365231
2301: AND EXISTS (
2302: SELECT NULL
2303: FROM MTL_SYSTEM_ITEMS MS1,
2304: MTL_SYSTEM_ITEMS MS2
2305: WHERE MS1.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2306: AND MS1.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2307: AND MS2.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2304: MTL_SYSTEM_ITEMS MS2

2300: AND TRANSACTION_ACTION_ID = 3 AND TRANSACTION_TYPE_ID <> 54 --Bug 13365231
2301: AND EXISTS (
2302: SELECT NULL
2303: FROM MTL_SYSTEM_ITEMS MS1,
2304: MTL_SYSTEM_ITEMS MS2
2305: WHERE MS1.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2306: AND MS1.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2307: AND MS2.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2308: AND MS2.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION

Line 2338: FROM MTL_SYSTEM_ITEMS MS1,

2334: AND PROCESS_FLAG = 1
2335: AND TRANSACTION_ACTION_ID = 3 AND TRANSACTION_TYPE_ID = 54 --Bug 13365231
2336: AND EXISTS (
2337: SELECT NULL
2338: FROM MTL_SYSTEM_ITEMS MS1,
2339: MTL_SYSTEM_ITEMS MS2
2340: WHERE MS1.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2341: AND MS1.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2342: AND MS2.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2339: MTL_SYSTEM_ITEMS MS2

2335: AND TRANSACTION_ACTION_ID = 3 AND TRANSACTION_TYPE_ID = 54 --Bug 13365231
2336: AND EXISTS (
2337: SELECT NULL
2338: FROM MTL_SYSTEM_ITEMS MS1,
2339: MTL_SYSTEM_ITEMS MS2
2340: WHERE MS1.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2341: AND MS1.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2342: AND MS2.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2343: AND MS2.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION

Line 2382: FROM MTL_SYSTEM_ITEMS MSI

2378: AND PROCESS_FLAG = 1
2379: AND NVL(SHIPPABLE_FLAG,'Y') = 'Y'
2380: AND NOT EXISTS (
2381: SELECT NULL
2382: FROM MTL_SYSTEM_ITEMS MSI
2383: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2384: AND MSI.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2385: AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y');
2386:

Line 2509: MTL_SYSTEM_ITEMS MSI

2505: AND PROCESS_FLAG = 1
2506: AND NOT EXISTS (
2507: SELECT NULL
2508: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2509: MTL_SYSTEM_ITEMS MSI
2510: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2511: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2512: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
2513: AND MIS.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 2520: FROM MTL_SYSTEM_ITEMS ITM

2516: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
2517: AND MIS.SECONDARY_INVENTORY = MTI.SUBINVENTORY_CODE
2518: UNION
2519: SELECT NULL
2520: FROM MTL_SYSTEM_ITEMS ITM
2521: WHERE ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2522: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2523: AND ITM.RESTRICT_SUBINVENTORIES_CODE = 2);
2524:

Line 2557: MTL_SYSTEM_ITEMS MSI

2553: AND TRANSACTION_ACTION_ID in (2,21,3,5)
2554: AND NOT EXISTS (
2555: SELECT NULL
2556: FROM MTL_ITEM_SUB_INVENTORIES MIS,
2557: MTL_SYSTEM_ITEMS MSI
2558: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID, 2,
2559: MTI.ORGANIZATION_ID,
2560: MTI.TRANSFER_ORGANIZATION)
2561: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2572: FROM MTL_SYSTEM_ITEMS ITM

2568: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
2569: AND MIS.SECONDARY_INVENTORY = MTI.TRANSFER_SUBINVENTORY
2570: UNION
2571: SELECT NULL
2572: FROM MTL_SYSTEM_ITEMS ITM
2573: WHERE ITM.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
2574: MTI.ORGANIZATION_ID,
2575: MTI.TRANSFER_ORGANIZATION)
2576: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2648: MTL_SYSTEM_ITEMS ITM

2644: OR (TRANSACTION_ACTION_ID = 21
2645: AND EXISTS (
2646: SELECT 'X'
2647: FROM MTL_SECONDARY_INVENTORIES MSI,
2648: MTL_SYSTEM_ITEMS ITM
2649: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2650: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2651: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
2652: AND ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 2675: MTL_SYSTEM_ITEMS ITM

2671: AND TRANSACTION_ACTION_ID in (2,5)
2672: AND EXISTS (
2673: SELECT 'X'
2674: FROM MTL_SECONDARY_INVENTORIES MSI,
2675: MTL_SYSTEM_ITEMS ITM
2676: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2677: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2678: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
2679: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2685: MTL_SYSTEM_ITEMS ITM

2681: AND MSI.ASSET_INVENTORY = 2)
2682: AND EXISTS (
2683: SELECT 'X'
2684: FROM MTL_SECONDARY_INVENTORIES MSI,
2685: MTL_SYSTEM_ITEMS ITM
2686: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.TRANSFER_SUBINVENTORY
2687: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2688: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
2689: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 3009: MTL_SYSTEM_ITEMS MSI

3005: AND TRANSACTION_ACTION_ID NOT IN (24,33,34)
3006: AND NOT EXISTS (
3007: SELECT NULL
3008: FROM MTL_ITEM_REVISIONS MIR,
3009: MTL_SYSTEM_ITEMS MSI
3010: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
3011: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3012: AND MIR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3013: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 3020: FROM MTL_SYSTEM_ITEMS ITM

3016: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
3017: AND MIR.REVISION = MTI.REVISION
3018: UNION
3019: SELECT NULL
3020: FROM MTL_SYSTEM_ITEMS ITM
3021: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
3022: AND MTI.REVISION IS NULL
3023: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3024: AND ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID);

Line 3049: MTL_SYSTEM_ITEMS MSI

3045: AND TRANSACTION_ACTION_ID = 3
3046: AND NOT EXISTS (
3047: SELECT NULL
3048: FROM MTL_ITEM_REVISIONS MIR,
3049: MTL_SYSTEM_ITEMS MSI
3050: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
3051: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3052: AND MIR.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
3053: AND MIR.REVISION = MTI.REVISION

Line 3060: FROM MTL_SYSTEM_ITEMS ITM

3056: AND MIR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
3057: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
3058: UNION
3059: SELECT NULL
3060: FROM MTL_SYSTEM_ITEMS ITM
3061: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
3062: -- AND MTI.REVISION IS NULL --Bug#3285134. No REVISION validation for Revision to Non-Revision Org Xfer
3063: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3064: AND ITM.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION);

Line 3094: MTL_SYSTEM_ITEMS MSI

3090: AND TRANSACTION_ACTION_ID IN (1, 27, 2)
3091: AND EXISTS (
3092: SELECT NULL
3093: FROM MTL_ITEM_REVISIONS MIR,
3094: MTL_SYSTEM_ITEMS MSI
3095: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
3096: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3097: AND MIR.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3098: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 3446: FROM MTL_SYSTEM_ITEMS MSI,

3442: -- Added the above two lines for the bug # 5896859
3443: AND (TRANSACTION_ACTION_ID IN (1,27)
3444: AND EXISTS (
3445: SELECT NULL
3446: FROM MTL_SYSTEM_ITEMS MSI,
3447: mtl_secondary_inventories MSUB
3448: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3449: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3450: AND MSI.INVENTORY_ASSET_FLAG = 'Y'

Line 4088: FROM MTL_SYSTEM_ITEMS MSI

4084: LAST_UPDATED_BY = p_userid,
4085: LAST_UPDATE_LOGIN = p_loginid,
4086: PROGRAM_UPDATE_DATE = SYSDATE,
4087: SHIPPABLE_FLAG = (SELECT SHIPPABLE_ITEM_FLAG
4088: FROM MTL_SYSTEM_ITEMS MSI
4089: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
4090: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
4091: WHERE TRANSACTION_HEADER_ID = p_header_id
4092: AND INVENTORY_ITEM_ID IS NOT NULL

Line 4217: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP

4213: AND PROCESS_FLAG = 1
4214: AND ((REBUILD_ITEM_ID IS NOT NULL
4215: AND NOT EXISTS (
4216: SELECT NULL
4217: FROM MTL_SYSTEM_ITEMS MSI, MTL_PARAMETERS MP
4218: WHERE MSI.INVENTORY_ITEM_ID = MTI.REBUILD_ITEM_ID
4219: AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
4220: AND MP.MAINT_ORGANIZATION_ID = MTI.ORGANIZATION_ID
4221: AND MSI.EAM_ITEM_TYPE = 3

Line 4227: FROM MTL_SYSTEM_ITEMS MSI

4223:
4224: OR (REBUILD_ACTIVITY_ID IS NOT NULL
4225: AND NOT EXISTS (
4226: SELECT NULL
4227: FROM MTL_SYSTEM_ITEMS MSI
4228: WHERE MSI.INVENTORY_ITEM_ID = MTI.REBUILD_ACTIVITY_ID
4229: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
4230: AND MSI.EAM_ITEM_TYPE = 2)));
4231:

Line 4352: from mtl_system_items

4348:
4349: /* get item information */
4350: CURSOR c_get_item_info IS
4351: SELECT COPY_LOT_ATTRIBUTE_FLAG , child_lot_flag
4352: from mtl_system_items
4353: WHERE inventory_item_id = p_itemid
4354: AND organization_id = p_orgid;
4355:
4356: -- nsinghi bug 5209065. Added the cursor.

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

5856:
5857: /*Bug#5125632. Added the following procedure to update the lot status
5858: of lots for a given line in MTLI, if they are NULL.
5859: Fist MTL_LOT_NUMBERS is checked to find the status. If there is no row in this
5860: table, then, MTL_SYSTEM_ITEMS is checked to fetch the 'default_lot_status_id'
5861: for the corresponding item*/
5862:
5863: Procedure update_status_id_in_mtli( p_txn_interface_id IN NUMBER
5864: ,p_org_id IN NUMBER

Line 5914: FROM mtl_system_items

5910: SELECT lot_status_enabled
5911: ,default_lot_status_id
5912: INTO l_status_enabled
5913: ,l_status_id
5914: FROM mtl_system_items
5915: WHERE organization_id = p_org_id
5916: AND inventory_item_id = p_inventory_item_id;
5917: IF (l_debug = 1) THEN
5918: inv_log_util.trace('After selecting from MSI, Values are:', 'INV_TXN_MANAGER_GRP','1');

Line 7029: FROM MTL_SYSTEM_ITEMS

7025: l_locctrl,
7026: l_lotctrl,
7027: l_serctrl,
7028: l_resloc
7029: FROM MTL_SYSTEM_ITEMS
7030: WHERE INVENTORY_ITEM_ID = l_itemid
7031: AND ORGANIZATION_ID = l_orgid;
7032:
7033: /* Bug 12589617: For these transactions serial details are not

Line 7073: MTL_SYSTEM_ITEMS I

7069: l_shlfdays,
7070: l_lotuniq
7071: FROM MTL_PARAMETERS P,
7072: MTL_SECONDARY_INVENTORIES S,
7073: MTL_SYSTEM_ITEMS I
7074: WHERE I.INVENTORY_ITEM_ID = l_itemid
7075: AND S.SECONDARY_INVENTORY_NAME = l_subinv
7076: AND P.ORGANIZATION_ID = l_orgid
7077: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 7291: MTL_SYSTEM_ITEMS I

7287: l_xserctrl,
7288: l_xresloc
7289: FROM MTL_PARAMETERS P,
7290: MTL_SECONDARY_INVENTORIES S,
7291: MTL_SYSTEM_ITEMS I
7292: WHERE I.INVENTORY_ITEM_ID = l_itemid
7293: AND S.SECONDARY_INVENTORY_NAME = l_xsubinv
7294: AND P.ORGANIZATION_ID = l_xorgid
7295: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 8501: MTL_SYSTEM_ITEMS MSI

8497: AND LOCATOR_ID IS NOT NULL
8498: AND NOT EXISTS (
8499: SELECT NULL
8500: FROM MTL_SECONDARY_LOCATORS MSL,
8501: MTL_SYSTEM_ITEMS MSI
8502: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8503: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8504: AND MSI.RESTRICT_LOCATORS_CODE = 1
8505: AND MSL.ORGANIZATION_ID = MTI.ORGANIZATION_ID

Line 8513: FROM MTL_SYSTEM_ITEMS ITM

8509: AND MSL.SUBINVENTORY_CODE = MTI.SUBINVENTORY_CODE
8510: AND MSL.SECONDARY_LOCATOR = MTI.LOCATOR_ID
8511: UNION
8512: SELECT NULL
8513: FROM MTL_SYSTEM_ITEMS ITM
8514: WHERE ITM.RESTRICT_LOCATORS_CODE = 2
8515: AND ITM.ORGANIZATION_ID = MTI.ORGANIZATION_ID
8516: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID);
8517:

Line 8575: MTL_SYSTEM_ITEMS MSI

8571: AND TRANSFER_LOCATOR IS NOT NULL
8572: AND NOT EXISTS (
8573: SELECT NULL
8574: FROM MTL_SECONDARY_LOCATORS MSL,
8575: MTL_SYSTEM_ITEMS MSI
8576: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
8577: MTI.ORGANIZATION_ID, MTI.TRANSFER_ORGANIZATION)
8578: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8579: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 8589: FROM MTL_SYSTEM_ITEMS MSI

8585: AND MSL.SUBINVENTORY_CODE = MTI.TRANSFER_SUBINVENTORY
8586: AND MSL.SECONDARY_LOCATOR = MTI.TRANSFER_LOCATOR
8587: UNION
8588: SELECT NULL
8589: FROM MTL_SYSTEM_ITEMS MSI
8590: WHERE MSI.ORGANIZATION_ID = decode(MTI.TRANSACTION_ACTION_ID,2,
8591: MTI.ORGANIZATION_ID, MTI.TRANSFER_ORGANIZATION)
8592: AND MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
8593: AND MSI.RESTRICT_LOCATORS_CODE = 2);

Line 12788: FROM mtl_system_items

12784: END IF;
12785:
12786: SELECT serial_number_control_code
12787: INTO l_serial_code
12788: FROM mtl_system_items
12789: WHERE inventory_item_id = l_mti_csr.inventory_item_id
12790: AND organization_id = l_mti_csr.organization_id;
12791: EXCEPTION
12792: WHEN OTHERS

Line 14181: MTL_SYSTEM_ITEMS MSI

14177: p_line_rec_type.TRANSFER_LOCATOR,
14178: p_line_rec_type.transaction_date,
14179: MP.NEGATIVE_INV_RECEIPT_CODE
14180: FROM MTL_PARAMETERS MP,
14181: MTL_SYSTEM_ITEMS MSI
14182: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
14183: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
14184: AND p_line_rec_type.PROCESS_FLAG = 1
14185: --Jalaj Srivastava 5010595

Line 14227: MTL_SYSTEM_ITEMS MSI

14223: p_line_rec_type.transaction_date,
14224: MP.NEGATIVE_INV_RECEIPT_CODE
14225: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
14226: MTL_PARAMETERS MP,
14227: MTL_SYSTEM_ITEMS MSI
14228: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
14229: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'
14230: AND MTLI.TRANSACTION_INTERFACE_ID = p_line_rec_type.TRANSACTION_INTERFACE_ID
14231: AND p_line_rec_type.PROCESS_FLAG = 1

Line 15369: from mtl_system_items

15365: MATURITY_DAYS,
15366: HOLD_DAYS,
15367: CHILD_LOT_FLAG ,
15368: GRADE_CONTROL_FLAG
15369: from mtl_system_items
15370: WHERE inventory_item_id = p_inventory_item_id
15371: AND organization_id = p_organization_id;
15372:
15373: /* Bug# 13539797 cursor to get the txn date from MTI */