VIEW: APPS.INVBV_MOVEMENT_STATISTICS

Source

View Text - Preformatted

SELECT MMS.MOVEMENT_ID, MMS.ORGANIZATION_ID, '_LA:MMS.MOVEMENT_STATUS:FND_LOOKUPS:MVT_STATUSES:MEANING', /* Lookup */ '_LA:MMS.MOVEMENT_TYPE:FND_LOOKUPS:MVT_MOVEMENT_TYPE:MEANING', /* Lookup */ '_LA:MMS.DOCUMENT_SOURCE_TYPE:FND_LOOKUPS:MVT_SOURCE_DOCUMENT_TYPES:MEANING', /* Lookup */ MMS.ENTITY_ORG_ID, MMS.TRANSACTION_DATE, /* Bill to Customer */ MMS.BILL_TO_CUSTOMER_ID, MMS.BILL_TO_SITE_USE_ID, /* Invoice */ MMS.INVOICE_BATCH_ID, MMS.INVOICE_ID, MMS.CUSTOMER_TRX_LINE_ID, /* Organizations */ MMS.FROM_ORGANIZATION_ID, MMS.TO_ORGANIZATION_ID, /* Vendor */ MMS.VENDOR_ID, MMS.VENDOR_NAME, MMS.VENDOR_NUMBER, MMS.VENDOR_SITE_ID, MMS.VENDOR_SITE, /* Customer */ MMS.CUSTOMER_NAME, MMS.CUSTOMER_NUMBER, MMS.CUSTOMER_LOCATION, /* PO */ MMS.PO_HEADER_ID, MMS.PO_LINE_ID, MMS.PO_LINE_LOCATION_ID, /* SO */ MMS.ORDER_HEADER_ID, MMS.ORDER_LINE_ID, /* REQ */ MMS.REQUISITION_HEADER_ID, MMS.REQUISITION_LINE_ID, /* OTHERS */ MMS.PICKING_LINE_ID, MMS.PICKING_LINE_DETAIL_ID, MMS.SHIPMENT_HEADER_ID, MMS.SHIPMENT_LINE_ID, MMS.SHIP_TO_CUSTOMER_ID, MMS.SHIP_TO_SITE_USE_ID, MMS.DOCUMENT_REFERENCE, MMS.DOCUMENT_LINE_REFERENCE, MMS.SHIPMENT_REFERENCE, MMS.SHIPMENT_LINE_REFERENCE, MMS.PICK_SLIP_REFERENCE, MMS.RECEIPT_REFERENCE, MMS.TRANSACTING_FROM_ORG, MMS.TRANSACTING_TO_ORG, MMS.INVOICE_BATCH_REFERENCE, MMS.INVOICE_REFERENCE, MMS.INVOICE_LINE_REFERENCE, MMS.PARENT_MOVEMENT_ID, MMS.CURRENCY_CODE, MMS.INVENTORY_ITEM_ID, MMS.ITEM_DESCRIPTION, MMS.ITEM_COST, MMS.TRANSACTION_UOM_CODE, MMS.CATEGORY_ID, MMS.COMMODITY_CODE, MMS.COMMODITY_DESCRIPTION, MMS.TRANSACTION_QUANTITY, MMS.PRIMARY_QUANTITY,MMS.DOCUMENT_UNIT_PRICE, MMS.DOCUMENT_LINE_EXT_VALUE, '_LA:MMS.TRANSACTION_NATURE:FND_LOOKUPS:MVT_TRANSACTION_NATURE:MEANING', /* Lookup */ '_LA:MMS.DELIVERY_TERMS:FND_LOOKUPS:MVT_DELIVERY_TERMS:MEANING', /* Lookup */ '_LA:MMS.TRANSPORT_MODE:FND_LOOKUPS:MVT_TRANSPORT_MODE:MEANING', /* Lookup */ '_LA:MMS.PORT:FND_LOOKUPS:MVT_PORT:MEANING', /* Lookup */ '_LA:MMS.AREA:FND_LOOKUPS:MVT_AREA:MEANING', /* Lookup */ '_LA:MMS.STAT_TYPE:FND_LOOKUPS:MVT_STATISTICAL_TYPE:MEANING', /* Lookup */ MMS.WEIGHT_METHOD, MMS.UNIT_WEIGHT, MMS.TOTAL_WEIGHT, MMS.STAT_METHOD, MMS.STAT_ADJ_PERCENT, MMS.STAT_ADJ_AMOUNT, MMS.STAT_EXT_VALUE, MMS.COMMENTS, MMS.ALTERNATE_QUANTITY, MMS.ALTERNATE_UOM_CODE, '_LA:MMS.OUTSIDE_CODE:FND_LOOKUPS:MVT_OUTSIDE_CODE:MEANING', /* Lookup */MMS.DISPATCH_TERRITORY_CODE, MMS.DESTINATION_TERRITORY_CODE, MMS.ORIGIN_TERRITORY_CODE, MMS.OUTSIDE_UNIT_PRICE, MMS.OUTSIDE_EXT_VALUE, MMS.REPORT_REFERENCE, MMS.PERIOD_NAME, MMS.LAST_UPDATE_DATE, MMS.LAST_UPDATED_BY, MMS.CREATION_DATE, MMS.CREATED_BY FROM MTL_MOVEMENT_STATISTICS MMS WHERE '_SEC:MMS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MMS.MOVEMENT_ID
, MMS.ORGANIZATION_ID
, '_LA:MMS.MOVEMENT_STATUS:FND_LOOKUPS:MVT_STATUSES:MEANING'
, /* LOOKUP */ '_LA:MMS.MOVEMENT_TYPE:FND_LOOKUPS:MVT_MOVEMENT_TYPE:MEANING'
, /* LOOKUP */ '_LA:MMS.DOCUMENT_SOURCE_TYPE:FND_LOOKUPS:MVT_SOURCE_DOCUMENT_TYPES:MEANING'
, /* LOOKUP */ MMS.ENTITY_ORG_ID
, MMS.TRANSACTION_DATE
, /* BILL TO CUSTOMER */ MMS.BILL_TO_CUSTOMER_ID
, MMS.BILL_TO_SITE_USE_ID
, /* INVOICE */ MMS.INVOICE_BATCH_ID
, MMS.INVOICE_ID
, MMS.CUSTOMER_TRX_LINE_ID
, /* ORGANIZATIONS */ MMS.FROM_ORGANIZATION_ID
, MMS.TO_ORGANIZATION_ID
, /* VENDOR */ MMS.VENDOR_ID
, MMS.VENDOR_NAME
, MMS.VENDOR_NUMBER
, MMS.VENDOR_SITE_ID
, MMS.VENDOR_SITE
, /* CUSTOMER */ MMS.CUSTOMER_NAME
, MMS.CUSTOMER_NUMBER
, MMS.CUSTOMER_LOCATION
, /* PO */ MMS.PO_HEADER_ID
, MMS.PO_LINE_ID
, MMS.PO_LINE_LOCATION_ID
, /* SO */ MMS.ORDER_HEADER_ID
, MMS.ORDER_LINE_ID
, /* REQ */ MMS.REQUISITION_HEADER_ID
, MMS.REQUISITION_LINE_ID
, /* OTHERS */ MMS.PICKING_LINE_ID
, MMS.PICKING_LINE_DETAIL_ID
, MMS.SHIPMENT_HEADER_ID
, MMS.SHIPMENT_LINE_ID
, MMS.SHIP_TO_CUSTOMER_ID
, MMS.SHIP_TO_SITE_USE_ID
, MMS.DOCUMENT_REFERENCE
, MMS.DOCUMENT_LINE_REFERENCE
, MMS.SHIPMENT_REFERENCE
, MMS.SHIPMENT_LINE_REFERENCE
, MMS.PICK_SLIP_REFERENCE
, MMS.RECEIPT_REFERENCE
, MMS.TRANSACTING_FROM_ORG
, MMS.TRANSACTING_TO_ORG
, MMS.INVOICE_BATCH_REFERENCE
, MMS.INVOICE_REFERENCE
, MMS.INVOICE_LINE_REFERENCE
, MMS.PARENT_MOVEMENT_ID
, MMS.CURRENCY_CODE
, MMS.INVENTORY_ITEM_ID
, MMS.ITEM_DESCRIPTION
, MMS.ITEM_COST
, MMS.TRANSACTION_UOM_CODE
, MMS.CATEGORY_ID
, MMS.COMMODITY_CODE
, MMS.COMMODITY_DESCRIPTION
, MMS.TRANSACTION_QUANTITY
, MMS.PRIMARY_QUANTITY
, MMS.DOCUMENT_UNIT_PRICE
, MMS.DOCUMENT_LINE_EXT_VALUE
, '_LA:MMS.TRANSACTION_NATURE:FND_LOOKUPS:MVT_TRANSACTION_NATURE:MEANING'
, /* LOOKUP */ '_LA:MMS.DELIVERY_TERMS:FND_LOOKUPS:MVT_DELIVERY_TERMS:MEANING'
, /* LOOKUP */ '_LA:MMS.TRANSPORT_MODE:FND_LOOKUPS:MVT_TRANSPORT_MODE:MEANING'
, /* LOOKUP */ '_LA:MMS.PORT:FND_LOOKUPS:MVT_PORT:MEANING'
, /* LOOKUP */ '_LA:MMS.AREA:FND_LOOKUPS:MVT_AREA:MEANING'
, /* LOOKUP */ '_LA:MMS.STAT_TYPE:FND_LOOKUPS:MVT_STATISTICAL_TYPE:MEANING'
, /* LOOKUP */ MMS.WEIGHT_METHOD
, MMS.UNIT_WEIGHT
, MMS.TOTAL_WEIGHT
, MMS.STAT_METHOD
, MMS.STAT_ADJ_PERCENT
, MMS.STAT_ADJ_AMOUNT
, MMS.STAT_EXT_VALUE
, MMS.COMMENTS
, MMS.ALTERNATE_QUANTITY
, MMS.ALTERNATE_UOM_CODE
, '_LA:MMS.OUTSIDE_CODE:FND_LOOKUPS:MVT_OUTSIDE_CODE:MEANING'
, /* LOOKUP */MMS.DISPATCH_TERRITORY_CODE
, MMS.DESTINATION_TERRITORY_CODE
, MMS.ORIGIN_TERRITORY_CODE
, MMS.OUTSIDE_UNIT_PRICE
, MMS.OUTSIDE_EXT_VALUE
, MMS.REPORT_REFERENCE
, MMS.PERIOD_NAME
, MMS.LAST_UPDATE_DATE
, MMS.LAST_UPDATED_BY
, MMS.CREATION_DATE
, MMS.CREATED_BY
FROM MTL_MOVEMENT_STATISTICS MMS
WHERE '_SEC:MMS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY