[Home] [Help]
View: ISC_EDW_RECEIVE_PAY_CYCLE_S
| Product: | ISC - Supply Chain Intelligence (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT GEO.ARE1_AREA1_PK_KEY AREA_FK
, ORG.BGRP_BUSINESS_GROUP_PK_KEY BUS_GRP_FK
, ITEM.CO11_CATEGORY_PK_KEY CATG_FK
, GEO.COUN_COUNTRY_PK_KEY COUNTRY_FK
, ORG.ORGA_ORGANIZATION_PK_KEY INT_ORGA_FK
, ORG.LGET_LEGAL_ENTITY_PK_KEY LEGAL_ENT_FK
, ORG.OPER_OPERATING_UNIT_PK_KEY OPER_UNIT_FK
, TIME.ECPR_CAL_PERIOD_PK_KEY PERIOD_FK
, TIME.ECQR_CAL_QTR_PK_KEY QTR_FK
, GEO.REGN_REGION_PK_KEY REGION_FK
, TRD.TPRT_TRADE_PARTNER_PK_KEY TRD_PARTNER_FK
, TIME.ECYR_CAL_YEAR_PK_KEY YEAR_FK
, PO.RECEIVE_TO_PAY_CYCL_TIME RECEIVE_TO_PAY_CYCLE_TIME
FROM POA_EDW_PO_DIST_F PO
, EDW_GEOGRAPHY_M GEO
, EDW_ORGANIZATION_M ORG
, EDW_ITEMS_M ITEM
, EDW_TIME_M TIME
, EDW_TRD_PARTNER_M TRD
WHERE PO.ITEM_FK_KEY = ITEM.IREV_ITEM_REVISION_PK_KEY
AND PO.SHIP_TO_ORG_FK_KEY = ORG.ORGA_ORGANIZATION_PK_KEY
AND PO.SHIP_LOCATION_FK_KEY = GEO.GLOC_LOCATION_PK_KEY
AND PO.SUPPLIER_SITE_FK_KEY = TRD.TPLO_TPARTNER_LOC_PK_KEY
AND PO.GOODS_RECEIVED_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY
Columns
| Name |
| AREA_FK |
| BUS_GRP_FK |
| CATG_FK |
| COUNTRY_FK |
| INT_ORGA_FK |
| LEGAL_ENT_FK |
| OPER_UNIT_FK |
| PERIOD_FK |
| QTR_FK |
| REGION_FK |
| TRD_PARTNER_FK |
| YEAR_FK |
| RECEIVE_TO_PAY_CYCLE_TIME |