VIEW: GML.PO_DIST_DTL#

Source

View Text - Preformatted

select DOC_TYPE DOC_TYPE, DOC_ID DOC_ID, LINE_ID LINE_ID, RECV_SEQ_NO RECV_SEQ_NO, SEQ_NO SEQ_NO, AQUI_COST_ID AQUI_COST_ID, ITEM_ID ITEM_ID, ACCTG_UNIT_ID ACCTG_UNIT_ID, ACCT_ID ACCT_ID, ACCT_DESC ACCT_DESC, ACCT_TTL_TYPE ACCT_TTL_TYPE, AMOUNT_BASE AMOUNT_BASE, AMOUNT_TRANS AMOUNT_TRANS, QUANTITY QUANTITY, QUANTITY_UM QUANTITY_UM, PROJECT_NO PROJECT_NO, GL_POSTED_IND GL_POSTED_IND, EXPORTED_DATE EXPORTED_DATE, CURRENCY_TRANS CURRENCY_TRANS, CURRENCY_BASE CURRENCY_BASE, CO_CODE CO_CODE, LEDGER_CODE LEDGER_CODE, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRANS_CNT TRANS_CNT, TEXT_CODE TEXT_CODE, DELETE_MARK DELETE_MARK from "GML"."PO_DIST_DTL"

View Text - HTML Formatted

SELECT DOC_TYPE DOC_TYPE
, DOC_ID DOC_ID
, LINE_ID LINE_ID
, RECV_SEQ_NO RECV_SEQ_NO
, SEQ_NO SEQ_NO
, AQUI_COST_ID AQUI_COST_ID
, ITEM_ID ITEM_ID
, ACCTG_UNIT_ID ACCTG_UNIT_ID
, ACCT_ID ACCT_ID
, ACCT_DESC ACCT_DESC
, ACCT_TTL_TYPE ACCT_TTL_TYPE
, AMOUNT_BASE AMOUNT_BASE
, AMOUNT_TRANS AMOUNT_TRANS
, QUANTITY QUANTITY
, QUANTITY_UM QUANTITY_UM
, PROJECT_NO PROJECT_NO
, GL_POSTED_IND GL_POSTED_IND
, EXPORTED_DATE EXPORTED_DATE
, CURRENCY_TRANS CURRENCY_TRANS
, CURRENCY_BASE CURRENCY_BASE
, CO_CODE CO_CODE
, LEDGER_CODE LEDGER_CODE
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRANS_CNT TRANS_CNT
, TEXT_CODE TEXT_CODE
, DELETE_MARK DELETE_MARK
FROM "GML"."PO_DIST_DTL"