View: ECE_MTL_MOV_STAT_V

Product:	EC - e-Commerce Gateway
Description:	Contains the movement type information for documents with EDI transactions pending.
Implementation/DBA Data:	APPS.ECE_MTL_MOV_STAT_V

View Text

SELECT MMS.MOVEMENT_TYPE MOVEMENT_TYPE
, MMS.PERIOD_NAME PERIOD_NAME
, MMS.EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE
, MMS.EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE
, MMS.REPORT_REFERENCE REPORT_REFERENCE
, MMS.REPORT_DATE REPORT_DATE
, MMS.STAT_TYPE STAT_TYPE
, MMS.USAGE_TYPE USAGE_TYPE
, MMS.MOVEMENT_STATUS MOVEMENT_STATUS
, MMS.ZONE_CODE ZONE_CODE
, MMS.ORGANIZATION_ID ORGANIZATION_ID
, MMS.ENTITY_ORG_ID ENTITY_ORG_ID
, SUM(NVL(MMS.INVOICE_LINE_EXT_VALUE
, 0)) TOTAL_INVOICE_EXT_VALUE
, SUM(NVL(MMS.STAT_EXT_VALUE
, 0)) TOTAL_SUPPLEMENTARY_UNITS
, SUM(NVL(MMS.MOVEMENT_AMOUNT
, 0)) TOTAL_STATISTICAL_VALUE
, SUM(NVL(MMS.TOTAL_WEIGHT
, 0)) TOTAL_TOTAL_WEIGHT
, COUNT(*) TOTAL_RECORDS
FROM MTL_MOVEMENT_STATISTICS MMS
, FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'MVT_SOURCE_DOCUMENT_TYPES'
AND FL.LOOKUP_CODE = MMS.DOCUMENT_SOURCE_TYPE
AND (MMS.MOVEMENT_STATUS = 'V' OR MMS.MOVEMENT_STATUS = 'F')
AND NVL(MMS.EDI_SENT_FLAG
, 'N') = 'N' GROUP BY MOVEMENT_TYPE
, PERIOD_NAME
, EDI_TRANSACTION_REFERENCE
, EDI_TRANSACTION_DATE
, REPORT_REFERENCE
, REPORT_DATE
, STAT_TYPE
, USAGE_TYPE
, MOVEMENT_STATUS
, ZONE_CODE
, ORGANIZATION_ID
, ENTITY_ORG_ID

Columns