View: GML_GPOAO_ORDERS_V

Product:	GML - Process Manufacturing Logistics
Description:	Sales Order Header view
Implementation/DBA Data:	APPS.GML_GPOAO_ORDERS_V

View Text

SELECT 'EC' COMMUNICATION_METHOD
, ETD.TEST_FLAG TEST_INDICATOR
, ETD.DOCUMENT_ID DOCUMENT_ID
, ETH.TP_HEADER_ID TP_HEADER_ID
, ETD.TP_DETAIL_ID TP_DETAIL_ID
, '00' DOCUMENT_PURPOSE_CODE
, OH.ORDER_NO DOCUMENT_CODE
, ETH.TP_CODE TP_CODE
, ECC.TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, ETH.TP_DESCRIPTION TP_DESCRIPTION
, ETH.TP_REFERENCE_EXT1 TP_REFERENCE1
, ETH.TP_REFERENCE_EXT2 TP_REFERENCE2
, SYSDATE TRANSACTION_DATE
, ETH.ATTRIBUTE_CATEGORY TP_HEADER_CATEGORY
, ETH.ATTRIBUTE1 TP_HEADER_ATTRIBUTE1
, ETH.ATTRIBUTE2 TP_HEADER_ATTRIBUTE2
, ETH.ATTRIBUTE3 TP_HEADER_ATTRIBUTE3
, ETH.ATTRIBUTE4 TP_HEADER_ATTRIBUTE4
, ETH.ATTRIBUTE5 TP_HEADER_ATTRIBUTE5
, ETH.ATTRIBUTE6 TP_HEADER_ATTRIBUTE6
, ETH.ATTRIBUTE7 TP_HEADER_ATTRIBUTE7
, ETH.ATTRIBUTE8 TP_HEADER_ATTRIBUTE8
, ETH.ATTRIBUTE9 TP_HEADER_ATTRIBUTE9
, ETH.ATTRIBUTE10 TP_HEADER_ATTRIBUTE10
, ETH.ATTRIBUTE11 TP_HEADER_ATTRIBUTE11
, ETH.ATTRIBUTE12 TP_HEADER_ATTRIBUTE12
, ETH.ATTRIBUTE13 TP_HEADER_ATTRIBUTE13
, ETH.ATTRIBUTE14 TP_HEADER_ATTRIBUTE14
, ETH.ATTRIBUTE15 TP_HEADER_ATTRIBUTE15
, ETD.ATTRIBUTE_CATEGORY TP_DETAIL_CATEGORY
, ETD.ATTRIBUTE1 TP_DETAIL_ATTRIBUTE1
, ETD.ATTRIBUTE2 TP_DETAIL_ATTRIBUTE2
, ETD.ATTRIBUTE3 TP_DETAIL_ATTRIBUTE3
, ETD.ATTRIBUTE4 TP_DETAIL_ATTRIBUTE4
, ETD.ATTRIBUTE5 TP_DETAIL_ATTRIBUTE5
, OH.ORDER_ID ORDER_ID
, OH.ORDER_NO ORDER_NO
, OH.ORGN_CODE ORGN_CODE
, OH.ORDER_COMMENT ORDER_COMMENT
, OH.ORDER_STATUS ORDER_STATUS
, OS.ORDER_STATUS_CODE ORDER_STATUS_CODE
, OH.CUSTPO_NO CUSTPO_NO
, OH.ORDER_DATE SO_DATE
, OH.FRTBILL_MTHD FRTBILL_MTHD_INT
, FRTM.FRTBILL_DESC FRTBILL_DESC
, OH.EMBARKATION_PORT EMBARKATION_PORT_INT
, PRTM1.PORT_DESC EMBARKATION_PORT_DESC
, OH.DEBARKATION_PORT DEBARKATION_PORT_INT
, PRTM2.PORT_DESC DEBARKATION_PORT_DESC
, OH.FOB_CODE FOB_CODE_INT
, FOBM.FOB_NAME FOB_NAME
, OH.SHIPPER_CODE SHIPPER_CODE_INT
, SCM.SHIPPER_NAME SHIPPER_NAME
, OH.SHIP_MTHD SHIP_MTHD_INT
, SM.MTHD_DESC1 METH_DESC1
, ECC2.CUSTOMER_ID BILLTO_CUST_ID
, ECC2.ORIG_SYSTEM_REFERENCE BILLTO_CODE_INT
, ECC2.TP_LOCATION_CODE_EXT BILLTO_CODE_EXT1
, ECC2.TP_REFERENCE_EXT1 BILLTO_CODE_EXT2
, ECC2.TP_REFERENCE_EXT2 BILLTO_CODE_EXT3
, ECC2.CUSTOMER_NAME BILLTO_CUST_NAME
, ECC2.ADDRESS1 BILLTO_ADDR1
, ECC2.ADDRESS2 BILLTO_ADDR2
, ECC2.ADDRESS3 BILLTO_ADDR3
, ECC2.ADDRESS4 BILLTO_ADDR4
, ECC2.POSTAL_CODE BILLTO_POSTAL_CODE
, ECC2.COUNTRY BILLTO_COUNTRY_CODE_INT
, ECC2.STATE BILLTO_STATE_CODE_INT
, ECC2.PROVINCE BILLTO_PROVINCE_CODE_INT
, ECC2.COUNTY BILLTO_COUNTY
, ECC2.LAST_NAME BILLTO_LAST_NAME
, ECC2.FIRST_NAME BILLTO_FIRST_NAME
, ECC2.JOB_TITLE BILLTO_JOB_TITLE
, ECC2.AREA_CODE BILLTO_AREA_CODE
, ECC2.PHONE_NUMBER BILLTO_TELEPHONE
, ECC.CUSTOMER_ID SHIPTO_CUST_ID
, ECC.ORIG_SYSTEM_REFERENCE SHIPTO_CODE_INT
, ECC.TP_LOCATION_CODE_EXT SHIPTO_CODE_EXT1
, ECC.TP_REFERENCE_EXT1 SHIPTO_CODE_EXT2
, ECC.TP_REFERENCE_EXT2 SHIPTO_CODE_EXT3
, ECC.CUSTOMER_NAME SHIPTO_CUST_NAME
, ECC.ADDRESS1 SHIPTO_ADDR1
, ECC.ADDRESS2 SHIPTO_ADDR2
, ECC.ADDRESS3 SHIPTO_ADDR3
, ECC.ADDRESS4 SHIPTO_ADDR4
, ECC.POSTAL_CODE SHIPTO_POSTAL_CODE
, ECC.COUNTRY SHIPTO_COUNTRY_CODE_INT
, ECC.STATE SHIPTO_STATE_CODE_INT
, ECC.PROVINCE SHIPTO_PROVINCE_CODE_INT
, ECC.COUNTY SHIPTO_COUNTY
, ECC.LAST_NAME SHIPTO_LAST_NAME
, ECC.FIRST_NAME SHIPTO_FIRST_NAME
, ECC.JOB_TITLE SHIPTO_JOB_TITLE
, ECC.AREA_CODE SHIPTO_AREA_CODE
, ECC.PHONE_NUMBER SHIPTO_TELEPHONE
, OH.SHIPADDR_ID SHIPADDR_ID
, SAM.ADDR1 SHIPADDR_ADDR1
, SAM.ADDR2 SHIPADDR_ADDR2
, SAM.ADDR3 SHIPADDR_ADDR3
, SAM.ADDR4 SHIPADDR_ADDR4
, SAM.POSTAL_CODE SHIPADDR_POSTAL_CODE
, SAM.COUNTRY_CODE SHIPADDR_COUNTRY_CODE_INT
, SAM.STATE_CODE SHIPADDR_STATE_CODE_INT
, SAM.PROVINCE SHIPADDR_PROVINCE_CODE_INT
, SAM.COUNTY SHIPADDR_COUNTY
, OH.EDI_TRANS_COUNT EDI_TRANS_CNT
, OH.PRINT_COUNT PRINT_COUNT
, OH.DATE_PRINTED PRINT_DATE
, OH.CREATION_DATE CREATION_DATE
, OH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OH.FROM_WHSE FROM_WHSE
, WM.WHSE_NAME FROM_WHSE_NAME
, WM.WHSE_CONTACT FROM_WHSE_CONTACT
, WM.WHSE_PHONE FROM_WHSE_PHONE
, WAM.ADDR1 FROM_WHSE_ADDR1
, WAM.ADDR2 FROM_WHSE_ADDR2
, WAM.ADDR3 FROM_WHSE_ADDR3
, WAM.ADDR4 FROM_WHSE_ADDR4
, WAM.POSTAL_CODE FROM_WHSE_POSTAL_CODE
, WAM.COUNTRY_CODE FROM_WHSE_COUNTRY_CODE_INT
, WAM.STATE_CODE FROM_WHSE_STATE_CODE_INT
, WAM.PROVINCE FROM_WHSE_PROVINCE_CODE_INT
, WAM.COUNTY FROM_WHSE_COUNTY
, OH.ATTRIBUTE_CATEGORY SO_HEADER_CATEGORY
, OH.ATTRIBUTE1 SO_HEADER_ATTRIBUTE1
, OH.ATTRIBUTE2 SO_HEADER_ATTRIBUTE2
, OH.ATTRIBUTE3 SO_HEADER_ATTRIBUTE3
, OH.ATTRIBUTE4 SO_HEADER_ATTRIBUTE4
, OH.ATTRIBUTE5 SO_HEADER_ATTRIBUTE5
, OH.ATTRIBUTE6 SO_HEADER_ATTRIBUTE6
, OH.ATTRIBUTE7 SO_HEADER_ATTRIBUTE7
, OH.ATTRIBUTE8 SO_HEADER_ATTRIBUTE8
, OH.ATTRIBUTE9 SO_HEADER_ATTRIBUTE9
, OH.ATTRIBUTE10 SO_HEADER_ATTRIBUTE10
, OH.ATTRIBUTE11 SO_HEADER_ATTRIBUTE11
, OH.ATTRIBUTE12 SO_HEADER_ATTRIBUTE12
, OH.ATTRIBUTE13 SO_HEADER_ATTRIBUTE13
, OH.ATTRIBUTE14 SO_HEADER_ATTRIBUTE14
, OH.ATTRIBUTE15 SO_HEADER_ATTRIBUTE15
, OH.ATTRIBUTE16 SO_HEADER_ATTRIBUTE16
, OH.ATTRIBUTE17 SO_HEADER_ATTRIBUTE17
, OH.ATTRIBUTE18 SO_HEADER_ATTRIBUTE18
, OH.ATTRIBUTE19 SO_HEADER_ATTRIBUTE19
, OH.ATTRIBUTE20 SO_HEADER_ATTRIBUTE20
, OH.ATTRIBUTE21 SO_HEADER_ATTRIBUTE21
, OH.ATTRIBUTE22 SO_HEADER_ATTRIBUTE22
, OH.ATTRIBUTE23 SO_HEADER_ATTRIBUTE23
, OH.ATTRIBUTE24 SO_HEADER_ATTRIBUTE24
, OH.ATTRIBUTE25 SO_HEADER_ATTRIBUTE25
, OH.ATTRIBUTE26 SO_HEADER_ATTRIBUTE26
, OH.ATTRIBUTE27 SO_HEADER_ATTRIBUTE27
, OH.ATTRIBUTE28 SO_HEADER_ATTRIBUTE28
, OH.ATTRIBUTE29 SO_HEADER_ATTRIBUTE29
, OH.ATTRIBUTE30 SO_HEADER_ATTRIBUTE30
FROM OP_ORDR_HDR OH
, ECE_TP_HEADERS ETH
, ECE_TP_DETAILS ETD
, GML_EC_CONTACT_V ECC
, ECE_TP_HEADERS ETH2
, ECE_TP_DETAILS ETD2
, GML_EC_CONTACT_V ECC2
, OP_FRGT_MTH FRTM
, OP_PORT_MST PRTM1
, OP_PORT_MST PRTM2
, OP_FOBC_MST FOBM
, OP_SHIP_MST SCM
, OP_SHIP_MTH SM
, IC_WHSE_MST WM
, SY_ADDR_MST WAM
, SY_ADDR_MST SAM
, SY_ADDR_MST BAM
, OP_CUST_MST CM
, OP_CUST_MST CM2
, OP_ORDR_STS OS
WHERE ETD.DOCUMENT_ID = 'GPOAO'
AND ETD.EDI_FLAG = 'Y'
AND ETD.DOCUMENT_ID = ETD2.DOCUMENT_ID
AND ETD.EDI_FLAG = ETD2.EDI_FLAG
AND ETH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ECC.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ETH2.TP_HEADER_ID = ETD2.TP_HEADER_ID
AND ECC2.TP_HEADER_ID = ETD2.TP_HEADER_ID
AND FRTM.FRTBILL_MTHD (+) = OH.FRTBILL_MTHD
AND PRTM1.PORT_CODE (+) = OH.EMBARKATION_PORT
AND PRTM2.PORT_CODE (+) = OH.DEBARKATION_PORT
AND FOBM.FOB_CODE (+) = OH.FOB_CODE
AND SCM.SHIPPER_CODE (+) = OH.SHIPPER_CODE
AND SM.SHIP_MTHD (+) = OH.SHIP_MTHD
AND WM.WHSE_CODE (+) = OH.FROM_WHSE
AND WAM.ADDR_ID (+) = WM.ADDR_ID
AND SAM.ADDR_ID (+) = OH.SHIPADDR_ID
AND CM.CUST_ID = OH.SHIPCUST_ID
AND ECC.CUSTOMER_ID = CM.OF_CUST_ID (+)
AND ECC.SITE_USE_ID = CM.OF_SHIP_TO_SITE_USE_ID (+)
AND ECC.ADDRESS_ID = CM.OF_SHIP_TO_ADDRESS_ID (+)
AND CM2.CUST_ID = OH.BILLCUST_ID
AND BAM.ADDR_ID (+) = CM2.ADDR_ID
AND ECC2.CUSTOMER_ID = CM2.OF_CUST_ID (+)
AND ECC2.SITE_USE_ID = CM2.OF_BILL_TO_SITE_USE_ID (+)
AND ECC2.ADDRESS_ID = CM2.OF_BILL_TO_ADDRESS_ID (+)
AND OH.ORDER_STATUS != -1
AND OH.ORDER_STATUS = OS.ORDER_STATUS

Columns