VIEW: APPS.ECE_MTL_MOV_STAT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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