DBA Data[Home] [Help]

APPS.POA_PORTAL_POPULATE_C dependencies on POA_EDW_SUP_PERF_F

Line 164: FROM poa_edw_sup_perf_f sp,

160: tp.tprt_trade_partner_pk_key,
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)

Line 1212: FROM poa_edw_sup_perf_f sp,

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