APPS.POA_PORTAL_POPULATE_C dependencies on EDW_TIME_M

Line 144: edw_time_m time

140: FROM poa_edw_rcv_txns_f rcv,
141: edw_organization_m org,
142: edw_trd_partner_m tp,
143: edw_lookup_m lku,
144: edw_time_m time
145: WHERE rcv.RCV_DEL_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
146: and rcv.Supplier_Site_FK_Key = tp.TPLO_TPARTNER_LOC_PK_KEY
147: and rcv.TXN_CREAT_FK_KEY = time.CDAY_CAL_DAY_PK_KEY
148: and rcv.txn_type_fk_key = lku.lucd_lookup_code_pk_key

Line 167: edw_time_m time

163: org.oper_name
164: FROM poa_edw_sup_perf_f sp,
165: edw_organization_m org,
166: edw_trd_partner_m tp,
167: edw_time_m time
168: WHERE ((sp.Qty_Ordered_B-sp.Qty_Received_B) > 0)
169: and sp.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
170: and sp.Supplier_Site_FK_Key = tp.TPLO_TPARTNER_LOC_PK_KEY
171: and sp.Promised_Date_FK_Key = time.CDAY_CAL_DAY_PK_KEY

Line 412: edw_time_m time1,

408: from poa_edw_po_dist_f pod,
409: edw_items_m item,
410: edw_organization_m org,
411: edw_trd_partner_m tp,
412: edw_time_m time1,
413: edw_time_m time2,
414: edw_time_m time3
415: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
416: and pod.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY

Line 413: edw_time_m time2,

409: edw_items_m item,
410: edw_organization_m org,
411: edw_trd_partner_m tp,
412: edw_time_m time1,
413: edw_time_m time2,
414: edw_time_m time3
415: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
416: and pod.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
417: and pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY

Line 414: edw_time_m time3

410: edw_organization_m org,
411: edw_trd_partner_m tp,
412: edw_time_m time1,
413: edw_time_m time2,
414: edw_time_m time3
415: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
416: and pod.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
417: and pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY
418: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY

Line 448: edw_time_m time1,

444: from poa_edw_po_dist_f pod,
445: edw_items_m item,
446: edw_organization_m org,
447: edw_trd_partner_m tp,
448: edw_time_m time1,
449: edw_time_m time2
450: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
451: and pod.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
452: and pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY

Line 449: edw_time_m time2

445: edw_items_m item,
446: edw_organization_m org,
447: edw_trd_partner_m tp,
448: edw_time_m time1,
449: edw_time_m time2
450: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
451: and pod.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
452: and pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY
453: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY

Line 513: edw_time_m time1,

509: p_quarter,
510: item.IORG_Purchaseable_Flag
511: from poa_edw_po_dist_f pod,
512: edw_items_m item,
513: edw_time_m time1,
514: edw_time_m time2,
515: edw_time_m time3
516: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
517: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY

Line 514: edw_time_m time2,

510: item.IORG_Purchaseable_Flag
511: from poa_edw_po_dist_f pod,
512: edw_items_m item,
513: edw_time_m time1,
514: edw_time_m time2,
515: edw_time_m time3
516: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
517: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY
518: and time1.CDAY_CALENDAR_DATE between p_start and p_end

Line 515: edw_time_m time3

511: from poa_edw_po_dist_f pod,
512: edw_items_m item,
513: edw_time_m time1,
514: edw_time_m time2,
515: edw_time_m time3
516: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
517: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY
518: and time1.CDAY_CALENDAR_DATE between p_start and p_end
519: and pod.PO_ACCEPT_DATE_FK_KEY = time2.CDAY_CAL_DAY_PK_KEY

Line 571: edw_time_m time1,

567: p_quarter,
568: item.IORG_Purchaseable_Flag
569: from poa_edw_po_dist_f pod,
570: edw_trd_partner_m tp,
571: edw_time_m time1,
572: edw_time_m time2,
573: edw_time_m time3,
574: edw_items_m item
575: where pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY

Line 572: edw_time_m time2,

568: item.IORG_Purchaseable_Flag
569: from poa_edw_po_dist_f pod,
570: edw_trd_partner_m tp,
571: edw_time_m time1,
572: edw_time_m time2,
573: edw_time_m time3,
574: edw_items_m item
575: where pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY
576: and pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY

Line 573: edw_time_m time3,

569: from poa_edw_po_dist_f pod,
570: edw_trd_partner_m tp,
571: edw_time_m time1,
572: edw_time_m time2,
573: edw_time_m time3,
574: edw_items_m item
575: where pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY
576: and pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
577: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY

Line 1160: EDW_Time_M Time

1156: avg(NVL(Survey_Score, 25))
1157: from POA_REP_CSTM_MSR_V Cstm_Msr,
1158: EDW_Organization_M Organization,
1159: EDW_TRD_Partner_M Supplier,
1160: EDW_Time_M Time
1161: where
1162: Cstm_Msr.Ship_To_Org_FK_Key = Organization.Orga_Organization_PK_Key and
1163: Cstm_Msr.Supplier_Site_FK_Key = Supplier.TPLO_TPartner_Loc_PK_Key and
1164: Cstm_Msr.Eval_Date_FK_Key = Time.CDay_Cal_Day_PK_Key and

Line 1214: edw_time_m time

1210: to_number(NULL),
1211: to_number(NULL)
1212: FROM poa_edw_sup_perf_f sp,
1213: edw_organization_m org,
1214: edw_time_m time
1215: WHERE sp.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
1216: and sp.DATE_DIM_FK_KEY = time.CDAY_CAL_DAY_PK_KEY
1217: and sp.NUM_RECEIPT_LINES <> 0
1218: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start

Line 1237: edw_time_m time

1233: to_number(NULL)
1234: FROM POA_EDW_RCV_TXNS_F Rcv,
1235: edw_organization_m org,
1236: EDW_Lookup_M lookup,
1237: edw_time_m time
1238: WHERE rcv.RCV_Del_To_Org_FK_Key = org.ORGA_ORGANIZATION_PK_KEY
1239: and rcv.TXn_Type_FK_Key = lookup.lucd_lookup_Code_PK_Key
1240: and rcv.TXN_Creat_FK_Key = time.CDAY_CAL_DAY_PK_KEY
1241: and time.CDAY_CALENDAR_DATE between FII_TIME_WH_API.ent_cycq_start