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
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    ,TRANSACTION_MONTH    ,
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
x.organization_code=:organization_code
LOV
Blitz Report™