ECC Cost Management, Receiving
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: cst-phc-rcv
Query Procedure: CST_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CST_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Dataset Key: cst-phc-rcv
Query Procedure: CST_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CST_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run
ECC Cost Management, Receiving and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( SELECT * FROM (SELECT ORG_TYPE ,DATA_SOURCE, ECC_SPEC_ID, DATA_TYPE ,DATA_SOURCE_GRP, DATA_SOURCE_DESCRIPTION , ORG_TYPE_CODE ,DATA_TYPE_CODE ,DATA_SOURCE_GRP_CODE , DATA_SOURCE_DESC_CODE , TRANSACTION_ID , GROUP_ID , LAST_UPDATE_DATE ,CREATION_DATE ,TRANSACTION_TYPE_CODE, TRANSACTION_TYPE ,TRANSACTION_DATE , TXN_PROCESSING_STATUS, TXN_PROCESSING_STATUS_CODE , PROCESSING_STATUS_CODE , PROCESSING_MODE_CODE , CATEGORY_ID , QUANTITY , UNIT_OF_MEASURE , INTERFACE_SOURCE_CODE , INTERFACE_SOURCE_LINE_ID , INV_TRANSACTION_ID , ITEM_ID ,ITEM_DESCRIPTION , ITEM_NAME , PRIMARY_COST_METHOD , ORGANIZATION_CODE , ORGANIZATION_NAME , COST_ORGANIZATION , MASTER_ORGANIZATION , SOB_NAME , PERIOD_SET_NAME , PERIOD_YEAR, PERIOD_NUM, CHART_OF_ACCOUNTS_NAME , ORG_CURRENCY_CODE , OPERATING_UNIT , LEGAL_ENTITY , PERIOD_NAME , TASK_NAME , PROJECT_NAME , UOM_CODE , EMPLOYEE_ID , SHIPMENT_HEADER_ID , SHIPMENT_LINE_ID , SHIPMENT_NUMBER , PRIMARY_QUANTITY , PRIMARY_UNIT_OF_MEASURE , RECEIPT_SOURCE_CODE , VENDOR_ID , VENDOR_SITE_ID , FROM_ORGANIZATION_ID , FROM_SUBINVENTORY , TO_ORGANIZATION_ID , INTRANSIT_OWNING_ORG_ID , ROUTING_HEADER_ID , SOURCE_DOCUMENT_CODE , PARENT_TRANSACTION_ID , WIP_JOB , PO_NUMBER , PO_REVISION_NUM , PO_RELEASE_NUM , PO_RELEASE_ID , PO_LINE_LOCATION_ID , PO_UNIT_PRICE , CURRENCY_CODE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , PO_DISTRIBUTION_ID , REQUISITION_LINE_ID , DESTINATION_TYPE_CODE , DESTINATION_TYPE , SUBINVENTORY , DEPARTMENT_CODE , OPERATION_SEQ_NUM , WIP_RESOURCE_SEQ_NUM , SHIPMENT_NUM , FREIGHT_CARRIER_CODE , BILL_OF_LADING , SHIPPED_DATE , EXPECTED_RECEIPT_DATE , TRANSPORTATION_ACCOUNT_ID , WAYBILL_AIRBILL_NUM , VENDOR_ITEM_NUM , VENDOR_LOT_NUM , RMA_REFERENCE , COMMENTS , DESTINATION_CONTEXT , SOURCE_DOC_QUANTITY , SOURCE_DOC_UNIT_OF_MEASURE , ITEM_NUM , DOCUMENT_NUM , DOCUMENT_LINE_NUM , TRUCK_NUM , SHIP_TO_LOCATION_CODE, ITEM_CATEGORY , VENDOR_NAME , VENDOR_SITE_CODE , FROM_ORGANIZATION_CODE , TO_ORGANIZATION_CODE , INTRANSIT_OWNING_ORG_CODE , QUANTITY_SHIPPED , TAX_AMOUNT , REQ_NUM , REQ_LINE_NUM , RESOURCE_CODE , PARENT_SOURCE_TRANSACTION_NUM, INTERFACE_TRANSACTION_QTY , AMOUNT , UNIT_LANDED_COST , LCM_ADJUSTMENT_NUM , PERIOD_STATUS , LANGUAGE , REQUEST_ID , PROGRAM_ID , PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_NAME, PERIOD_STATUS_CODE, COSTING_PERIOD_STATUS_CODE, COSTING_CALENDAR_CODE, COSTING_PERIOD_CODE, COSTING_PERIOD_STATUS, COLUMN_NAME, ERROR_NAME, ERROR_MESSAGE, ERROR FROM CST_ECC_PHC_RCV_INT_TXNS_V where language in ('US')) PIVOT (max(PERIOD_STATUS) as PERIOD_STATUS, max(ORG_TYPE) as ORG_TYPE, max(DATA_TYPE) as DATA_TYPE, max(DATA_SOURCE_GRP) as DATA_SOURCE_GRP, max(DATA_SOURCE_DESCRIPTION) as DATA_SOURCE_DESCRIPTION, max(TRANSACTION_TYPE) as TRANSACTION_TYPE, max(TXN_PROCESSING_STATUS) as TXN_PROCESSING_STATUS, max(ITEM_DESCRIPTION) as ITEM_DESCRIPTION, max(ORGANIZATION_NAME) as ORGANIZATION_NAME, max(OPERATING_UNIT) as OPERATING_UNIT, max(DESTINATION_TYPE) as DESTINATION_TYPE, max(CONCURRENT_PROGRAM_NAME) as CONCURRENT_PROGRAM_NAME, max(COSTING_PERIOD_STATUS) as COSTING_PERIOD_STATUS for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Code |
|
LOV |