DBA Data[Home] [Help]

VIEW: APPS.ECE_MVSTO_DETAILS_V

Source

View Text - Preformatted

SELECT MMS.EDI_SENT_FLAG EDI_SENT_FLAG, MMS.PERIOD_NAME PERIOD_NAME, MMS.EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE, MMS.EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE, MMS.TRANSACTION_DATE TRANSACTION_DATE, MMS.SET_OF_BOOKS_PERIOD SET_OF_BOOKS_PERIOD, MMS.CREATION_METHOD CREATION_METHOD, MMS.FLOW_INDICATOR_CODE FLOW_INDICATOR_CODE, MMS.STAT_METHOD STAT_METHOD, MMS.STAT_TYPE STAT_TYPE, MMS.TRANSPORT_MODE TRANSPORT_MODE, MMS.TRANSACTION_NATURE TRANSACTION_NATURE, MMS.STATISTICAL_PROCEDURE_CODE MOVEMENT_NATURE_CODE, MMS.ORIGIN_TERRITORY_EU_CODE ORIGIN_TERRITORY_EU_CODE, MMS.ORIGIN_TERRITORY_CODE ORIGIN_TERRITORY_CODE, MMS.DESTINATION_TERRITORY_EU_CODE DESTINATION_TERRITORY_EU_CODE, MMS.DESTINATION_TERRITORY_CODE DESTINATION_TERRITORY_CODE, MMS.DISPATCH_TERRITORY_EU_CODE DISPATCH_TERRITORY_EU_CODE, MMS.DISPATCH_TERRITORY_CODE DISPATCH_TERRITORY_CODE, MMS.TRIANGULATION_COUNTRY_EU_CODE TRIANGULATION_COUNTRY_EU_CODE, MMS.TRIANGULATION_COUNTRY_CODE TRIANGULATION_COUNTRY_CODE, MMS.PORT PORT, MMS.AREA AREA, MMS.MOVEMENT_ID MOVEMENT_ID, MMS.MOVEMENT_TYPE MOVEMENT_TYPE, MMS.ZONE_CODE ZONE_CODE, MMS.CURRENCY_CODE CURRENCY_CODE, MMS.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, MMS.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, MMS.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, MMS.MOVEMENT_AMOUNT MOVEMENT_AMOUNT, MMS.ITEM_COST ITEM_COST, MMS.DOCUMENT_UNIT_PRICE DOCUMENT_UNIT_PRICE, MMS.DOCUMENT_LINE_EXT_VALUE DOCUMENT_LINE_EXT_VALUE, MMS.OUTSIDE_CODE OUTSIDE_CODE, MMS.OUTSIDE_EXT_VALUE OUTSIDE_EXT_VALUE, MMS.OUTSIDE_UNIT_PRICE OUTSIDE_UNIT_PRICE, MMS.STAT_ADJ_AMOUNT STAT_ADJ_AMOUNT, MMS.STAT_ADJ_PERCENT STAT_ADJ_PERCENT, MMS.STAT_EXT_VALUE STAT_EXT_VALUE, MMS.DELIVERY_TERMS DELIVERY_TERMS, MMS.PRIMARY_QUANTITY PRIMARY_QUANTITY, MMS.TRANSACTION_QUANTITY TRANSACTION_QUANTITY, MMS.TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE, MMS.WEIGHT_METHOD WEIGHT_METHOD, MMS.UNIT_WEIGHT UNIT_WEIGHT, MMS.TOTAL_WEIGHT TOTAL_WEIGHT, MMS.TOTAL_WEIGHT_UOM_CODE TOTAL_WEIGHT_UOM_CODE, MMS.ALTERNATE_QUANTITY ALTERNATE_QUANTITY, MMS.ALTERNATE_UOM_CODE ALTERNATE_UOM_CODE, MMS.COMMODITY_CODE COMMODITY_CODE, MMS.COMMODITY_DESCRIPTION COMMODITY_DESCRIPTION, MMS.COMMENTS COMMENTS, MMS.ITEM_DESCRIPTION ITEM_DESCRIPTION, MMS.DOCUMENT_SOURCE_TYPE DOCUMENT_SOURCE_TYPE, MMS.DOCUMENT_REFERENCE DOCUMENT_REFERENCE, MMS.DOCUMENT_LINE_REFERENCE DOCUMENT_LINE_REFERENCE, MMS.TRANSACTING_FROM_ORG TRANSACTING_FROM_ORG, MMS.TRANSACTING_TO_ORG TRANSACTING_TO_ORG, MMS.DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, MMS.AFFILIATION_REFERENCE_CODE AFFILIATION_REFERENCE_CODE, MMS.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE, MMS.CSA_CODE CSA_CODE, MMS.OIL_REFERENCE_CODE OIL_REFERENCE_CODE, MMS.PICK_SLIP_REFERENCE PICK_SLIP_REFERENCE, MMS.PREFERENCE_CODE PREFERENCE_CODE, MMS.RECEIPT_REFERENCE RECEIPT_REFERENCE, MMS.SHIPMENT_LINE_REFERENCE SHIPMENT_LINE_REFERENCE, MMS.SHIPMENT_REFERENCE SHIPMENT_REFERENCE, MMS.TARIC_CODE TARIC_CODE, MMS.INVOICE_BATCH_REFERENCE INVOICE_BATCH_REFERENCE, MMS.INVOICE_DATE_REFERENCE INVOICE_DATE_REFERENCE, MMS.INVOICE_LINE_EXT_VALUE INVOICE_LINE_EXT_VALUE, MMS.INVOICE_LINE_REFERENCE INVOICE_LINE_REFERENCE, MMS.INVOICE_QUANTITY INVOICE_QUANTITY, MMS.INVOICE_REFERENCE INVOICE_REFERENCE, MMS.INVOICE_UNIT_PRICE INVOICE_UNIT_PRICE, MMS.INVOICE_BATCH_ID INVOICE_BATCH_ID, MMS.INVOICE_ID INVOICE_ID, MMS.CUSTOMER_LOCATION CUSTOMER_LOCATION, MMS.CUSTOMER_NAME CUSTOMER_NAME, MMS.CUSTOMER_NUMBER CUSTOMER_NUMBER, MMS.BILL_TO_NAME BILL_TO_NAME, MMS.BILL_TO_NUMBER BILL_TO_NUMBER, MMS.BILL_TO_SITE BILL_TO_SITE, MMS.SHIP_TO_NAME SHIP_TO_NAME, MMS.SHIP_TO_NUMBER SHIP_TO_NUMBER, MMS.SHIP_TO_SITE SHIP_TO_SITE, MMS.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID, MMS.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, MMS.SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, MMS.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, MMS.VENDOR_NAME VENDOR_NAME, MMS.VENDOR_NUMBER VENDOR_NUMBER, MMS.VENDOR_SITE VENDOR_SITE, MMS.VENDOR_ID VENDOR_ID, MMS.VENDOR_SITE_ID VENDOR_SITE_ID, MMS.CATEGORY_ID CATEGORY_ID, MMS.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, MMS.FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, MMS.TO_ORGANIZATION_ID TO_ORGANIZATION_ID, MMS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, MMS.MTL_TRANSACTION_ID MTL_TRANSACTION_ID, MMS.RCV_TRANSACTION_ID RCV_TRANSACTION_ID, MMS.ORDER_HEADER_ID ORDER_HEADER_ID, MMS.ORDER_LINE_ID ORDER_LINE_ID, MMS.ORGANIZATION_ID ORGANIZATION_ID, MMS.PARENT_MOVEMENT_ID PARENT_MOVEMENT_ID, MMS.PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID, MMS.PICKING_LINE_ID PICKING_LINE_ID, MMS.PO_HEADER_ID PO_HEADER_ID, MMS.PO_LINE_ID PO_LINE_ID, MMS.PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, MMS.REQUISITION_HEADER_ID REQUISITION_HEADER_ID, MMS.REQUISITION_LINE_ID REQUISITION_LINE_ID, MMS.SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, MMS.SHIPMENT_LINE_ID SHIPMENT_LINE_ID, MMS.CREATED_BY CREATED_BY, MMS.CREATION_DATE CREATION_DATE, MMS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MMS.LAST_UPDATED_BY LAST_UPDATED_BY, MMS.LAST_UPDATE_DATE LAST_UPDATE_DATE, MMS.ENTITY_ORG_ID ENTITY_ORG_ID, MMS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, MMS.ATTRIBUTE1 ATTRIBUTE1, MMS.ATTRIBUTE2 ATTRIBUTE2, MMS.ATTRIBUTE3 ATTRIBUTE3, MMS.ATTRIBUTE4 ATTRIBUTE4, MMS.ATTRIBUTE5 ATTRIBUTE5, MMS.ATTRIBUTE6 ATTRIBUTE6, MMS.ATTRIBUTE7 ATTRIBUTE7, MMS.ATTRIBUTE8 ATTRIBUTE8, MMS.ATTRIBUTE9 ATTRIBUTE9, MMS.ATTRIBUTE10 ATTRIBUTE10, MMS.ATTRIBUTE11 ATTRIBUTE11, MMS.ATTRIBUTE12 ATTRIBUTE12, MMS.ATTRIBUTE13 ATTRIBUTE13, MMS.ATTRIBUTE14 ATTRIBUTE14, MMS.ATTRIBUTE15 ATTRIBUTE15, NULL TRANSACTION_HEADER_ID 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'
View Text - HTML Formatted

SELECT MMS.EDI_SENT_FLAG EDI_SENT_FLAG
, MMS.PERIOD_NAME PERIOD_NAME
, MMS.EDI_TRANSACTION_REFERENCE EDI_TRANSACTION_REFERENCE
, MMS.EDI_TRANSACTION_DATE EDI_TRANSACTION_DATE
, MMS.TRANSACTION_DATE TRANSACTION_DATE
, MMS.SET_OF_BOOKS_PERIOD SET_OF_BOOKS_PERIOD
, MMS.CREATION_METHOD CREATION_METHOD
, MMS.FLOW_INDICATOR_CODE FLOW_INDICATOR_CODE
, MMS.STAT_METHOD STAT_METHOD
, MMS.STAT_TYPE STAT_TYPE
, MMS.TRANSPORT_MODE TRANSPORT_MODE
, MMS.TRANSACTION_NATURE TRANSACTION_NATURE
, MMS.STATISTICAL_PROCEDURE_CODE MOVEMENT_NATURE_CODE
, MMS.ORIGIN_TERRITORY_EU_CODE ORIGIN_TERRITORY_EU_CODE
, MMS.ORIGIN_TERRITORY_CODE ORIGIN_TERRITORY_CODE
, MMS.DESTINATION_TERRITORY_EU_CODE DESTINATION_TERRITORY_EU_CODE
, MMS.DESTINATION_TERRITORY_CODE DESTINATION_TERRITORY_CODE
, MMS.DISPATCH_TERRITORY_EU_CODE DISPATCH_TERRITORY_EU_CODE
, MMS.DISPATCH_TERRITORY_CODE DISPATCH_TERRITORY_CODE
, MMS.TRIANGULATION_COUNTRY_EU_CODE TRIANGULATION_COUNTRY_EU_CODE
, MMS.TRIANGULATION_COUNTRY_CODE TRIANGULATION_COUNTRY_CODE
, MMS.PORT PORT
, MMS.AREA AREA
, MMS.MOVEMENT_ID MOVEMENT_ID
, MMS.MOVEMENT_TYPE MOVEMENT_TYPE
, MMS.ZONE_CODE ZONE_CODE
, MMS.CURRENCY_CODE CURRENCY_CODE
, MMS.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, MMS.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, MMS.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, MMS.MOVEMENT_AMOUNT MOVEMENT_AMOUNT
, MMS.ITEM_COST ITEM_COST
, MMS.DOCUMENT_UNIT_PRICE DOCUMENT_UNIT_PRICE
, MMS.DOCUMENT_LINE_EXT_VALUE DOCUMENT_LINE_EXT_VALUE
, MMS.OUTSIDE_CODE OUTSIDE_CODE
, MMS.OUTSIDE_EXT_VALUE OUTSIDE_EXT_VALUE
, MMS.OUTSIDE_UNIT_PRICE OUTSIDE_UNIT_PRICE
, MMS.STAT_ADJ_AMOUNT STAT_ADJ_AMOUNT
, MMS.STAT_ADJ_PERCENT STAT_ADJ_PERCENT
, MMS.STAT_EXT_VALUE STAT_EXT_VALUE
, MMS.DELIVERY_TERMS DELIVERY_TERMS
, MMS.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MMS.TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, MMS.TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE
, MMS.WEIGHT_METHOD WEIGHT_METHOD
, MMS.UNIT_WEIGHT UNIT_WEIGHT
, MMS.TOTAL_WEIGHT TOTAL_WEIGHT
, MMS.TOTAL_WEIGHT_UOM_CODE TOTAL_WEIGHT_UOM_CODE
, MMS.ALTERNATE_QUANTITY ALTERNATE_QUANTITY
, MMS.ALTERNATE_UOM_CODE ALTERNATE_UOM_CODE
, MMS.COMMODITY_CODE COMMODITY_CODE
, MMS.COMMODITY_DESCRIPTION COMMODITY_DESCRIPTION
, MMS.COMMENTS COMMENTS
, MMS.ITEM_DESCRIPTION ITEM_DESCRIPTION
, MMS.DOCUMENT_SOURCE_TYPE DOCUMENT_SOURCE_TYPE
, MMS.DOCUMENT_REFERENCE DOCUMENT_REFERENCE
, MMS.DOCUMENT_LINE_REFERENCE DOCUMENT_LINE_REFERENCE
, MMS.TRANSACTING_FROM_ORG TRANSACTING_FROM_ORG
, MMS.TRANSACTING_TO_ORG TRANSACTING_TO_ORG
, MMS.DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, MMS.AFFILIATION_REFERENCE_CODE AFFILIATION_REFERENCE_CODE
, MMS.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, MMS.CSA_CODE CSA_CODE
, MMS.OIL_REFERENCE_CODE OIL_REFERENCE_CODE
, MMS.PICK_SLIP_REFERENCE PICK_SLIP_REFERENCE
, MMS.PREFERENCE_CODE PREFERENCE_CODE
, MMS.RECEIPT_REFERENCE RECEIPT_REFERENCE
, MMS.SHIPMENT_LINE_REFERENCE SHIPMENT_LINE_REFERENCE
, MMS.SHIPMENT_REFERENCE SHIPMENT_REFERENCE
, MMS.TARIC_CODE TARIC_CODE
, MMS.INVOICE_BATCH_REFERENCE INVOICE_BATCH_REFERENCE
, MMS.INVOICE_DATE_REFERENCE INVOICE_DATE_REFERENCE
, MMS.INVOICE_LINE_EXT_VALUE INVOICE_LINE_EXT_VALUE
, MMS.INVOICE_LINE_REFERENCE INVOICE_LINE_REFERENCE
, MMS.INVOICE_QUANTITY INVOICE_QUANTITY
, MMS.INVOICE_REFERENCE INVOICE_REFERENCE
, MMS.INVOICE_UNIT_PRICE INVOICE_UNIT_PRICE
, MMS.INVOICE_BATCH_ID INVOICE_BATCH_ID
, MMS.INVOICE_ID INVOICE_ID
, MMS.CUSTOMER_LOCATION CUSTOMER_LOCATION
, MMS.CUSTOMER_NAME CUSTOMER_NAME
, MMS.CUSTOMER_NUMBER CUSTOMER_NUMBER
, MMS.BILL_TO_NAME BILL_TO_NAME
, MMS.BILL_TO_NUMBER BILL_TO_NUMBER
, MMS.BILL_TO_SITE BILL_TO_SITE
, MMS.SHIP_TO_NAME SHIP_TO_NAME
, MMS.SHIP_TO_NUMBER SHIP_TO_NUMBER
, MMS.SHIP_TO_SITE SHIP_TO_SITE
, MMS.BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_ID
, MMS.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, MMS.SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, MMS.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, MMS.VENDOR_NAME VENDOR_NAME
, MMS.VENDOR_NUMBER VENDOR_NUMBER
, MMS.VENDOR_SITE VENDOR_SITE
, MMS.VENDOR_ID VENDOR_ID
, MMS.VENDOR_SITE_ID VENDOR_SITE_ID
, MMS.CATEGORY_ID CATEGORY_ID
, MMS.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, MMS.FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, MMS.TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, MMS.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MMS.MTL_TRANSACTION_ID MTL_TRANSACTION_ID
, MMS.RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, MMS.ORDER_HEADER_ID ORDER_HEADER_ID
, MMS.ORDER_LINE_ID ORDER_LINE_ID
, MMS.ORGANIZATION_ID ORGANIZATION_ID
, MMS.PARENT_MOVEMENT_ID PARENT_MOVEMENT_ID
, MMS.PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID
, MMS.PICKING_LINE_ID PICKING_LINE_ID
, MMS.PO_HEADER_ID PO_HEADER_ID
, MMS.PO_LINE_ID PO_LINE_ID
, MMS.PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, MMS.REQUISITION_HEADER_ID REQUISITION_HEADER_ID
, MMS.REQUISITION_LINE_ID REQUISITION_LINE_ID
, MMS.SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, MMS.SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, MMS.CREATED_BY CREATED_BY
, MMS.CREATION_DATE CREATION_DATE
, MMS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MMS.LAST_UPDATED_BY LAST_UPDATED_BY
, MMS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MMS.ENTITY_ORG_ID ENTITY_ORG_ID
, MMS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MMS.ATTRIBUTE1 ATTRIBUTE1
, MMS.ATTRIBUTE2 ATTRIBUTE2
, MMS.ATTRIBUTE3 ATTRIBUTE3
, MMS.ATTRIBUTE4 ATTRIBUTE4
, MMS.ATTRIBUTE5 ATTRIBUTE5
, MMS.ATTRIBUTE6 ATTRIBUTE6
, MMS.ATTRIBUTE7 ATTRIBUTE7
, MMS.ATTRIBUTE8 ATTRIBUTE8
, MMS.ATTRIBUTE9 ATTRIBUTE9
, MMS.ATTRIBUTE10 ATTRIBUTE10
, MMS.ATTRIBUTE11 ATTRIBUTE11
, MMS.ATTRIBUTE12 ATTRIBUTE12
, MMS.ATTRIBUTE13 ATTRIBUTE13
, MMS.ATTRIBUTE14 ATTRIBUTE14
, MMS.ATTRIBUTE15 ATTRIBUTE15
, NULL TRANSACTION_HEADER_ID
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'