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_DCP_PVT dependencies on MTL_SYSTEM_ITEMS

Line 241: from mtl_system_items

237: BEGIN
238: if (xfer_org is not null and inv_item_id is not null) then
239: select SERIAL_NUMBER_CONTROL_CODE
240: into xfer_ser_num_code
241: from mtl_system_items
242: where organization_id = xfer_org
243: and inventory_item_id = inv_item_id;
244: end if;
245: EXCEPTION

Line 902: MTL_SYSTEM_ITEMS ITM

898: OR (TRANSACTION_ACTION_ID = 21
899: AND EXISTS (
900: SELECT 'X'
901: FROM MTL_SECONDARY_INVENTORIES MSI,
902: MTL_SYSTEM_ITEMS ITM
903: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
904: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
905: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
906: AND ITM.ORGANIZATION_ID = MMTT.ORGANIZATION_ID

Line 924: MTL_SYSTEM_ITEMS ITM

920: AND inventory_item_id <> -1
921: AND EXISTS (
922: SELECT 'X'
923: FROM MTL_SECONDARY_INVENTORIES MSI,
924: MTL_SYSTEM_ITEMS ITM
925: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
926: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
927: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
928: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID

Line 934: MTL_SYSTEM_ITEMS ITM

930: AND MSI.ASSET_INVENTORY = 2)
931: AND EXISTS (
932: SELECT 'X'
933: FROM MTL_SECONDARY_INVENTORIES MSI,
934: MTL_SYSTEM_ITEMS ITM
935: WHERE MSI.SECONDARY_INVENTORY_NAME = MMTT.TRANSFER_SUBINVENTORY
936: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
937: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
938: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID

Line 992: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

988: AND transaction_action_id not in (24,30)
989: AND inventory_item_id <> -1
990: AND EXISTS (
991: SELECT 'x'
992: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
993: WHERE I.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
994: AND S.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
995: AND P.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
996: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 1019: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

1015: AND inventory_item_id <> -1
1016: AND transaction_action_id not in (24,30)
1017: AND EXISTS (
1018: SELECT 'x'
1019: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
1020: WHERE I.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1021: AND S.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
1022: AND P.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1023: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 1039: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

1035: AND transaction_action_id not in (24,30)
1036: AND inventory_item_id <> -1
1037: AND EXISTS (
1038: SELECT 'x'
1039: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
1040: WHERE I.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1041: AND S.SECONDARY_INVENTORY_NAME = MMTT.SUBINVENTORY_CODE
1042: AND P.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1043: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 1061: MTL_SYSTEM_ITEMS MSI

1057: AND inventory_item_id <> -1
1058: AND NOT EXISTS (
1059: SELECT NULL
1060: FROM MTL_SECONDARY_LOCATORS MSL,
1061: MTL_SYSTEM_ITEMS MSI
1062: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1063: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1064: AND MSI.RESTRICT_LOCATORS_CODE = 1
1065: AND MSL.ORGANIZATION_ID = MMTT.ORGANIZATION_ID

Line 1073: FROM MTL_SYSTEM_ITEMS ITM

1069: AND MSL.SUBINVENTORY_CODE = MMTT.SUBINVENTORY_CODE
1070: AND MSL.SECONDARY_LOCATOR = MMTT.LOCATOR_ID
1071: UNION
1072: SELECT NULL
1073: FROM MTL_SYSTEM_ITEMS ITM
1074: WHERE ITM.RESTRICT_LOCATORS_CODE = 2
1075: AND ITM.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1076: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID);
1077:

Line 1111: MTL_SYSTEM_ITEMS MSI

1107: AND inventory_item_id <> -1
1108: AND NOT EXISTS (
1109: SELECT NULL
1110: FROM MTL_SECONDARY_LOCATORS MSL,
1111: MTL_SYSTEM_ITEMS MSI
1112: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID,2,
1113: MMTT.ORGANIZATION_ID,5,MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
1114: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1115: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 1125: FROM MTL_SYSTEM_ITEMS MSI

1121: AND MSL.SUBINVENTORY_CODE = MMTT.TRANSFER_SUBINVENTORY
1122: AND MSL.SECONDARY_LOCATOR = MMTT.TRANSFER_TO_LOCATION
1123: UNION
1124: SELECT NULL
1125: FROM MTL_SYSTEM_ITEMS MSI
1126: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID,2,
1127: MMTT.ORGANIZATION_ID,5,MMTT.ORGANIZATION_ID,MMTT.TRANSFER_ORGANIZATION)
1128: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1129: AND MSI.RESTRICT_LOCATORS_CODE = 2);

Line 1143: MTL_SYSTEM_ITEMS MSI

1139: AND inventory_item_id <> -1
1140: AND NOT EXISTS (
1141: SELECT NULL
1142: FROM MTL_ITEM_REVISIONS MIR,
1143: MTL_SYSTEM_ITEMS MSI
1144: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
1145: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1146: AND MIR.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1147: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID

Line 1154: FROM MTL_SYSTEM_ITEMS ITM

1150: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
1151: AND MIR.REVISION = MMTT.REVISION
1152: UNION
1153: SELECT NULL
1154: FROM MTL_SYSTEM_ITEMS ITM
1155: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
1156: AND MMTT.REVISION IS NULL
1157: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1158: AND ITM.ORGANIZATION_ID = MMTT.ORGANIZATION_ID);

Line 1173: MTL_SYSTEM_ITEMS MSI

1169: AND inventory_item_id <> -1
1170: AND NOT EXISTS (
1171: SELECT NULL
1172: FROM MTL_ITEM_REVISIONS MIR,
1173: MTL_SYSTEM_ITEMS MSI
1174: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
1175: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1176: AND MIR.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION
1177: AND MIR.REVISION = MMTT.REVISION

Line 1184: FROM MTL_SYSTEM_ITEMS ITM

1180: AND MIR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
1181: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
1182: UNION
1183: SELECT NULL
1184: FROM MTL_SYSTEM_ITEMS ITM
1185: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
1186: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1187: AND ITM.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION);
1188:

Line 1212: FROM mtl_system_items_kfv

1208: AND lookup_type='MTL_TRANSACTION_ACTION';
1209:
1210: CURSOR c_item(p_org_id in number, p_item_id in number) IS
1211: SELECT concatenated_segments
1212: FROM mtl_system_items_kfv
1213: WHERE inventory_item_id = p_item_id
1214: AND organization_id = p_org_id;
1215:
1216: CURSOR c21 is

Line 1228: MTL_SERIAL_NUMBERS_TEMP c,MTL_SYSTEM_ITEMS d

1224: A.TRANSFER_SUBINVENTORY,a.TRANSFER_TO_LOCATION,
1225: b.CURRENT_SUBINVENTORY_CODE,b.CURRENT_LOCATOR_ID,b.REVISION current_revision,
1226: b.CURRENT_STATUS,b.SERIAL_NUMBER,b.current_organization_id,d.SERIAL_NUMBER_CONTROL_CODE
1227: FROM MTL_MATERIAL_TRANSACTIONS_TEMP a,MTL_SERIAL_NUMBERS b,
1228: MTL_SERIAL_NUMBERS_TEMP c,MTL_SYSTEM_ITEMS d
1229: WHERE A.TRANSACTION_TEMP_ID = C.TRANSACTION_TEMP_ID
1230: AND LPAD(B.SERIAL_NUMBER,30) >= LPAD(C.FM_SERIAL_NUMBER,30)
1231: AND LPAD(NVL(B.SERIAL_NUMBER,'-99'),30) <= LPAD(NVL(C.TO_SERIAL_NUMBER,'-99'),30)
1232: AND A.ORGANIZATION_ID = nvl(B.CURRENT_ORGANIZATION_ID,A.ORGANIZATION_ID)