VIEW: APPS.ECE_MVSTO_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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