VIEW: APPS.ISC_EDW_ORD_RECV_PAY_CYCLE_S

Source

View Text - Preformatted

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.order_to_pay_cycle_time, ctime.cday_calendar_date - time.cday_calendar_date ORDER_TO_RECEIVE_CYCLE_TIME, 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_TIME_M ctime, 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.po_app_date_fk_key = time.cday_cal_day_pk_key AND po.goods_received_date_fk_key = ctime.cday_cal_day_pk_key

View Text - HTML Formatted

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.ORDER_TO_PAY_CYCLE_TIME
, CTIME.CDAY_CALENDAR_DATE - TIME.CDAY_CALENDAR_DATE ORDER_TO_RECEIVE_CYCLE_TIME
, 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_TIME_M CTIME
, 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.PO_APP_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY
AND PO.GOODS_RECEIVED_DATE_FK_KEY = CTIME.CDAY_CAL_DAY_PK_KEY