[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
sqltxt := 'SELECT ' ||
' MR.RESERVATION_ID "RESERVATION_ID",' ||
' MR.REQUIREMENT_DATE "REQUIREMENT_DATE",' ||
' mif.item_number||''(''||mif.inventory_item_id||'')'' "Item (Id)",' ||
' mp.organization_code|| '' (''||mr.organization_id ||'')'' "Organization|Code (Id)",' ||
' MR.DEMAND_SOURCE_TYPE_ID "DEMAND_SOURCE_TYPE_ID",' ||
' MR.DEMAND_SOURCE_NAME "DEMAND_SOURCE_NAME",' ||
' MR.DEMAND_SOURCE_HEADER_ID "DEMAND_SOURCE_HEADER_ID",' ||
' MR.DEMAND_SOURCE_LINE_ID "DEMAND_SOURCE_LINE_ID",' ||
' MR.DEMAND_SOURCE_DELIVERY "DEMAND_SOURCE_DELIVERY",' ||
' MR.PRIMARY_UOM_CODE "PRIMARY_UOM_CODE",' ||
' MR.PRIMARY_UOM_ID "PRIMARY_UOM_ID",' ||
' MR.RESERVATION_UOM_CODE "RESERVATION_UOM_CODE",' ||
' MR.RESERVATION_UOM_ID "RESERVATION_UOM_ID",' ||
' MR.RESERVATION_QUANTITY "RESERVATION_QUANTITY",' ||
' MR.PRIMARY_RESERVATION_QUANTITY "PRIMARY_RESERVATION_QUANTITY",' ||
' MR.AUTODETAIL_GROUP_ID "AUTODETAIL_GROUP_ID",' ||
' MR.EXTERNAL_SOURCE_CODE "EXTERNAL_SOURCE_CODE",' ||
' MR.EXTERNAL_SOURCE_LINE_ID "EXTERNAL_SOURCE_LINE_ID",' ||
' MR.SUPPLY_SOURCE_TYPE_ID "SUPPLY_SOURCE_TYPE_ID",' ||
' MR.SUPPLY_SOURCE_HEADER_ID "SUPPLY_SOURCE_HEADER_ID",' ||
' MR.SUPPLY_SOURCE_LINE_ID "SUPPLY_SOURCE_LINE_ID",' ||
' MR.SUPPLY_SOURCE_LINE_DETAIL "SUPPLY_SOURCE_LINE_DETAIL",' ||
' MR.SUPPLY_SOURCE_NAME "SUPPLY_SOURCE_NAME",' ||
' MR.REVISION "REVISION",' ||
' MR.SUBINVENTORY_CODE "SUBINVENTORY_CODE",' ||
' MR.SUBINVENTORY_ID "SUBINVENTORY_ID",' ||
' MR.LOCATOR_ID "LOCATOR_ID",' ||
' MR.LOT_NUMBER "LOT_NUMBER",' ||
' MR.LOT_NUMBER_ID "LOT_NUMBER_ID",' ||
' MR.SERIAL_NUMBER "SERIAL_NUMBER",' ||
' MR.SERIAL_NUMBER_ID "SERIAL_NUMBER_ID",' ||
' MR.PARTIAL_QUANTITIES_ALLOWED "PARTIAL_QUANTITIES_ALLOWED",' ||
' MR.AUTO_DETAILED "AUTO_DETAILED",' ||
' MR.PICK_SLIP_NUMBER "PICK_SLIP_NUMBER",' ||
' MR.LPN_ID "LPN_ID",' ||
' MR.LAST_UPDATE_DATE "LAST_UPDATE_DATE",' ||
' MR.LAST_UPDATED_BY "LAST_UPDATED_BY",' ||
' MR.CREATION_DATE "CREATION_DATE",' ||
' MR.CREATED_BY "CREATED_BY",' ||
' MR.LAST_UPDATE_LOGIN "LAST_UPDATE_LOGIN",' ||
' MR.REQUEST_ID "REQUEST_ID",' ||
' MR.PROGRAM_APPLICATION_ID "PROGRAM_APPLICATION_ID",' ||
' MR.PROGRAM_ID "PROGRAM_ID",' ||
' MR.PROGRAM_UPDATE_DATE "PROGRAM_UPDATE_DATE",' ||
' MR.ATTRIBUTE_CATEGORY "ATTRIBUTE_CATEGORY",' ||
' MR.ATTRIBUTE1 "ATTRIBUTE1",' ||
' MR.ATTRIBUTE2 "ATTRIBUTE2",' ||
' MR.ATTRIBUTE3 "ATTRIBUTE3",' ||
' MR.ATTRIBUTE4 "ATTRIBUTE4",' ||
' MR.ATTRIBUTE5 "ATTRIBUTE5",' ||
' MR.ATTRIBUTE6 "ATTRIBUTE6",' ||
' MR.ATTRIBUTE7 "ATTRIBUTE7",' ||
' MR.ATTRIBUTE8 "ATTRIBUTE8",' ||
' MR.ATTRIBUTE9 "ATTRIBUTE9",' ||
' MR.ATTRIBUTE10 "ATTRIBUTE10",' ||
' MR.ATTRIBUTE11 "ATTRIBUTE11",' ||
' MR.ATTRIBUTE12 "ATTRIBUTE12",' ||
' MR.ATTRIBUTE13 "ATTRIBUTE13",' ||
' MR.ATTRIBUTE14 "ATTRIBUTE14",' ||
' MR.ATTRIBUTE15 "ATTRIBUTE15",' ||
' MR.SHIP_READY_FLAG "SHIP_READY_FLAG",' ||
' MR.N_COLUMN1 "N_COLUMN1",' ||
' MR.DETAILED_QUANTITY "DETAILED_QUANTITY",' ||
' MR.COST_GROUP_ID "COST_GROUP_ID",' ||
' MR.CONTAINER_LPN_ID "CONTAINER_LPN_ID",' ||
' MR.STAGED_FLAG "STAGED_FLAG "' ||
' FROM MTL_RESERVATIONS MR, MTL_PARAMETERS mp, MTL_ITEM_FLEXFIELDS mif' ||
' WHERE MR.organization_id = mp.organization_id' ||
' and MR.inventory_item_id = mif.inventory_item_id(+)' ||
' and MR.organization_id = mif.organization_id(+) ' ;
sqltxt := 'SELECT ' ||
' MS.SUPPLY_TYPE_CODE,' ||
' MS.SUPPLY_SOURCE_ID,' ||
' MS.LAST_UPDATED_BY,' ||
' MS.LAST_UPDATE_DATE,' ||
' MS.LAST_UPDATE_LOGIN,' ||
' MS.CREATED_BY,' ||
' MS.CREATION_DATE,' ||
' MS.REQUEST_ID,' ||
' MS.PROGRAM_APPLICATION_ID,' ||
' MS.PROGRAM_ID,' ||
' MS.PROGRAM_UPDATE_DATE,' ||
' MS.REQ_HEADER_ID,' ||
' MS.REQ_LINE_ID,' ||
' MS.PO_HEADER_ID,' ||
' MS.PO_RELEASE_ID,' ||
' MS.PO_LINE_ID,' ||
' MS.PO_LINE_LOCATION_ID,' ||
' MS.PO_DISTRIBUTION_ID,' ||
' MS.SHIPMENT_HEADER_ID,' ||
' MS.SHIPMENT_LINE_ID,' ||
' MS.RCV_TRANSACTION_ID,' ||
' MS.ITEM_ID,' ||
' mif.item_number || ''(''|| mif.inventory_item_id || '')'' "Item (Id)", ' ||
' MS.ITEM_REVISION,' ||
' MS.CATEGORY_ID,' ||
' MS.QUANTITY,' ||
' MS.UNIT_OF_MEASURE,' ||
' MS.TO_ORG_PRIMARY_QUANTITY,' ||
' MS.TO_ORG_PRIMARY_UOM,' ||
' MS.RECEIPT_DATE,' ||
' MS.NEED_BY_DATE,' ||
' MS.EXPECTED_DELIVERY_DATE,' ||
' MS.DESTINATION_TYPE_CODE,' ||
' MS.LOCATION_ID,' ||
' mp.organization_code || ''('' || ms.from_organization_id ||'')'' "From Organization|Code (Id)", ' ||
' MS.FROM_SUBINVENTORY,' ||
' mpTo.organization_code || ''('' || ms.to_organization_id ||'')'' "To Organization|Code (Id)", ' ||
' MS.TO_SUBINVENTORY,' ||
' MS.INTRANSIT_OWNING_ORG_ID,' ||
' MS.MRP_PRIMARY_QUANTITY,' ||
' MS.MRP_PRIMARY_UOM,' ||
' MS.MRP_EXPECTED_DELIVERY_DATE,' ||
' MS.MRP_DESTINATION_TYPE_CODE,' ||
' MS.MRP_TO_ORGANIZATION_ID,' ||
' MS.MRP_TO_SUBINVENTORY,' ||
' MS.CHANGE_FLAG,' ||
' MS.CHANGE_TYPE,' ||
' MS.COST_GROUP_ID ' ||
' FROM MTL_SUPPLY MS, MTL_PARAMETERS mp, MTL_ITEM_FLEXFIELDS mif, MTL_PARAMETERS mpTo ' ||
' WHERE ms.from_organization_id = mp.organization_id ' ||
' AND ms.item_id = mif.inventory_item_id(+) ' ||
' AND ms.from_organization_id = mif.organization_id(+) ' ||
' AND ms.to_organization_id = mpTo.organization_id ' ;