eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_PORTAL_POPULATE_C dependencies on EDW_ORGANIZATION_M

Line 141: edw_organization_m org,

137: tp.tprt_name,
138: org.oper_operating_unit_pk_key,
139: org.oper_name
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

Line 165: edw_organization_m org,

161: tp.tprt_name,
162: org.oper_operating_unit_pk_key,
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

Line 410: edw_organization_m org,

406: p_quarter,
407: item.IORG_Purchaseable_Flag
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

Line 446: edw_organization_m org,

442: p_quarter,
443: item.IORG_Purchaseable_Flag
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

Line 1158: EDW_Organization_M Organization,

1154: avg(NVL(Delivery_Score, 25)),
1155: avg(NVL(Quality_Score, 25)),
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

Line 1213: edw_organization_m org,

1209: to_number(NULL),
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

Line 1235: edw_organization_m org,

1231: to_number(NULL),
1232: count(distinct DECODE(lookup.LUCD_Lookup_Code, 'RETURN TO VENDOR', rcv.receipt_num_inst, null)),
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