eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: GML.GML_GPOAO_DETAIL_ALLOCATIONS#

Source

View Text - Preformatted


select RUN_ID RUN_ID, LINE_ID LINE_ID, TRANS_ID TRANS_ID, LOT_NO LOT_NO, VENDOR_LOT_NO VENDOR_LOT_NO, SUBLOT_NO SUBLOT_NO, LOT_DESCRIPTION LOT_DESCRIPTION, LOT_STATUS LOT_STATUS, STATUS_DESC STATUS_DESC, LOCATION LOCATION, LOCT_DESC LOCT_DESC, QC_GRADE QC_GRADE, QC_GRADE_DESC QC_GRADE_DESC, REASON_CODE REASON_CODE, LOT_CREATED LOT_CREATED, EXPIRE_DATE EXPIRE_DATE, QUANTITY1 QUANTITY1, UOM1_INT UOM1_INT, UOM1_EXT1 UOM1_EXT1, UOM1_EXT2 UOM1_EXT2, UOM1_EXT3 UOM1_EXT3, UOM1_EXT4 UOM1_EXT4, UOM1_EXT5 UOM1_EXT5, QUANTITY2 QUANTITY2, UOM2_INT UOM2_INT, UOM2_EXT1 UOM2_EXT1, UOM2_EXT2 UOM2_EXT2, UOM2_EXT3 UOM2_EXT3, UOM2_EXT4 UOM2_EXT4, UOM2_EXT5 UOM2_EXT5, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "GML"."GML_GPOAO_DETAIL_ALLOCATIONS"

View Text - HTML Formatted

SELECT RUN_ID RUN_ID
, LINE_ID LINE_ID
, TRANS_ID TRANS_ID
, LOT_NO LOT_NO
, VENDOR_LOT_NO VENDOR_LOT_NO
, SUBLOT_NO SUBLOT_NO
, LOT_DESCRIPTION LOT_DESCRIPTION
, LOT_STATUS LOT_STATUS
, STATUS_DESC STATUS_DESC
, LOCATION LOCATION
, LOCT_DESC LOCT_DESC
, QC_GRADE QC_GRADE
, QC_GRADE_DESC QC_GRADE_DESC
, REASON_CODE REASON_CODE
, LOT_CREATED LOT_CREATED
, EXPIRE_DATE EXPIRE_DATE
, QUANTITY1 QUANTITY1
, UOM1_INT UOM1_INT
, UOM1_EXT1 UOM1_EXT1
, UOM1_EXT2 UOM1_EXT2
, UOM1_EXT3 UOM1_EXT3
, UOM1_EXT4 UOM1_EXT4
, UOM1_EXT5 UOM1_EXT5
, QUANTITY2 QUANTITY2
, UOM2_INT UOM2_INT
, UOM2_EXT1 UOM2_EXT1
, UOM2_EXT2 UOM2_EXT2
, UOM2_EXT3 UOM2_EXT3
, UOM2_EXT4 UOM2_EXT4
, UOM2_EXT5 UOM2_EXT5
, TRANSACTION_RECORD_ID TRANSACTION_RECORD_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "GML"."GML_GPOAO_DETAIL_ALLOCATIONS"