APPS.QLTTRAWB dependencies on MTL_SYSTEM_ITEMS

Line 933: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

929: 'QRI.TRANSACTION_INTERFACE_ID ' ||
930: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
931: ' AND QRI.' || COL_NAME || ' IS NULL ' ||
932: ' AND :LOT_CNTRL_CODE = (SELECT MSI.LOT_CONTROL_CODE ' ||
933: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
934: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.' || ITEM_ID_COL ||
935: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
936:
937:

Line 971: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

967: 'QRI.TRANSACTION_INTERFACE_ID ' ||
968: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
969: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||
970: ' AND :LOT_CNTRL_CODE = (SELECT MSI.LOT_CONTROL_CODE ' ||
971: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
972: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.'|| ITEM_ID_COL ||
973: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
974:
975:

Line 1092: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

1088: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1089: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1090: ' AND QRI.' || COL_NAME || ' IS NULL ' ||
1091: ' AND :SERIAL_CNTRL_CODE <> (SELECT MSI.SERIAL_NUMBER_CONTROL_CODE ' ||
1092: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
1093: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.' || ITEM_ID_COL ||
1094: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
1095:
1096:

Line 1130: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

1126: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1127: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1128: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||
1129: ' AND :SERIAL_CNTRL_CODE = (SELECT MSI.SERIAL_NUMBER_CONTROL_CODE ' ||
1130: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
1131: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.' || ITEM_ID_COL ||
1132: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
1133:
1134:

Line 2091: FROM MTL_SYSTEM_ITEMS

2087: CURSOR C IS SELECT RESTRICT_SUBINVENTORIES_CODE,
2088: RESTRICT_LOCATORS_CODE,
2089: LOCATION_CONTROL_CODE,
2090: REVISION_QTY_CONTROL_CODE
2091: FROM MTL_SYSTEM_ITEMS
2092: WHERE INVENTORY_ITEM_ID = CID
2093: AND ORGANIZATION_ID = X_ORG_ID;
2094:
2095: ITM_RST_SINV NUMBER;

Line 5992: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',

5988: X_LAST_UPDATE_LOGIN,
5989: X_REQUEST_ID,
5990: X_PROGRAM_APPLICATION_ID,
5991: X_PROGRAM_ID,
5992: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',
5993: 'qri.asset_group = msikfv.concatenated_segments' ||
5994: ' and msikfv.organization_id = mp.organization_id' ||
5995: ' and msikfv.eam_item_type in (1,3) ' ||
5996: ' and mp.maint_organization_id = qri.organization_id',

Line 5998: ' FROM mtl_system_items_b_kfv msikfv ' ||

5994: ' and msikfv.organization_id = mp.organization_id' ||
5995: ' and msikfv.eam_item_type in (1,3) ' ||
5996: ' and mp.maint_organization_id = qri.organization_id',
5997: 'qri.asset_group_id = (SELECT msikfv.inventory_item_id ' ||
5998: ' FROM mtl_system_items_b_kfv msikfv ' ||
5999: ' WHERE msikfv.concatenated_segments = qri.asset_group ' ||
6000: ' and rownum=1)', --multiple identical ids may belong to same asset group
6001: CHAR_ID_TABLE(I),
6002: CHAR_NAME_TABLE(I),

Line 6226: 'qa_csi_item_instances cii, mtl_system_items_kfv msik ' ||

6222: X_PROGRAM_ID,
6223: 'qa_csi_item_instances cii',
6224: 'qri.item_instance = cii.instance_number',
6225: 'csi_instance_id = (SELECT cii.instance_id FROM ' ||
6226: 'qa_csi_item_instances cii, mtl_system_items_kfv msik ' ||
6227: 'WHERE cii.inventory_item_id = msik.inventory_item_id AND ' ||
6228: 'cii.last_vld_organization_id = msik.organization_id AND ' ||
6229: 'cii.instance_number = qri.item_instance)',
6230: CHAR_ID_TABLE(I),