View: ECE_MVSTO_HEADERS_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts header informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Header View@rep:category BUSINESS_ENTITY INV_MOVEM
Implementation/DBA Data:	APPS.ECE_MVSTO_HEADERS_V

View Text

SELECT 'EDI' COMMUNICATION_METHOD
, ETPD.TEST_FLAG TP_TEST_FLAG
, 'MVSTO' TP_DOCUMENT_ID
, ETPD.DOCUMENT_TYPE TP_DOCUMENT_TYPE
, ETPD.TRANSLATOR_CODE TRANSLATOR_CODE
, HRL.ECE_TP_LOCATION_CODE TP_LOCATION_CODE_EXT
, ETPH.TP_DESCRIPTION TP_DESCRIPTION
, ETPH.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, ETPH.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, SYSDATE TRANSACTION_DATE
, NULL TRANSACTION_CONTROL1
, NULL TRANSACTION_CONTROL2
, NULL TRANSACTION_CONTROL3
, ETPD.DOCUMENT_STANDARD DOCUMENT_STANDARD
, ETPH.ATTRIBUTE_CATEGORY TPH_ATTRIBUTE_CATEGORY
, ETPH.ATTRIBUTE1 TPH_ATTRIBUTE1
, ETPH.ATTRIBUTE2 TPH_ATTRIBUTE2
, ETPH.ATTRIBUTE3 TPH_ATTRIBUTE3
, ETPH.ATTRIBUTE4 TPH_ATTRIBUTE4
, ETPH.ATTRIBUTE5 TPH_ATTRIBUTE5
, ETPH.ATTRIBUTE6 TPH_ATTRIBUTE6
, ETPH.ATTRIBUTE7 TPH_ATTRIBUTE7
, ETPH.ATTRIBUTE8 TPH_ATTRIBUTE8
, ETPH.ATTRIBUTE9 TPH_ATTRIBUTE9
, ETPH.ATTRIBUTE10 TPH_ATTRIBUTE10
, ETPH.ATTRIBUTE11 TPH_ATTRIBUTE11
, ETPH.ATTRIBUTE12 TPH_ATTRIBUTE12
, ETPH.ATTRIBUTE13 TPH_ATTRIBUTE13
, ETPH.ATTRIBUTE14 TPH_ATTRIBUTE14
, ETPH.ATTRIBUTE15 TPH_ATTRIBUTE15
, ETPD.ATTRIBUTE_CATEGORY TPD_ATTRIBUTE_CATEGORY
, ETPD.ATTRIBUTE1 TPD_ATTRIBUTE1
, ETPD.ATTRIBUTE2 TPD_ATTRIBUTE2
, ETPD.ATTRIBUTE3 TPD_ATTRIBUTE3
, ETPD.ATTRIBUTE4 TPD_ATTRIBUTE4
, ETPD.ATTRIBUTE5 TPD_ATTRIBUTE5
, EMMSV.PERIOD_NAME PERIOD_NAME
, EMMSV.EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE
, EMMSV.EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE
, EMMSV.MOVEMENT_TYPE MOVEMENT_TYPE
, EMMSV.REPORT_REFERENCE REPORT_REFERENCE
, EMMSV.REPORT_DATE REPORT_DATE
, EMMSV.STAT_TYPE STAT_TYPE
, EMMSV.USAGE_TYPE USAGE_TYPE
, EMMSV.MOVEMENT_STATUS MOVEMENT_STATUS
, EMMSV.ZONE_CODE ZONE_CODE
, HRE.ORGANIZATION_ID LEGAL_ENTITY
, HRE.NAME LEGAL_ENTITY_NAME
, NULL LEGAL_ENTITY_VAT_CODE
, HRL.TAX_NAME LEGAL_ENTITY_TAX_NAME
, EMMSV.ORGANIZATION_ID ORGANIZATION_ID
, HRL.LOCATION_ID CUSTOMER_ID
, HRL.ECE_TP_LOCATION_CODE ECE_TP_LOC_CODE
, HRL.LOCATION_CODE CUSTOMER_NAME
, HRL.ADDRESS_LINE_1 ADDRESS1
, HRL.ADDRESS_LINE_2 ADDRESS2
, HRL.ADDRESS_LINE_3 ADDRESS3
, HRL.TOWN_OR_CITY CITY
, HRL.POSTAL_CODE POSTAL_CODE
, HRL.COUNTRY COUNTRY
, HRL.REGION_1 REGION1
, HRL.REGION_2 REGION2
, HRL.REGION_3 REGION3
, EMMSV.ENTITY_ORG_ID ENTITY_ORG_ID
, EMMSV.TOTAL_INVOICE_EXT_VALUE TOTAL_INVOICE_EXT_VALUE
, EMMSV.TOTAL_SUPPLEMENTARY_UNITS TOTAL_SUPPLEMENTARY_UNITS
, EMMSV.TOTAL_STATISTICAL_VALUE TOTAL_STATISTICAL_VALUE
, EMMSV.TOTAL_TOTAL_WEIGHT TOTAL_TOTAL_WEIGHT
, EMMSV.TOTAL_RECORDS TOTAL_RECORDS
, ETPD.MAP_ID MAP_ID
FROM ECE_TP_HEADERS ETPH
, ECE_TP_DETAILS ETPD
, HR_ORGANIZATION_UNITS HOU
, HR_LOCATIONS HRL
, HR_LEGAL_ENTITIES HRE
, ECE_MTL_MOV_STAT_V EMMSV
WHERE ETPH.TP_HEADER_ID = ETPD.TP_HEADER_ID
AND ETPD.DOCUMENT_ID = 'MVSTO'
AND ETPD.EDI_FLAG = 'Y'
AND EMMSV.ENTITY_ORG_ID = HRE.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HRE.ORGANIZATION_ID
AND HOU.LOCATION_ID = HRL.LOCATION_ID
AND HRL.TP_HEADER_ID = ETPH.TP_HEADER_ID

Columns