[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
sqltxt := ' SELECT' ||
' MPA.ADJUSTMENT_ID,' ||
' mp.organization_code || ''('' || mpa.organization_id ||'')'' "Organization|Code (Id)", ' ||
' MPA.PHYSICAL_INVENTORY_ID,' ||
' mif.item_number || ''(''|| mif.inventory_item_id || '')'' "Item (Id)", ' ||
' MPA.SUBINVENTORY_NAME,' ||
' MPA.SYSTEM_QUANTITY,' ||
' MPA.LAST_UPDATE_DATE,' ||
' MPA.LAST_UPDATED_BY,' ||
' MPA.CREATION_DATE,' ||
' MPA.CREATED_BY,' ||
' MPA.LAST_UPDATE_LOGIN,' ||
' MPA.COUNT_QUANTITY,' ||
' MPA.ADJUSTMENT_QUANTITY,' ||
' MPA.REVISION,' ||
' MPA.LOCATOR_ID,' ||
' MPA.LOT_NUMBER,' ||
' MPA.LOT_EXPIRATION_DATE,' ||
' MPA.SERIAL_NUMBER,' ||
' MPA.ACTUAL_COST,' ||
' MPA.APPROVAL_STATUS,' ||
' MPA.APPROVED_BY_EMPLOYEE_ID,' ||
' MPA.AUTOMATIC_APPROVAL_CODE,' ||
' MPA.GL_ADJUST_ACCOUNT,' ||
' MPA.REQUEST_ID,' ||
' MPA.PROGRAM_APPLICATION_ID,' ||
' MPA.PROGRAM_ID,' ||
' MPA.PROGRAM_UPDATE_DATE,' ||
' MPA.LOT_SERIAL_CONTROLS,' ||
' MPA.TEMP_APPROVER,' ||
' MPA.PARENT_LPN_ID,' ||
' MPA.OUTERMOST_LPN_ID,' ||
' MPA.COST_GROUP_ID' ||
' FROM MTL_PHYSICAL_ADJUSTMENTS MPA, MTL_PARAMETERS mp, MTL_ITEM_FLEXFIELDS mif ' ||
' WHERE MPA.ORGANIZATION_ID = mp.organization_id ' ||
' AND MPA.INVENTORY_ITEM_ID = mif.inventory_item_id(+) ' ||
' AND MPA.ORGANIZATION_ID = mif.organization_id(+) ' ;
sqltxt := ' SELECT' ||
' MPIT.TAG_ID,' ||
' MPIT.PHYSICAL_INVENTORY_ID,' ||
' mp.organization_code || ''('' || mpit.organization_id ||'')'' "Organization|Code (Id)", ' ||
' MPIT.LAST_UPDATE_DATE,' ||
' MPIT.LAST_UPDATED_BY,' ||
' MPIT.CREATION_DATE,' ||
' MPIT.CREATED_BY,' ||
' MPIT.LAST_UPDATE_LOGIN,' ||
' MPIT.VOID_FLAG,' ||
' MPIT.TAG_NUMBER,' ||
' MPIT.ADJUSTMENT_ID,' ||
' mif.item_number || ''(''|| mif.inventory_item_id || '')'' "Item (Id)", ' ||
' MPIT.TAG_QUANTITY,' ||
' MPIT.TAG_UOM,' ||
' MPIT.TAG_QUANTITY_AT_STANDARD_UOM,' ||
' MPIT.STANDARD_UOM,' ||
' MPIT.SUBINVENTORY,' ||
' MPIT.LOCATOR_ID,' ||
' MPIT.LOT_NUMBER,' ||
' MPIT.LOT_EXPIRATION_DATE,' ||
' MPIT.REVISION,' ||
' MPIT.SERIAL_NUM,' ||
' MPIT.COUNTED_BY_EMPLOYEE_ID,' ||
' MPIT.LOT_SERIAL_CONTROLS,' ||
' MPIT.ATTRIBUTE_CATEGORY,' ||
' MPIT.ATTRIBUTE1,' ||
' MPIT.ATTRIBUTE2,' ||
' MPIT.ATTRIBUTE3,' ||
' MPIT.ATTRIBUTE4,' ||
' MPIT.ATTRIBUTE5,' ||
' MPIT.ATTRIBUTE6,' ||
' MPIT.ATTRIBUTE7,' ||
' MPIT.ATTRIBUTE8,' ||
' MPIT.ATTRIBUTE9,' ||
' MPIT.ATTRIBUTE10,' ||
' MPIT.ATTRIBUTE11,' ||
' MPIT.ATTRIBUTE12,' ||
' MPIT.ATTRIBUTE13,' ||
' MPIT.ATTRIBUTE14,' ||
' MPIT.ATTRIBUTE15,' ||
' MPIT.REQUEST_ID,' ||
' MPIT.PROGRAM_APPLICATION_ID,' ||
' MPIT.PROGRAM_ID,' ||
' MPIT.PROGRAM_UPDATE_DATE,' ||
' MPIT.PARENT_LPN_ID,' ||
' MPIT.OUTERMOST_LPN_ID,' ||
' MPIT.COST_GROUP_ID ' ||
' FROM MTL_PHYSICAL_INVENTORY_TAGS MPIT, MTL_PARAMETERS mp, MTL_ITEM_FLEXFIELDS mif ' ||
' WHERE mpit.ORGANIZATION_ID = mp.organization_id ' ||
' AND mpit.INVENTORY_ITEM_ID = mif.inventory_item_id(+) ' ||
' AND mpit.ORGANIZATION_ID = mif.organization_id(+) ' ;
sqltxt := ' SELECT ' ||
' MPI.PHYSICAL_INVENTORY_ID,' ||
' mp.organization_code || ''('' || mpi.organization_id ||'')'' "Organization|Code (Id)", ' ||
' MPI.LAST_UPDATE_DATE,' ||
' MPI.LAST_UPDATED_BY,' ||
' MPI.CREATION_DATE,' ||
' MPI.CREATED_BY,' ||
' MPI.LAST_UPDATE_LOGIN,' ||
' MPI.PHYSICAL_INVENTORY_DATE,' ||
' MPI.LAST_ADJUSTMENT_DATE,' ||
' MPI.TOTAL_ADJUSTMENT_VALUE,' ||
' MPI.DESCRIPTION,' ||
' MPI.FREEZE_DATE,' ||
' MPI.PHYSICAL_INVENTORY_NAME,' ||
' MPI.APPROVAL_REQUIRED,' ||
' MPI.ALL_SUBINVENTORIES_FLAG,' ||
' MPI.NEXT_TAG_NUMBER,' ||
' MPI.TAG_NUMBER_INCREMENTS,' ||
' MPI.DEFAULT_GL_ADJUST_ACCOUNT,' ||
' MPI.REQUEST_ID,' ||
' MPI.PROGRAM_APPLICATION_ID,' ||
' MPI.PROGRAM_ID,' ||
' MPI.PROGRAM_UPDATE_DATE,' ||
' MPI.APPROVAL_TOLERANCE_POS,' ||
' MPI.APPROVAL_TOLERANCE_NEG,' ||
' MPI.COST_VARIANCE_POS,' ||
' MPI.COST_VARIANCE_NEG,' ||
' MPI.NUMBER_OF_SKUS,' ||
' MPI.DYNAMIC_TAG_ENTRY_FLAG,' ||
' MPI.ATTRIBUTE1,' ||
' MPI.ATTRIBUTE2,' ||
' MPI.ATTRIBUTE3,' ||
' MPI.ATTRIBUTE4,' ||
' MPI.ATTRIBUTE5,' ||
' MPI.ATTRIBUTE6,' ||
' MPI.ATTRIBUTE7,' ||
' MPI.ATTRIBUTE8,' ||
' MPI.ATTRIBUTE9,' ||
' MPI.ATTRIBUTE10,' ||
' MPI.ATTRIBUTE11,' ||
' MPI.ATTRIBUTE12,' ||
' MPI.ATTRIBUTE13,' ||
' MPI.ATTRIBUTE14,' ||
' MPI.ATTRIBUTE15,' ||
' MPI.ATTRIBUTE_CATEGORY' ||
' FROM MTL_PHYSICAL_INVENTORIES MPI, MTL_PARAMETERS mp ' ||
' WHERE mpi.ORGANIZATION_ID = mp.organization_id ' ;