DBA Data[Home] [Help]

APPS.OZF_MULTI_CURR_MIG_PVT dependencies on QP_LIST_HEADERS_ALL

Line 100: qp_list_headers_all qpl,

96: rpad(sum(utiz.fund_request_amount),20, ' ')||
97: rpad(utiz.fund_request_currency_code ,20, ' '), utiz.plan_id
98: FROM
99: ozf_offers off,
100: qp_list_headers_all qpl,
101: ozf_funds_utilized_all_b utiz
102: WHERE
103: off.qp_list_header_id = utiz.plan_id
104: AND off.transaction_currency_code IS NULL

Line 164: FROM qp_list_headers_all

160: ,'EVEO', (SELECT currency_code_tc
161: FROM ams_event_offers_vl
162: WHERE event_offer_id = plan_id)
163: ,'PRIC',(SELECT currency_code
164: FROM qp_list_headers_all
165: WHERE list_header_id = plan_id)
166: ),
167: plan_currency_code = DECODE(plan_type,'OFFR',
168: DECODE(object_type,'ORDER', (SELECT header.transactional_curr_code