ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C033C2D455F00791E0530100007FC526Y with req as ( select /*+ push_pred(x) */ haouv.name operating_unit, xxen_util.meaning(prha.type_lookup_code,'REQUISITION TYPE',201) requisition_type, prha.segment1 requisition_number, trunc(prha.creation_date) creation_date, xxen_util.user_name(prha.created_by) created_by_user, ppx.full_name preparer_name, prha.description description, nvl(xxen_util.meaning(prha.authorization_status,'AUTHORIZATION STATUS',201) ,prha.authorization_status) req_auth_status, trunc(prha.approved_date) req_approved_date, prha.note_to_authorizer, prha.agent_return_flag agent_return_flag, xxen_util.meaning(prha.closed_code,'DOCUMENT STATE',201) req_closure_status, prla.line_num line_number, trunc(prla.creation_date) line_creation_date, xxen_util.meaning(prla.source_type_code,'REQUISITION SOURCE TYPE',201) line_source_type, xxen_util.meaning(prla.purchase_basis,'PURCHASE BASIS',201) line_type, xxen_util.meaning(prla.order_type_lookup_code,'ORDER TYPE',201) line_order_type, msiv.concatenated_segments item, prla.item_revision item_revision, (select mck.concatenated_segments from mtl_categories_kfv mck where prla.category_id=mck.category_id) category, nvl(prla.item_description ,msiv.description) line_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, (select misv.inventory_item_status_code_tl from mtl_item_status_vl misv where msiv.inventory_item_status_code=misv.inventory_item_status_code) item_status, xxen_util.meaning(msiv.inventory_item_flag,'YES_NO',0) inventory_item_flag, xxen_util.meaning(msiv.stock_enabled_flag,'YES_NO',0) stock_enabled_flag, xxen_util.meaning(msiv.inventory_asset_flag,'YES_NO',0) inventory_asset_flag, xxen_util.concatenated_segments(msiv.expense_account) item_expense_account, prla.unit_meas_lookup_code uom, prla.quantity, prla.quantity_cancelled, prla.quantity_received, prla.quantity_delivered, prla.unit_price unit_price, nvl(decode(prla.order_type_lookup_code,'RATE', prla.amount,'FIXED PRICE', prla.amount, prla.quantity * prla.unit_price),0) amount, prla.need_by_date need_by_date, ppx2.full_name requestor_name, (select mp.organization_code from mtl_parameters mp where prla.destination_organization_id=mp.organization_id) destination_organization, nvl(hrl.location_code,(substrb(rtrim(hzl.address1)||'-'||rtrim(hzl.city),1,60))) deliver_to_location, (select mp.organization_code from mtl_parameters mp where prla.source_organization_id=mp.organization_id) source_organization, prla.source_subinventory, prla.suggested_vendor_name suggested_supplier, prla.suggested_vendor_location suggested_supplier_site, prla.suggested_vendor_contact suggested_supplier_contact, prla.suggested_vendor_product_code supplier_item, prla.note_to_agent note_to_agent, xxen_util.meaning(nvl(prla.on_rfq_flag,'N'),'YES/NO',201) on_rfq, prla2.line_num parent_req_line_number, xxen_util.yes(prla.cancel_flag) cancelled_flag, trunc(nvl(prla.cancel_date ,pah.cancelled_date)) cancelled_date, nvl(prla.cancel_reason,pah.cancelled_note) cancelled_reason, pah.cancelled_by, &req_dist_columns &req_dff_cols &item_dff_cols prla.requisition_header_id, prla.requisition_line_id, prla.line_location_id, prha.attribute_category req_hdr_dff_cat, prha.rowid req_hdr_rowid, prla.attribute_category req_line_dff_cat, prla.rowid req_line_rowid, msiv.attribute_category item_dff_category, msiv.inventory_item_id, nvl(prla.destination_organization_id,msiv.organization_id) organization_id, msiv.rowid item_rowid from po_requisition_headers_all prha, po_requisition_lines_all prla, po_requisition_lines_all prla2, &req_dist_tables financials_system_params_all fspa, gl_ledgers gl, hr_all_organization_units_vl haouv, per_people_x ppx, per_people_x ppx2, hr_locations hrl, hz_locations hzl, mtl_system_items_vl msiv, ( select ppx.full_name cancelled_by, pah.action_date cancelled_date, pah.note cancelled_note, pah.object_id requisition_header_id from po_action_history pah, per_people_x ppx where pah.employee_ID=ppx.person_id(+) and pah.object_type_code='REQUISITION' and pah.action_code='CANCEL' ) pah where 1=1 and prha.type_lookup_code='PURCHASE' and nvl(prha.contractor_requisition_flag,'N')<>'Y' and prha.authorization_status<>'INCOMPLETE' and prha.requisition_header_id=prla.requisition_header_id and &req_dist_joins fspa.org_id=prha.org_id and gl.ledger_id=fspa.set_of_books_id and prha.org_id=haouv.organization_id and prha.preparer_id=ppx.person_id and prla.to_person_id=ppx2.person_id and prla.deliver_to_location_id=hrl.location_id(+) and prla.deliver_to_location_id=hzl.location_id(+) and prla.parent_req_line_id=prla2.requisition_line_id(+) and prla.item_id=msiv.inventory_item_id(+) and nvl(prla.destination_organization_id,fspa.inventory_organization_id)=nvl(msiv.organization_id,fspa.inventory_organization_id) and prha.requisition_header_id=pah.requisition_header_id(+) ), po as ( select /*+ push_pred(x) */ haouv.name po_operating_unit, asu.vendor_name po_vendor_name, asu.segment1 po_vendor_number, assa.vendor_site_code po_vendor_site, (select ftv.territory_short_name from fnd_territories_vl ftv where ftv.territory_code=assa.country) po_vendor_country, pha.segment1 po_number, pra.release_num po_release_num, xxen_util.meaning(pha.authorization_status , 'DOCUMENT STATE', 201) po_auth_status, xxen_util.meaning(pra.authorization_status , 'DOCUMENT STATE', 201) po_release_auth_status, xxen_util.meaning(pha.closed_code,'DOCUMENT STATE',201) po_header_closure_status, xxen_util.meaning(pla.closed_code,'DOCUMENT STATE',201) po_line_closure_status, xxen_util.meaning(plla.closed_code,'DOCUMENT STATE',201) po_shipment_closure_status, trunc(pha.creation_date) po_creation_date, trunc(pha.approved_date) po_approved_date, trunc(pra.release_date) po_release_date, pha.currency_code po_currency, ( select sum(decode(plla2.quantity,null,plla2.amount-nvl(plla2.amount_cancelled,0),(plla2.quantity-nvl(plla2.quantity_cancelled,0))*nvl2(plla2.price_override,plla2.price_override,nvl(pla2.unit_price,0)))) from po_line_locations_all plla2, po_lines_all pla2 where pha.po_header_id=plla2.po_header_id and plla2.po_line_id=pla2.po_line_id ) po_total_amount, pla.line_num po_line_number, pltv.line_type po_line_type, (select mck.concatenated_segments from mtl_categories_kfv mck where pla.category_id=mck.category_id) po_line_category, msiv.item po_line_item, nvl(pla.item_description,msiv.description) po_line_description, plla.shipment_num po_shipment_number, plla.need_by_date po_shipment_need_by_date, plla.promised_date po_shipment_promised_date, plla.firm_date po_shipment_firm_date, plla.unit_meas_lookup_code po_uom, plla.quantity - nvl(plla.quantity_cancelled,0) po_quantity_ordered, plla.quantity_accepted po_quantity_accepted, plla.quantity_rejected po_quantity_rejected, plla.quantity_received po_quantity_received, plla.quantity_billed po_quantity_billed, nvl(plla.price_override,pla.unit_price) po_unit_price, decode(plla.quantity, null, (plla.amount - nvl(plla.amount_cancelled,0)),(plla.quantity - nvl(plla.quantity_cancelled,0))*nvl2(plla.price_override,plla.price_override,nvl(pla.unit_price,0)))po_amount_ordered, decode(plla.quantity_accepted,null,plla.amount_accepted,plla.quantity_accepted*nvl(plla.price_override,pla.unit_price))po_amount_accepted, decode(plla.quantity_rejected,null,plla.amount_rejected,plla.quantity_rejected*nvl(plla.price_override,pla.unit_price))po_amount_rejected, decode(plla.quantity_received,null,plla.amount_received,plla.quantity_received*nvl(plla.price_override,pla.unit_price))po_amount_received, plla.amount_billed po_amount_billed, trunc(plla.creation_date) po_shipment_creation_date, decode(plla.cancel_flag,'Y','Y',null) po_shipment_cancelled_flag, trunc(plla.cancel_date) po_shipment_cancelled_date, plla.cancel_reason po_shipment_cancelled_reason, xxen_util.user_name(plla.cancelled_by) po_shipment_cancelled_by, mp1.organization_code po_ship_to_organization, hl1.location_code po_ship_to_location, ( select rtrim(xmlagg(xmlelement(e,x.receipt_num||', ') order by x.receipt_num).extract('//text()').getclobval(),', ') from (select distinct rt.po_line_location_id, rsh.receipt_num from rcv_transactions rt, rcv_shipment_headers rsh where rt.shipment_header_id=rsh.shipment_header_id and rt.transaction_type in ('RECEIVE','DELIVER')) x where x.po_line_location_id=plla.line_location_id ) receipt_number, &ap_cte_columns &po_dist_columns &po_dff_cols plla.po_header_id, plla.po_line_id, plla.line_location_id, pha.attribute_category po_hdr_dff_cat, pha.rowid po_hdr_rowid, pla.attribute_category po_line_dff_cat, pla.rowid po_line_rowid from po_headers_all pha, po_lines_all pla, po_line_locations_all plla, &po_dist_tables po_releases_all pra, po_line_types_v pltv, ap_suppliers asu, ap_supplier_sites_all assa, financials_system_params_all fspa, gl_ledgers gl, hr_all_organization_units_vl haouv, hr_locations hl1, mtl_parameters mp1, ( select fspa.org_id, msiv.inventory_item_id, msiv.concatenated_segments item, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, msiv.description from financials_system_params_all fspa, mtl_system_items_vl msiv where msiv.organization_id=fspa.inventory_organization_id ) msiv where 2=2 and pha.po_header_id=pla.po_header_id and pla.po_header_id=plla.po_header_id and pla.po_line_id=plla.po_line_id and &po_dist_joins plla.po_release_id=pra.po_release_id(+) and pha.vendor_id=asu.vendor_id and pha.vendor_site_id=assa.vendor_site_id and pha.org_id=fspa.org_id and gl.ledger_id=fspa.set_of_books_id and haouv.organization_id=pha.org_id and pla.line_type_id=pltv.line_type_id and pla.item_id=msiv.inventory_item_id(+) and pla.org_id=msiv.org_id(+) and plla.ship_to_organization_id=mp1.organization_id(+) and plla.ship_to_location_id=hl1.location_id(+) ) select req.operating_unit, req.requisition_type, req.requisition_number, req.creation_date, req.created_by_user, req.preparer_name, req.description, req.req_auth_status, req.req_approved_date, req.req_closure_status, req.cancelled_flag, req.cancelled_date, req.cancelled_reason, req.cancelled_by, req.note_to_authorizer, req.agent_return_flag, req.line_number, req.line_source_type, req.line_type, req.line_order_type, req.line_creation_date, req.item, req.item_revision, req.user_item_type, req.item_status, req.inventory_item_flag, req.stock_enabled_flag, req.inventory_asset_flag, req.item_expense_account, &category_columns req.category, req.line_description, req.need_by_date, req.unit_price, req.requestor_name, req.destination_organization, req.deliver_to_location, req.source_organization, req.source_subinventory, req.suggested_supplier, req.suggested_supplier_site, req.suggested_supplier_contact, req.supplier_item, &req_line_columns_disp &req_dist_columns_disp req.note_to_agent, req.on_rfq, req.parent_req_line_number, &req_dff_cols_disp &item_dff_cols_disp xxen_util.yes(nvl2(req.line_location_id,'Y',null)) converted_to_po, po.po_vendor_name, po.po_vendor_number, po.po_vendor_site, po.po_vendor_country, po.po_number, po.po_release_num, po.po_auth_status, po.po_release_auth_status, po.po_header_closure_status, po.po_line_closure_status, po.po_shipment_closure_status, po.po_creation_date, po.po_approved_date, po.po_release_date, po.po_currency, po.po_total_amount, po.po_line_number, po.po_line_type, po.po_line_category, po.po_line_item, po.po_line_description, po.po_shipment_number, po.po_shipment_need_by_date, po.po_shipment_promised_date, po.po_shipment_firm_date, po.receipt_number, po.po_ship_to_organization, po.po_ship_to_location, po.po_unit_price, po.po_uom, &po_line_columns_disp &po_dist_columns_disp &ap_columns &po_dff_cols_disp po.po_shipment_creation_date, po.po_shipment_cancelled_flag, po.po_shipment_cancelled_date, po.po_shipment_cancelled_reason, po.po_shipment_cancelled_by from req, po where 3=3 and &req_to_po_dist_joins req.line_location_id=po.line_location_id(+) order by req.operating_unit, req.creation_date, req.requisition_number, req.line_number Added PO Vendor Country column (supplier site country) JL (:Ledger is not null or :Operating_Unit is not null) and ( (:Creation_Date_From is null and :Creation_Date_To is null) or (:Creation_Date_From is not null and :Creation_Date_To is not null) ) and ( (:Converted_To_PO_Date_From is null and :Converted_To_PO_Date_To is null) or (:Converted_To_PO_Date_From is not null and :Converted_To_PO_Date_To is not null) ) US PO Purchase Requisitions with PO Details Purchase Requisitions Status with PO Details Report. Lists purchase requisition headers, lines and distributions together with the purchase order they were converted into, including requisition and PO approval dates, the Converted To PO indicator and the PO total amount. Set the Show Invoice and Payment Details parameter to Yes to additionally return the supplier invoices and payments matched to each purchase order shipment: invoice numbers, invoice date, invoiced amount, invoice amount paid, payment status, payment numbers, payment date and payment method. These columns are omitted by default because they add an Accounts Payable lookup to every row. Please enter a Ledger or Operating Unit, and if entering a date range, enter both the From and To Date Range Parameters Enginatics &ap_columns &ap_cte_columns &category_columns &item_dff_cols &item_dff_cols_disp &po_dff_cols &po_dff_cols_disp &po_dist_columns &po_dist_columns_disp &po_dist_joins &po_dist_tables &po_line_columns_disp &req_dff_cols &req_dff_cols_disp &req_dist_columns &req_dist_columns_disp &req_dist_joins &req_dist_tables &req_line_columns_disp &req_to_po_dist_joins 1=1 2=2 3=3 1 10 &req_dist_columns prda.distribution_num distribution_number, prda.req_line_quantity distribution_quantity, nvl(decode(prla.order_type_lookup_code,'RATE', prda.req_line_amount ,'FIXED PRICE', prda.req_line_amount,prda.req_line_quantity * prla.unit_price),0)distribution_amount, gcck.concatenated_segments distribution_account, prda.allocation_type, prda.allocation_value, prda.distribution_id, LOV custom Y select 'Line' value, 'Requisition Line Level' description from dual union all select 'Distribution', 'Requisition Distribution Level' from dual union all select 'Distribution with SLA', 'Requisition Distribution Level with Subledger Accounting' from dual Distribution Line F Niveau du rapport US Report Level 2 &req_dist_columns prda.distribution_num distribution_number, prda.req_line_quantity distribution_quantity, nvl(decode(prla.order_type_lookup_code,'RATE', prda.req_line_amount ,'FIXED PRICE', prda.req_line_amount,prda.req_line_quantity * prla.unit_price),0)distribution_amount, xxen_util.meaning(x.gl_transfer_status_code,'XLA_ACCT_TRANSFER',602) sla_gl_tfr_status, x.accounting_line_code, nvl2(x.gl_transfer_status_code,x.entered_amount,null) sla_entered_amount, nvl2(x.gl_transfer_status_code,x.accounted_amount,null) sla_accounted_amount, gcck.concatenated_segments distribution_account, prda.allocation_type, prda.allocation_value, prda.distribution_id, Distribution with SLA US Report Level 3 &po_dist_columns pda.distribution_num po_dist_number, pda.quantity_ordered-nvl(pda.quantity_cancelled,0) po_dist_quantity_ordered, pda.quantity_delivered po_dist_quantity_delivered, pda.quantity_billed po_dist_quantity_billed, decode(pda.quantity_ordered,null,pda.amount_ordered-nvl(pda.amount_cancelled,0),(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))*nvl(plla.price_override,pla.unit_price)) po_dist_amount_ordered, decode(pda.quantity_delivered,null,pda.amount_delivered,pda.quantity_delivered*nvl(plla.price_override,pla.unit_price)) po_dist_amount_delivered, decode(pda.quantity_billed,null,pda.amount_billed,pda.quantity_billed*nvl(plla.price_override,pla.unit_price)) po_dist_amount_billed, gcck.concatenated_segments po_dist_account, mp2.organization_code po_deliver_to_organization, hl2.location_code po_deliver_to_location, ppx.full_name po_deliver_to_person, pda.po_distribution_id, nvl(pda.req_distribution_id,-1) req_distribution_id, Distribution F Niveau du rapport US Report Level 4 &po_dist_columns pda.distribution_num po_dist_number, pda.quantity_ordered-nvl(pda.quantity_cancelled,0) po_dist_quantity_ordered, pda.quantity_delivered po_dist_quantity_delivered, pda.quantity_billed po_dist_quantity_billed, decode(pda.quantity_ordered,null,pda.amount_ordered-nvl(pda.amount_cancelled,0),(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))*nvl(plla.price_override,pla.unit_price)) po_dist_amount_ordered, decode(pda.quantity_delivered,null,pda.amount_delivered,pda.quantity_delivered*nvl(plla.price_override,pla.unit_price)) po_dist_amount_delivered, decode(pda.quantity_billed,null,pda.amount_billed,pda.quantity_billed*nvl(plla.price_override,pla.unit_price)) po_dist_amount_billed, xxen_util.meaning(x.gl_transfer_status_code,'XLA_ACCT_TRANSFER',602) po_sla_gl_tfr_status, x.accounting_line_code po_accounting_line_code, nvl2(x.gl_transfer_status_code,x.entered_amount,null) po_sla_entered_amount, nvl2(x.gl_transfer_status_code,x.accounted_amount,null) po_sla_accounted_amount, gcck.concatenated_segments po_dist_account, mp2.organization_code po_deliver_to_organization, hl2.location_code po_deliver_to_location, ppx.full_name po_deliver_to_person, pda.po_distribution_id, nvl(pda.req_distribution_id,-1) req_distribution_id, Distribution with SLA US Report Level 5 &po_dist_columns_disp po.po_dist_number, po.po_dist_quantity_ordered, po.po_dist_quantity_delivered, po.po_dist_quantity_billed, po.po_dist_amount_ordered, po.po_dist_amount_delivered, po.po_dist_amount_billed, po.po_dist_account, po.po_deliver_to_organization, po.po_deliver_to_location, po.po_deliver_to_person, Distribution F Niveau du rapport US Report Level 6 &po_dist_columns_disp po.po_dist_number, po.po_dist_quantity_ordered, po.po_dist_quantity_delivered, po.po_dist_quantity_billed, po.po_dist_amount_ordered, po.po_dist_amount_delivered, po.po_dist_amount_billed, po.po_sla_gl_tfr_status, po.po_accounting_line_code, po.po_sla_entered_amount, po.po_sla_accounted_amount, po.po_dist_account, po.po_deliver_to_organization, po.po_deliver_to_location, po.po_deliver_to_person, Distribution with SLA US Report Level 7 &po_dist_joins plla.line_location_id=pda.line_location_id and pda.destination_organization_id=mp2.organization_id(+) and pda.deliver_to_location_id=hl2.location_id(+) and pda.deliver_to_person_id=ppx.person_id(+) and pda.code_combination_id=gcck.code_combination_id(+) and Distribution F Niveau du rapport US Report Level 8 &po_dist_joins plla.line_location_id=pda.line_location_id and fspa.set_of_books_id=x.ledger_id(+) and pda.po_distribution_id=x.source_distribution_id_num_1(+) and pda.destination_organization_id=mp2.organization_id(+) and pda.deliver_to_location_id=hl2.location_id(+) and pda.deliver_to_person_id=ppx.person_id(+) and nvl(x.code_combination_id,pda.code_combination_id)=gcck.code_combination_id(+) and Distribution with SLA US Report Level 9 &po_dist_tables po_distributions_all pda, mtl_parameters mp2, hr_locations hl2, per_people_x ppx, gl_code_combinations_kfv gcck, Distribution F Niveau du rapport US Report Level 10 &po_dist_tables po_distributions_all pda, ( select distinct xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id, sum(nvl(xal.entered_dr,0)-nvl(xal.entered_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) entered_amount, sum(nvl(xal.accounted_dr,0)-nvl(xal.accounted_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) accounted_amount from xla_distribution_links xdl, xla_ae_headers xah, xla_ae_lines xal where xdl.application_id=201 and xdl.source_distribution_type='PO_DISTRIBUTIONS_ALL' and xdl.application_id=xah.application_id(+) and xdl.ae_header_id=xah.ae_header_id(+) and xdl.application_id=xal.application_id(+) and xdl.ae_header_id=xal.ae_header_id(+) and xdl.ae_line_num=xal.ae_line_num(+) ) x, mtl_parameters mp2, hr_locations hl2, per_people_x ppx, gl_code_combinations_kfv gcck, Distribution with SLA US Report Level 11 &po_line_columns_disp po.po_quantity_ordered, po.po_quantity_accepted, po.po_quantity_rejected, po.po_quantity_received, po.po_quantity_billed, po.po_amount_ordered, po.po_amount_accepted, po.po_amount_rejected, po.po_amount_received, po.po_amount_billed, Line F Niveau du rapport US Report Level 12 &req_dist_columns_disp req.distribution_number, req.distribution_quantity, req.distribution_amount, req.distribution_account, Distribution F Niveau du rapport US Report Level 13 &req_dist_columns_disp req.distribution_number, req.distribution_quantity, req.distribution_amount, req.sla_gl_tfr_status, req.accounting_line_code, req.sla_entered_amount, req.sla_accounted_amount, req.distribution_account, Distribution with SLA US Report Level 14 &req_dist_joins prla.requisition_line_id=prda.requisition_line_id and prda.code_combination_id=gcck.code_combination_id and Distribution F Niveau du rapport US Report Level 15 &req_dist_joins prla.requisition_line_id=prda.requisition_line_id and fspa.set_of_books_id=x.ledger_id(+) and prda.distribution_id=x.source_distribution_id_num_1(+) and nvl(x.code_combination_id,prda.code_combination_id)=gcck.code_combination_id and Distribution with SLA US Report Level 16 &req_dist_tables po_req_distributions_all prda, gl_code_combinations_kfv gcck, Distribution F Niveau du rapport US Report Level 17 &req_dist_tables po_req_distributions_all prda, ( select distinct xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id, sum(nvl(xal.entered_dr,0)-nvl(xal.entered_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) entered_amount, sum(nvl(xal.accounted_dr,0)-nvl(xal.accounted_cr,0)) over (partition by xah.ledger_id, xah.gl_transfer_status_code, xdl.source_distribution_id_num_1, xdl.accounting_line_code, xal.code_combination_id) accounted_amount from xla_distribution_links xdl, xla_ae_headers xah, xla_ae_lines xal where xdl.application_id=201 and xdl.source_distribution_type='PO_REQ_DISTRIBUTIONS_ALL' and xdl.application_id=xah.application_id(+) and xdl.ae_header_id=xah.ae_header_id(+) and xdl.application_id=xal.application_id(+) and xdl.ae_header_id=xal.ae_header_id(+) and xdl.ae_line_num=xal.ae_line_num(+) ) x, gl_code_combinations_kfv gcck, Distribution with SLA US Report Level 18 &req_line_columns_disp req.quantity, req.quantity_cancelled, req.quantity_received, req.quantity_delivered, req.amount, Line F Niveau du rapport US Report Level 19 &req_to_po_dist_joins req.distribution_id=po.req_distribution_id(+) and Distribution F Niveau du rapport US Report Level 20 20 1=1 gl.name=:ledger and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) F Grand livre US Ledger 21 2=2 gl.name=:ledger and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) US Ledger 22 30 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) F Unité d'exploitation US Operating Unit 23 2=2 haouv.name=:operating_unit US Operating Unit 24 40 1=1 prha.segment1=:req_number LOV PO Requisition Number 0087D0A1D043F831E0630100007F0109 Y Y select prha.segment1 value, prha.description from hr_all_organization_units_vl haouv, po_requisition_headers_all prha, po_system_parameters_all pspa where prha.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=prha.org_id and prha.org_id=pspa.org_id and nvl(prha.authorization_status,'INCOMPLETE')<>'SYSTEM_SAVED' order by haouv.name, decode(pspa.manual_req_num_type,'NUMERIC',to_number(prha.segment1)), prha.segment1 F Numéro de demande d'emploi De US Requisition Number 25 45 3=3 po.po_number=:purchase_order LOV PO Number 8E2FF36EDEED79D2E0530100007F1FF2 Y Y select pha.segment1 value, xxen_util.meaning(pha.type_lookup_code,'PO TYPE',201)||nvl2(aps.vendor_name,': '||aps.vendor_name,null) description from po_headers_all pha, ap_suppliers aps where (:$flex$.operating_unit is null or pha.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') ) and pha.vendor_id=aps.vendor_id(+) order by pha.creation_date desc US Purchase Order 26 50 1=1 prha.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 27 60 1=1 prha.creation_date < :creation_date_to + 1 Date last_day(:$flex$.creation_date_from) F Date de création au US Creation Date To 28 70 1=1 prla.need_by_date >= :p_need_by_date_from Date F Besoin par Date du US Need By Date From 29 80 1=1 prla.need_by_date < :p_need_by_date_to+1 Date last_day(:$flex$.need_by_date_from) F Besoin par Date à US Need By Date To 30 90 :plla_creation_date_from Date F Converti en PO Date du US Converted To PO Date From 31 100 :plla_creation_date_to Date last_day(:$flex$.converted_to_po_date_from) F Converti en Date de la commande en US Converted To PO Date To 32 1=1 prla.line_location_id in (select plla.line_location_id from po_line_locations_all plla where plla.creation_date>=:plla_creation_date_from and plla.creation_date<:plla_creation_date_to+1) F Converti en Date de la commande en US Converted To PO Date To 33 110 1=1 prla.destination_organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:ship_from_warehouse) LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US Destination Organization 34 120 1=1 hrl.location_code=:location_code LOV HR Location 0087D0A1D042F831E0630100007F0109 Y select hl.location_code value, hl.description||' ('||hl.address_line_1||', '||hl.town_or_city||', '||ftv.territory_short_name||')' description from hr_locations hl, fnd_territories_vl ftv where hl.country=ftv.territory_code(+) order by hl.location_code F Livraison sur site US Deliver To Location 35 130 1=1 ppx2.full_name=:requestor_name LOV HR Employee 0092EAD2F4F36C61E0630100007FAB89 Y Y select he.full_name value, he.employee_num description from hr_employees he order by he.full_name F Nom du demandeur US Requestor Name 36 140 1=1 ppx.full_name=:preparer_name Char F Nom du préparateur US Preparer Name 37 150 1=1 prha.created_by in (select fu.user_id from fnd_user fu where fu.user_name=:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Créé par US Created By 38 160 1=1 nvl(prla.quantity_delivered,0) < nvl(prla.quantity,0) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y F Exclure les produits entièrement livrés US Exclude Fully Delivered 39 170 1=1 1=1 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y N Y F Le spectacle est annulé US Show Cancelled 40 1=1 nvl(prla.cancel_flag,'N') = 'N' N F Le spectacle est annulé US Show Cancelled 41 180 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'req') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) US Category Set 1 42 190 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'req') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) US Category Set 2 43 200 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'req') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 44 210 &item_dff_cols select xxen_util.dff_columns(p_table_name=>'MTL_SYSTEM_ITEMS_B',p_table_alias=>'msiv',p_row_id=>'rowid',p_column_name_prefix=>'Item: ', p_display_mode=>:item_dff_display) dff_column from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US Item DFF Display 45 &item_dff_cols_disp select xxen_util.dff_columns(p_table_name=>'MTL_SYSTEM_ITEMS_B', p_prefix=>'req.',p_column_name_prefix=>'Item: ', p_display_mode=>:item_dff_display) from dual US Item DFF Display 46 220 &req_dff_cols select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_HEADERS_ALL',p_table_alias=>'prha',p_row_id=>'rowid',p_column_name_prefix=>'Req Hdr: ', p_display_mode=>:requisition_dff_display) dff_column from dual union all select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_LINES_ALL',p_table_alias=>'prla',p_row_id=>'rowid',p_column_name_prefix=>'Req Ln: ', p_display_mode=>:requisition_dff_display) dff_column from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US Requisition DFF Display 47 &req_dff_cols_disp select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_HEADERS_ALL', p_prefix=>'req.',p_column_name_prefix=>'Req Hdr: ', p_display_mode=>:requisition_dff_display) dff_columns from dual union all select xxen_util.dff_columns(p_table_name=>'PO_REQUISITION_LINES_ALL', p_prefix=>'req.',p_column_name_prefix=>'Req Ln: ', p_display_mode=>:requisition_dff_display) dff_columns from dual US Requisition DFF Display 48 230 &po_dff_cols select xxen_util.dff_columns(p_table_name=>'PO_HEADERS_ALL',p_table_alias=>'pha',p_row_id=>'rowid',p_column_name_prefix=>'PO Hdr: ', p_display_mode=>:po_dff_display) dff_columns from dual union all select xxen_util.dff_columns(p_table_name=>'PO_LINES_ALL',p_table_alias=>'pla',p_row_id=>'rowid',p_column_name_prefix=>'PO Ln: ', p_display_mode=>:po_dff_display) dff_columns from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D Y select 'V' id, 'Value' value, 'Value only' description from dual union all select 'C' id, 'Value: Description' value, 'Concatenated value and description' description from dual union all select 'S' id, 'Value, Description' value, 'Value and description in separate columns' description from dual fnd_profile.value('XXEN_REPORT_DFF_DISPLAY') US PO DFF Display 49 &po_dff_cols_disp select xxen_util.dff_columns(p_table_name=>'PO_HEADERS_ALL', p_prefix=>'po.',p_column_name_prefix=>'PO Hdr: ', p_display_mode=>:po_dff_display) dff_columns from dual union all select xxen_util.dff_columns(p_table_name=>'PO_LINES_ALL', p_prefix=>'po.',p_column_name_prefix=>'PO Ln: ', p_display_mode=>:po_dff_display) dff_columns from dual US PO DFF Display 50 235 &ap_columns po.invoice_numbers, po.invoice_date, po.invoiced_amount, po.invoice_amount_paid, po.payment_status, po.payment_numbers, po.payment_date, po.payment_method, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Invoice and Payment Details 51 &ap_cte_columns ( select rtrim(xmlagg(xmlelement(e,z.invoice_num||', ') order by z.invoice_num).extract('//text()').getclobval(),', ') from ( select distinct aia.invoice_id, aia.invoice_num from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoices_all aia where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aia.invoice_id ) z ) invoice_numbers, ( select trunc(max(aia.invoice_date)) from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoices_all aia where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aia.invoice_id ) invoice_date, ( select sum(aida.amount) from ap_invoice_distributions_all aida, po_distributions_all pda2 where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id ) invoiced_amount, ( select sum(z.amount_paid) from ( select distinct aia.invoice_id, aia.amount_paid from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoices_all aia where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aia.invoice_id ) z ) invoice_amount_paid, ( select case when count(*)=0 then null when min(nvl(aia.payment_status_flag,'N'))='Y' then xxen_util.meaning('Y','INVOICE PAYMENT STATUS',200) when max(nvl(aia.payment_status_flag,'N')) in ('P','Y') then xxen_util.meaning('P','INVOICE PAYMENT STATUS',200) else xxen_util.meaning('N','INVOICE PAYMENT STATUS',200) end from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoices_all aia where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aia.invoice_id ) payment_status, ( select rtrim(xmlagg(xmlelement(e,z.check_number||', ') order by z.check_number).extract('//text()').getclobval(),', ') from ( select distinct aca.check_id, aca.check_number from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoice_payments_all aipa, ap_checks_all aca where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aipa.invoice_id and aipa.check_id=aca.check_id ) z ) payment_numbers, ( select trunc(max(aca.check_date)) from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoice_payments_all aipa, ap_checks_all aca where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aipa.invoice_id and aipa.check_id=aca.check_id ) payment_date, ( select rtrim(xmlagg(xmlelement(e,z.payment_method_name||', ') order by z.payment_method_name).extract('//text()').getclobval(),', ') from ( select distinct ipmv.payment_method_name from ap_invoice_distributions_all aida, po_distributions_all pda2, ap_invoice_payments_all aipa, ap_checks_all aca, iby_payment_methods_vl ipmv where plla.line_location_id=pda2.line_location_id and pda2.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aipa.invoice_id and aipa.check_id=aca.check_id and aca.payment_method_code=ipmv.payment_method_code ) z ) payment_method, Y US Show Invoice and Payment Details 52 240 1=1 gcck.segment1=:segment1 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT1 53 2=2 gcck.segment1=:segment1 US GL_SEGMENT1 54 250 1=1 gcck.segment1>=:segment1_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT1 From 55 2=2 gcck.segment1>=:segment1_from US GL_SEGMENT1 From 56 260 1=1 gcck.segment1<=:segment1_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT1' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment1_from US GL_SEGMENT1 To 57 2=2 gcck.segment1<=:segment1_to US GL_SEGMENT1 To 58 270 1=1 gcck.segment2=:segment2 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT2 59 2=2 gcck.segment2=:segment2 US GL_SEGMENT2 60 280 1=1 gcck.segment2>=:segment2_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT2 From 61 2=2 gcck.segment2>=:segment2_from US GL_SEGMENT2 From 62 290 1=1 gcck.segment2<=:segment2_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT2' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment2_from US GL_SEGMENT2 To 63 2=2 gcck.segment2<=:segment2_to US GL_SEGMENT2 To 64 300 1=1 gcck.segment3=:segment3 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT3 65 2=2 gcck.segment3=:segment3 US GL_SEGMENT3 66 310 1=1 gcck.segment3>=:segment3_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT3 From 67 2=2 gcck.segment3>=:segment3_from US GL_SEGMENT3 From 68 320 1=1 gcck.segment3<=:segment3_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT3' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment3_from US GL_SEGMENT3 To 69 2=2 gcck.segment3<=:segment3_to US GL_SEGMENT3 To 70 330 1=1 gcck.segment4=:segment4 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT4 71 2=2 gcck.segment4=:segment4 US GL_SEGMENT4 72 340 1=1 gcck.segment4>=:segment4_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT4 From 73 2=2 gcck.segment4>=:segment4_from US GL_SEGMENT4 From 74 350 1=1 gcck.segment4<=:segment4_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT4' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment4_from US GL_SEGMENT4 To 75 2=2 gcck.segment4<=:segment4_to US GL_SEGMENT4 To 76 360 1=1 gcck.segment5=:segment5 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT5 77 2=2 gcck.segment5=:segment5 US GL_SEGMENT5 78 370 1=1 gcck.segment5>=:segment5_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT5 From 79 2=2 gcck.segment5>=:segment5_from US GL_SEGMENT5 From 80 380 1=1 gcck.segment5<=:segment5_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT5' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment5_from US GL_SEGMENT5 To 81 2=2 gcck.segment5<=:segment5_to US GL_SEGMENT5 To 82 390 1=1 gcck.segment6=:segment6 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT6' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT6 83 2=2 gcck.segment6=:segment6 US GL_SEGMENT6 84 400 1=1 gcck.segment6>=:segment6_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT6' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT6 From 85 2=2 gcck.segment6>=:segment6_from US GL_SEGMENT6 From 86 410 1=1 gcck.segment6<=:segment6_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT6' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment6 US GL_SEGMENT6 To 87 2=2 gcck.segment6<=:segment6_to US GL_SEGMENT6 To 88 420 1=1 gcck.segment7=:segment7 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT7' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT7 89 2=2 gcck.segment7=:segment7 US GL_SEGMENT7 90 430 1=1 gcck.segment7>=:segment7_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT7' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT7 From 91 2=2 gcck.segment7>=:segment7_from US GL_SEGMENT7 From 92 440 1=1 gcck.segment7<=:segment7_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT7' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment7_from US GL_SEGMENT7 To 93 2=2 gcck.segment7<=:segment7_to US GL_SEGMENT7 To 94 450 1=1 gcck.segment8=:segment8 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT8' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT8 95 2=2 gcck.segment8=:segment8 US GL_SEGMENT8 96 460 1=1 gcck.segment8>=:segment8_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT8' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT8 From 97 2=2 gcck.segment8>=:segment8_from US GL_SEGMENT8 From 98 470 1=1 gcck.segment8<=:segment8_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT8' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment8_from US GL_SEGMENT8 To 99 2=2 gcck.segment8<=:segment8_to US GL_SEGMENT8 To 100 480 1=1 gcck.segment9=:segment9 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT9' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT9 101 2=2 gcck.segment9=:segment9 US GL_SEGMENT9 102 490 1=1 gcck.segment9>=:segment9_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT9' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT9 From 103 2=2 gcck.segment9>=:segment9_from US GL_SEGMENT9 From 104 500 1=1 gcck.segment9<=:segment9_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT9' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment9_from US GL_SEGMENT9 To 105 2=2 gcck.segment9<=:segment9_to US GL_SEGMENT9 To 106 510 1=1 gcck.segment10=:segment10 LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT10' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT10 107 2=2 gcck.segment10=:segment10 US GL_SEGMENT10 108 520 1=1 gcck.segment10>=:segment10_from LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT10' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value US GL_SEGMENT10 From 109 2=2 gcck.segment10>=:segment10_from US GL_SEGMENT10 From 110 530 1=1 gcck.segment10<=:segment10_to LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and fifsgv.application_column_name='SEGMENT10' and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (xxen_util.contains(:$flex$.ledger,gl.name)='Y' or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) ) ) and :$flex$.report_level in('Distribution','Distribution with SLA') order by ffvv.flex_value $flex$.gl_segment_10_from US GL_SEGMENT10 To 111 2=2 gcck.segment10<=:segment10_to US GL_SEGMENT10 To