APPS.POA_PORTAL_POPULATE_C dependencies on POA_EDW_RCV_TXNS_F

Line 140: FROM poa_edw_rcv_txns_f rcv,

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

Line 1234: FROM POA_EDW_RCV_TXNS_F Rcv,

1230: count(distinct DECODE(lookup.LUCD_Lookup_Code, 'CORRECT', rcv.receipt_num_inst, null)),
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