[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
sqltxt := ' SELECT ' ||
' MTRH.HEADER_ID,' ||
' MTRH.REQUEST_NUMBER,' ||
' MTRH.TRANSACTION_TYPE_ID,' ||
' MTRH.MOVE_ORDER_TYPE,' ||
' mp.organization_code || ''('' || MTRH.ORGANIZATION_ID ||'')'' "Organization|Code (Id)", ' ||
' MTRH.ORGANIZATION_ID,' ||
' MTRH.DESCRIPTION,' ||
' MTRH.DATE_REQUIRED,' ||
' MTRH.FROM_SUBINVENTORY_CODE,' ||
' MTRH.TO_SUBINVENTORY_CODE,' ||
' MTRH.TO_ACCOUNT_ID,' ||
' MTRH.HEADER_STATUS,' ||
' MTRH.STATUS_DATE,' ||
' MTRH.LAST_UPDATED_BY,' ||
' MTRH.LAST_UPDATE_LOGIN,' ||
' MTRH.LAST_UPDATE_DATE,' ||
' MTRH.CREATED_BY,' ||
' MTRH.CREATION_DATE,' ||
' MTRH.REQUEST_ID,' ||
' MTRH.PROGRAM_APPLICATION_ID,' ||
' MTRH.PROGRAM_ID,' ||
' MTRH.PROGRAM_UPDATE_DATE,' ||
' MTRH.GROUPING_RULE_ID,' ||
' MTRH.ATTRIBUTE1,' ||
' MTRH.ATTRIBUTE2,' ||
' MTRH.ATTRIBUTE3,' ||
' MTRH.ATTRIBUTE4,' ||
' MTRH.ATTRIBUTE5,' ||
' MTRH.ATTRIBUTE6,' ||
' MTRH.ATTRIBUTE7,' ||
' MTRH.ATTRIBUTE8,' ||
' MTRH.ATTRIBUTE9,' ||
' MTRH.ATTRIBUTE10,' ||
' MTRH.ATTRIBUTE11,' ||
' MTRH.ATTRIBUTE12,' ||
' MTRH.ATTRIBUTE13,' ||
' MTRH.ATTRIBUTE14,' ||
' MTRH.ATTRIBUTE15,' ||
' MTRH.ATTRIBUTE_CATEGORY,' ||
' MTRH.SHIP_TO_LOCATION_ID,' ||
' MTRH.FREIGHT_CODE,' ||
' MTRH.SHIPMENT_METHOD,' ||
' MTRH.AUTO_RECEIPT_FLAG,' ||
' MTRH.REFERENCE_ID,' ||
' MTRH.REFERENCE_DETAIL_ID,' ||
' MTRH.ASSIGNMENT_ID ' ||
' FROM MTL_TXN_REQUEST_HEADERS MTRH, MTL_PARAMETERS mp ' ;
sqltxt := ' SELECT '||
' MTRL.LINE_ID,' ||
' MTRL.HEADER_ID,' ||
' MTRL.LINE_NUMBER,' ||
' mp.organization_code || ''('' || MTRL.ORGANIZATION_ID ||'')'' "Organization|Code (Id)", ' ||
' mif.item_number || ''(''|| mif.inventory_item_id || '')'' "Item (Id)", ' ||
' MTRL.REVISION,' ||
' MTRL.FROM_SUBINVENTORY_CODE,' ||
' MTRL.FROM_LOCATOR_ID,' ||
' MTRL.TO_SUBINVENTORY_CODE,' ||
' MTRL.TO_LOCATOR_ID,' ||
' MTRL.TO_ACCOUNT_ID,' ||
' MTRL.LOT_NUMBER,' ||
' MTRL.SERIAL_NUMBER_START,' ||
' MTRL.SERIAL_NUMBER_END,' ||
' MTRL.UOM_CODE,' ||
' MTRL.QUANTITY,' ||
' MTRL.QUANTITY_DELIVERED,' ||
' MTRL.QUANTITY_DETAILED,' ||
' MTRL.DATE_REQUIRED,' ||
' MTRL.REASON_ID,' ||
' MTRL.REFERENCE,' ||
' MTRL.REFERENCE_TYPE_CODE,' ||
' MTRL.REFERENCE_ID,' ||
' MTRL.PROJECT_ID,' ||
' MTRL.TASK_ID,' ||
' MTRL.TRANSACTION_HEADER_ID,' ||
' MTRL.LINE_STATUS,' ||
' MTRL.STATUS_DATE,' ||
' MTRL.LAST_UPDATED_BY,' ||
' MTRL.LAST_UPDATE_LOGIN,' ||
' MTRL.LAST_UPDATE_DATE,' ||
' MTRL.CREATED_BY,' ||
' MTRL.CREATION_DATE,' ||
' MTRL.REQUEST_ID,' ||
' MTRL.PROGRAM_APPLICATION_ID,' ||
' MTRL.PROGRAM_ID,' ||
' MTRL.PROGRAM_UPDATE_DATE,' ||
' MTRL.ATTRIBUTE1,' ||
' MTRL.ATTRIBUTE2,' ||
' MTRL.ATTRIBUTE3,' ||
' MTRL.ATTRIBUTE4,' ||
' MTRL.ATTRIBUTE5,' ||
' MTRL.ATTRIBUTE6,' ||
' MTRL.ATTRIBUTE7,' ||
' MTRL.ATTRIBUTE8,' ||
' MTRL.ATTRIBUTE9,' ||
' MTRL.ATTRIBUTE10,' ||
' MTRL.ATTRIBUTE11,' ||
' MTRL.ATTRIBUTE12,' ||
' MTRL.ATTRIBUTE13,' ||
' MTRL.ATTRIBUTE14,' ||
' MTRL.ATTRIBUTE15,' ||
' MTRL.ATTRIBUTE_CATEGORY,' ||
' MTRL.TXN_SOURCE_ID,' ||
' MTRL.TXN_SOURCE_LINE_ID,' ||
' MTRL.TXN_SOURCE_LINE_DETAIL_ID,' ||
' MTRL.TRANSACTION_TYPE_ID,' ||
' MTRL.TRANSACTION_SOURCE_TYPE_ID,' ||
' MTRL.PRIMARY_QUANTITY,' ||
' MTRL.TO_ORGANIZATION_ID,' ||
' MTRL.PUT_AWAY_STRATEGY_ID,' ||
' MTRL.PICK_STRATEGY_ID,' ||
' MTRL.SHIP_TO_LOCATION_ID,' ||
' MTRL.UNIT_NUMBER,' ||
' MTRL.REFERENCE_DETAIL_ID,' ||
' MTRL.ASSIGNMENT_ID,' ||
' MTRL.FROM_COST_GROUP_ID,' ||
' MTRL.TO_COST_GROUP_ID,' ||
' MTRL.LPN_ID,' ||
' MTRL.TO_LPN_ID,' ||
' MTRL.PICK_SLIP_NUMBER,' ||
' MTRL.PICK_SLIP_DATE,' ||
' MTRL.INSPECTION_STATUS,' ||
' MTRL.PICK_METHODOLOGY_ID,' ||
' MTRL.CONTAINER_ITEM_ID,' ||
' MTRL.CARTON_GROUPING_ID,' ||
' MTRL.BACKORDER_DELIVERY_DETAIL_ID,' ||
' MTRL.WMS_PROCESS_FLAG,' ||
' MTRL.SHIP_SET_ID,' ||
' MTRL.SHIP_MODEL_ID,' ||
' MTRL.MODEL_QUANTITY,' ||
' MTRL.FROM_SUBINVENTORY_ID,' ||
' MTRL.TO_SUBINVENTORY_ID,' ||
' MTRL.CROSSDOCK_TYPE,' ||
' MTRL.REQUIRED_QUANTITY' ||
' FROM MTL_TXN_REQUEST_LINES MTRL, MTL_PARAMETERS mp, MTL_ITEM_FLEXFIELDS mif ' ||
' WHERE MTRL.organization_id = mp.organization_id ' ||
' AND MTRL.inventory_item_id = mif.inventory_item_id(+) ' ||
' AND MTRL.organization_id = mif.organization_id(+) ' ;