109: and poga.enabled_flag = 'Y'
110: and ((poga.purchasing_org_id in
111: (select tfh.start_org_id
112: from mtl_procuring_txn_flow_hdrs_v tfh,
113: financials_system_params_all fsp1,
114: financials_system_params_all fsp2
115: where p_creation_date between nvl(tfh.start_date,p_creation_date)
116: and nvl(tfh.end_date,p_creation_date)
117: and fsp1.org_id = tfh.start_org_id
110: and ((poga.purchasing_org_id in
111: (select tfh.start_org_id
112: from mtl_procuring_txn_flow_hdrs_v tfh,
113: financials_system_params_all fsp1,
114: financials_system_params_all fsp2
115: where p_creation_date between nvl(tfh.start_date,p_creation_date)
116: and nvl(tfh.end_date,p_creation_date)
117: and fsp1.org_id = tfh.start_org_id
118: and fsp1.purch_encumbrance_flag = 'N'
247: and poga.enabled_flag = 'Y'
248: and ((poga.purchasing_org_id in
249: (select tfh.start_org_id
250: from mtl_procuring_txn_flow_hdrs_v tfh,
251: financials_system_params_all fsp1,
252: financials_system_params_all fsp2
253: where p_creation_date between nvl(tfh.start_date,p_creation_date)
254: and nvl(tfh.end_date,p_creation_date)
255: and fsp1.org_id = tfh.start_org_id
248: and ((poga.purchasing_org_id in
249: (select tfh.start_org_id
250: from mtl_procuring_txn_flow_hdrs_v tfh,
251: financials_system_params_all fsp1,
252: financials_system_params_all fsp2
253: where p_creation_date between nvl(tfh.start_date,p_creation_date)
254: and nvl(tfh.end_date,p_creation_date)
255: and fsp1.org_id = tfh.start_org_id
256: and fsp1.purch_encumbrance_flag = 'N'