APPS.QLTTRAWB dependencies on MTL_SYSTEM_ITEMS

Line 939: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

935: 'QRI.TRANSACTION_INTERFACE_ID ' ||
936: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
937: ' AND QRI.' || COL_NAME || ' IS NULL ' ||
938: ' AND :LOT_CNTRL_CODE = (SELECT MSI.LOT_CONTROL_CODE ' ||
939: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
940: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.' || ITEM_ID_COL ||
941: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
942:
943:

Line 981: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

977: 'QRI.TRANSACTION_INTERFACE_ID ' ||
978: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
979: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||
980: ' AND :LOT_CNTRL_CODE = (SELECT MSI.LOT_CONTROL_CODE ' ||
981: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
982: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.'|| ITEM_ID_COL ||
983: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
984:
985:

Line 1107: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

1103: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1104: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1105: ' AND QRI.' || COL_NAME || ' IS NULL ' ||
1106: ' AND :SERIAL_CNTRL_CODE <> (SELECT MSI.SERIAL_NUMBER_CONTROL_CODE ' ||
1107: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
1108: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.' || ITEM_ID_COL ||
1109: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
1110:
1111:

Line 1149: ' FROM MTL_SYSTEM_ITEMS MSI ' ||

1145: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1146: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1147: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||
1148: ' AND :SERIAL_CNTRL_CODE = (SELECT MSI.SERIAL_NUMBER_CONTROL_CODE ' ||
1149: ' FROM MTL_SYSTEM_ITEMS MSI ' ||
1150: ' WHERE MSI.INVENTORY_ITEM_ID = QRI.' || ITEM_ID_COL ||
1151: ' AND MSI.ORGANIZATION_ID = QRI.ORGANIZATION_ID)';
1152:
1153:

Line 2184: FROM MTL_SYSTEM_ITEMS

2180: CURSOR C IS SELECT RESTRICT_SUBINVENTORIES_CODE,
2181: RESTRICT_LOCATORS_CODE,
2182: LOCATION_CONTROL_CODE,
2183: REVISION_QTY_CONTROL_CODE
2184: FROM MTL_SYSTEM_ITEMS
2185: WHERE INVENTORY_ITEM_ID = CID
2186: AND ORGANIZATION_ID = X_ORG_ID;
2187:
2188: ITM_RST_SINV NUMBER;

Line 6360: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',

6356: X_LAST_UPDATE_LOGIN,
6357: X_REQUEST_ID,
6358: X_PROGRAM_APPLICATION_ID,
6359: X_PROGRAM_ID,
6360: 'mtl_system_items_b_kfv msikfv, mtl_parameters mp',
6361: 'qri.asset_group = msikfv.concatenated_segments' ||
6362: ' and msikfv.organization_id = mp.organization_id' ||
6363: ' and msikfv.eam_item_type in (1,3) ' ||
6364: ' and mp.maint_organization_id = qri.organization_id',

Line 6366: ' FROM mtl_system_items_b_kfv msikfv ' ||

6362: ' and msikfv.organization_id = mp.organization_id' ||
6363: ' and msikfv.eam_item_type in (1,3) ' ||
6364: ' and mp.maint_organization_id = qri.organization_id',
6365: 'qri.asset_group_id = (SELECT msikfv.inventory_item_id ' ||
6366: ' FROM mtl_system_items_b_kfv msikfv ' ||
6367: ' WHERE msikfv.concatenated_segments = qri.asset_group ' ||
6368: ' and rownum=1)', --multiple identical ids may belong to same asset group
6369: CHAR_ID_TABLE(I),
6370: CHAR_NAME_TABLE(I),

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

6590: X_PROGRAM_ID,
6591: 'qa_csi_item_instances cii',
6592: 'qri.item_instance = cii.instance_number',
6593: 'csi_instance_id = (SELECT cii.instance_id FROM ' ||
6594: 'qa_csi_item_instances cii, mtl_system_items_kfv msik ' ||
6595: 'WHERE cii.inventory_item_id = msik.inventory_item_id AND ' ||
6596: 'cii.last_vld_organization_id = msik.organization_id AND ' ||
6597: 'cii.instance_number = qri.item_instance)',
6598: CHAR_ID_TABLE(I),