VIEW: GML.CPG_PURCHASING_ARCH#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, ORGN_CODE ORGN_CODE, PO_NO PO_NO, BPO_NO BPO_NO, PO_STATUS PO_STATUS, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PO_RELEASE_ID PO_RELEASE_ID, RELEASE_NUM RELEASE_NUM, BUYER_CODE BUYER_CODE, PO_ID PO_ID, BPO_ID BPO_ID, BPO_RELEASE_NUMBER BPO_RELEASE_NUMBER, OF_PAYVEND_SITE_ID OF_PAYVEND_SITE_ID, OF_SHIPVEND_SITE_ID OF_SHIPVEND_SITE_ID, PO_DATE PO_DATE, PO_TYPE PO_TYPE, FROM_WHSE FROM_WHSE, TO_WHSE TO_WHSE, RECV_DESC RECV_DESC, RECV_LOCT RECV_LOCT, RECVADDR_ID RECVADDR_ID, SHIP_MTHD SHIP_MTHD, SHIPPER_CODE SHIPPER_CODE, OF_FRTBILL_MTHD OF_FRTBILL_MTHD, OF_TERMS_CODE OF_TERMS_CODE, BILLING_CURRENCY BILLING_CURRENCY, PURCHASE_EXCHANGE_RATE PURCHASE_EXCHANGE_RATE, MUL_DIV_SIGN MUL_DIV_SIGN, CURRENCY_BGHT_FWD CURRENCY_BGHT_FWD, POHOLD_CODE POHOLD_CODE, CANCELLATION_CODE CANCELLATION_CODE, FOB_CODE FOB_CODE, ICPURCH_CLASS ICPURCH_CLASS, VENDSO_NO VENDSO_NO, PROJECT_NO PROJECT_NO, REQUESTED_DLVDATE REQUESTED_DLVDATE, SCHED_SHIPDATE SCHED_SHIPDATE, REQUIRED_DLVDATE REQUIRED_DLVDATE, AGREED_DLVDATE AGREED_DLVDATE, DATE_PRINTED DATE_PRINTED, EXPEDITE_DATE EXPEDITE_DATE, REVISION_COUNT REVISION_COUNT, IN_USE IN_USE, PRINT_COUNT PRINT_COUNT, LINE_NO LINE_NO, LINE_STATUS LINE_STATUS, LINE_ID LINE_ID, BPO_LINE_ID BPO_LINE_ID, APINV_LINE_ID APINV_LINE_ID, ITEM_NO ITEM_NO, GENERIC_ID GENERIC_ID, ITEM_DESC ITEM_DESC, ORDER_QTY1 ORDER_QTY1, ORDER_QTY2 ORDER_QTY2, ORDER_UM1 ORDER_UM1, ORDER_UM2 ORDER_UM2, RECEIVED_QTY1 RECEIVED_QTY1, RECEIVED_QTY2 RECEIVED_QTY2, NET_PRICE NET_PRICE, EXTENDED_PRICE EXTENDED_PRICE, PRICE_UM PRICE_UM, QC_GRADE_WANTED QC_GRADE_WANTED, MATCH_TYPE MATCH_TYPE, TEXT_CODE TEXT_CODE, TRANS_CNT TRANS_CNT, EXPORTED_DATE EXPORTED_DATE, 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, DELETE_MARK DELETE_MARK, INVALID_IND INVALID_IND, REL_COUNT REL_COUNT, CONTRACT_NO CONTRACT_NO, CONTRACT_VALUE CONTRACT_VALUE, CONTRACT_END_DATE CONTRACT_END_DATE, CONTRACT_START_DATE CONTRACT_START_DATE, AMOUNT_PURCHASED AMOUNT_PURCHASED, ACTIVITY_IND ACTIVITY_IND, CONTRACT_QTY CONTRACT_QTY, ITEM_UM ITEM_UM, QTY_PURCHASED QTY_PURCHASED, STD_QTY STD_QTY, RELEASE_INTERVAL RELEASE_INTERVAL, BPO_STATUS BPO_STATUS, BPOHOLD_CODE BPOHOLD_CODE, CLOSURE_CODE CLOSURE_CODE, MAX_RELS_QTY MAX_RELS_QTY, ORGNADDR_ID ORGNADDR_ID, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID, PURCH_CATEGORY_ID PURCH_CATEGORY_ID from "GML"."CPG_PURCHASING_ARCH"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, ORGN_CODE ORGN_CODE
, PO_NO PO_NO
, BPO_NO BPO_NO
, PO_STATUS PO_STATUS
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PO_RELEASE_ID PO_RELEASE_ID
, RELEASE_NUM RELEASE_NUM
, BUYER_CODE BUYER_CODE
, PO_ID PO_ID
, BPO_ID BPO_ID
, BPO_RELEASE_NUMBER BPO_RELEASE_NUMBER
, OF_PAYVEND_SITE_ID OF_PAYVEND_SITE_ID
, OF_SHIPVEND_SITE_ID OF_SHIPVEND_SITE_ID
, PO_DATE PO_DATE
, PO_TYPE PO_TYPE
, FROM_WHSE FROM_WHSE
, TO_WHSE TO_WHSE
, RECV_DESC RECV_DESC
, RECV_LOCT RECV_LOCT
, RECVADDR_ID RECVADDR_ID
, SHIP_MTHD SHIP_MTHD
, SHIPPER_CODE SHIPPER_CODE
, OF_FRTBILL_MTHD OF_FRTBILL_MTHD
, OF_TERMS_CODE OF_TERMS_CODE
, BILLING_CURRENCY BILLING_CURRENCY
, PURCHASE_EXCHANGE_RATE PURCHASE_EXCHANGE_RATE
, MUL_DIV_SIGN MUL_DIV_SIGN
, CURRENCY_BGHT_FWD CURRENCY_BGHT_FWD
, POHOLD_CODE POHOLD_CODE
, CANCELLATION_CODE CANCELLATION_CODE
, FOB_CODE FOB_CODE
, ICPURCH_CLASS ICPURCH_CLASS
, VENDSO_NO VENDSO_NO
, PROJECT_NO PROJECT_NO
, REQUESTED_DLVDATE REQUESTED_DLVDATE
, SCHED_SHIPDATE SCHED_SHIPDATE
, REQUIRED_DLVDATE REQUIRED_DLVDATE
, AGREED_DLVDATE AGREED_DLVDATE
, DATE_PRINTED DATE_PRINTED
, EXPEDITE_DATE EXPEDITE_DATE
, REVISION_COUNT REVISION_COUNT
, IN_USE IN_USE
, PRINT_COUNT PRINT_COUNT
, LINE_NO LINE_NO
, LINE_STATUS LINE_STATUS
, LINE_ID LINE_ID
, BPO_LINE_ID BPO_LINE_ID
, APINV_LINE_ID APINV_LINE_ID
, ITEM_NO ITEM_NO
, GENERIC_ID GENERIC_ID
, ITEM_DESC ITEM_DESC
, ORDER_QTY1 ORDER_QTY1
, ORDER_QTY2 ORDER_QTY2
, ORDER_UM1 ORDER_UM1
, ORDER_UM2 ORDER_UM2
, RECEIVED_QTY1 RECEIVED_QTY1
, RECEIVED_QTY2 RECEIVED_QTY2
, NET_PRICE NET_PRICE
, EXTENDED_PRICE EXTENDED_PRICE
, PRICE_UM PRICE_UM
, QC_GRADE_WANTED QC_GRADE_WANTED
, MATCH_TYPE MATCH_TYPE
, TEXT_CODE TEXT_CODE
, TRANS_CNT TRANS_CNT
, EXPORTED_DATE EXPORTED_DATE
, 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
, DELETE_MARK DELETE_MARK
, INVALID_IND INVALID_IND
, REL_COUNT REL_COUNT
, CONTRACT_NO CONTRACT_NO
, CONTRACT_VALUE CONTRACT_VALUE
, CONTRACT_END_DATE CONTRACT_END_DATE
, CONTRACT_START_DATE CONTRACT_START_DATE
, AMOUNT_PURCHASED AMOUNT_PURCHASED
, ACTIVITY_IND ACTIVITY_IND
, CONTRACT_QTY CONTRACT_QTY
, ITEM_UM ITEM_UM
, QTY_PURCHASED QTY_PURCHASED
, STD_QTY STD_QTY
, RELEASE_INTERVAL RELEASE_INTERVAL
, BPO_STATUS BPO_STATUS
, BPOHOLD_CODE BPOHOLD_CODE
, CLOSURE_CODE CLOSURE_CODE
, MAX_RELS_QTY MAX_RELS_QTY
, ORGNADDR_ID ORGNADDR_ID
, SOURCE_SHIPMENT_ID SOURCE_SHIPMENT_ID
, PURCH_CATEGORY_ID PURCH_CATEGORY_ID
FROM "GML"."CPG_PURCHASING_ARCH"