ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5AD40B806DC02106E0530100007F3595Y select x.operating_unit, x.po_number, x.closed_date, x.revision, x.supplier_name, x.supplier_site, x.buyer, x.status, x.description, x.pay_on, x.release, x.release_revision, x.release_status, x.line_num, x.line_type, x.project, x.task, x.item, x.item_description, x.item_type, &category_columns x.uom, x.frozen_cost, x.pending_cost, x.shipment_number, x.distribution_num, x.price, x.price_break_quantity, x.break_price, x.break_price_discount, x.quantity, x.amount, x.currency, x.exchange_rate_type, x.exchange_rate_date, x.exchange_rate, x.wip_job, x.wip_job_batch, xxen_util.client_time(x.need_by_date) need_by, xxen_util.client_time(x.last_accept_date) last_accept_date, xxen_util.client_time(x.promised_date) promised, xxen_util.client_time(x.original_promise) original_promise, x.supplier_item, x.contact_name, x.contact_phone, x.contact_email, x.destination_type, x.ship_to_organization, x.ship_to, xxen_util.client_time(x.approved_date) approved_date, xxen_util.client_time(x.request_date) request_date, x.match_approval_level, x.match_option, xxen_util.meaning(x.accrue_on_receipt_flag,'YES_NO',0) accrue_on_receipt, trunc(xxen_util.client_time(x.receipt_date)) receipt_date, to_char(xxen_util.client_time(x.receipt_date),'HH24:MI:SS') receipt_time, round(x.receipt_date-x.approved_date) delivery_time, x.delivery_delay, aia.invoice_num invoice, aila.line_number invoice_line, aia.invoice_date, aila.accounting_date, aila.period_name, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, aila.amount invoice_line_amount, aia.invoice_amount, aia.amount_paid, x.receiver, x.location_code, x.receiving_organization, x.packing_slip, x.receipt, x.receipt_line_number, x.receipt_quantity, x.quantity_ordered, x.quantity_cancelled, x.quantity_received, x.quantity_delivered, x.quantity_due, x.quantity_billed, case when(x.quantity_delivered - x.quantity_billed)<0 then 0 else (x.quantity_delivered - x.quantity_billed) end grni_quantity, case when(x.quantity_delivered - x.quantity_billed)<0 then 0 else (x.price * (x.quantity_delivered - x.quantity_billed)) end grni_amount, x.primary_quantity, x.primary_unit_of_measure, x.po_unit_price, x.receiving_shipment_number, x.shipped_date, x.quantity_shipped, x.vendor_item_num, x.shipment_line_status, x.asn_line_flag, x.note_to_vendor, x.header_note_to_receiver, x.line_note_to_receiver, x.supplier_number, x.supplier_address1, x.supplier_address2, x.supplier_address3, x.supplier_zip, x.supplier_city, x.supplier_country, x.document_type, x.document_number, x.document_revision, x.document_closed_status, xxen_util.client_time(x.document_creation_date) document_creation_date, x.document_created_by, xxen_util.client_time(x.document_revised_date) document_revised_date, x.document_total_amount, x.document_amount_limit, x.document_min_release_amount, nvl2(x.po_release_id,x.release_amount,x.po_amount) document_amount, nvl2(x.po_release_id,x.release_matched_amount,x.po_matched_amount) document_matched_amount, x.charge_account, x.accrual_account, x.item_expense_account, x.item_expense_account_desc, &dff_columns2 -- po line attachment fad.count po_line_attachment_count, &attachment_columns x.po_created_by, xxen_util.client_time(x.po_creation_date) po_creation_date, x.release_created_by, xxen_util.client_time(x.release_creation_date) release_creation_date, x.po_header_id, x.po_line_id, x.line_location_id, x.po_release_id, x.rcv_transaction_id &il_reg_columns &il_cols_outer from ( --Q1 Standard POs and Releases. i.e. Actual and Planned Shipments/Releases select hou.name operating_unit, pha.segment1 po_number, pha.revision_num revision, pha.closed_date, aps.vendor_name supplier_name, assa.vendor_site_code supplier_site, ppx.full_name buyer, po_headers_sv3.get_po_status(pha.po_header_id) status, pha.comments description, xxen_util.meaning(pha.pay_on_code,'PAY ON CODE',201) pay_on, po_inq_sv.get_po_total(pha.type_lookup_code,pha.po_header_id,null) po_amount, ( select sum(decode(polla.matching_basis,'AMOUNT', (nvl(polla.amount_financed,0)+nvl(polla.amount_billed,0)-nvl(polla.amount_recouped,0)), (nvl(polla.quantity_financed,0)+nvl(polla.quantity_billed,0)-nvl(polla.quantity_recouped,0))*nvl(polla.price_override,0) )) from po_line_locations_all polla where polla.po_header_id = pha.po_header_id and polla.shipment_type != 'SCHEDULED' ) po_matched_amount, pra.release_num release, pra.revision_num release_revision, po_releases_sv2.get_release_status(pra.po_release_id) release_status, nvl2(pra.po_release_id,po_inq_sv.get_po_total(null,null,pra.po_release_id),null) release_amount, nvl2(pra.po_release_id,decode(:p_show_distributions,'Y',nvl(pda.amount_billed,0),(select nvl(sum(nvl(pda.amount_billed,0)),0) from po_distributions_all pda where pra.po_release_id=pda.po_release_id)),null) release_matched_amount, pla.line_num, pltv.line_type, u.project, v.task, msiv.concatenated_segments item, coalesce(rsl.item_description,msiv.description,pla.item_description) item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, nvl2(nvl(mp2.organization_id,mp.organization_id),nvl(mp2.organization_id,mp.organization_id),msiv.organization_id) organization_id, msiv.inventory_item_id, muomt.unit_of_measure_tl uom, cic1.item_cost frozen_cost, cic3.item_cost pending_cost, plla.shipment_num shipment_number, pda.distribution_num, nvl(plla.price_override,pla.unit_price) price, to_number(null) price_break_quantity, to_number(null) break_price, to_number(null) break_price_discount, decode(:p_show_distributions,'Y',pda.quantity_ordered,plla.quantity) quantity, decode(:p_show_distributions,'Y',pda.quantity_ordered,plla.quantity)*nvl(plla.price_override,pla.unit_price) amount, pha.currency_code currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = pha.rate_type) exchange_rate_type, pha.rate_date exchange_rate_date, pha.rate exchange_rate, ( select distinct listagg(y.wip_entity_name,', ') within group (order by y.wip_entity_name) over (partition by y.line_id) wip_entity_name from ( select distinct mipo.line_id, we.wip_entity_name from mrp_item_purchase_orders mipo, mrp_recommendations mr, mrp_full_pegging mfp, mrp_gross_requirements mgr, wip_entities we where mipo.transaction_id=mr.disposition_id and mr.order_type in (1,8) and mr.organization_id=mfp.organization_id and mr.compile_designator=mfp.compile_designator and mr.transaction_id=mfp.transaction_id and mfp.demand_id=mgr.demand_id and mgr.origination_type in (2,3,17,25,26) and mgr.disposition_id=we.wip_entity_id ) y where pla.po_line_id=y.line_id ) wip_job, decode(:p_show_distributions,'Y', (select we.wip_entity_name from wip_entities we where pda.wip_entity_id=we.wip_entity_id), (select distinct listagg(y.wip_entity_name,', ') within group (order by y.wip_entity_name) over (partition by y.line_location_id) wip_entity_name from (select distinct pda.line_location_id, we.wip_entity_name from po_distributions_all pda, wip_entities we where pda.wip_entity_id=we.wip_entity_id ) y where plla.line_location_id=y.line_location_id ) ) wip_job_batch, plla.need_by_date, plla.last_accept_date, plla.promised_date, (select distinct min(pllaa.promised_date) keep (dense_rank first order by pllaa.revision_num) promised_date from po_line_locations_archive_all pllaa where plla.line_location_id=pllaa.line_location_id and pllaa.promised_date is not null) original_promise, pla.vendor_product_num supplier_item, nvl2(pvc.first_name,pvc.first_name||' ',null)||nvl2(pvc.middle_name,pvc.middle_name||' ',null)||pvc.first_name contact_name, pvc.area_code||pvc.phone contact_phone, pvc.email_address contact_email, xxen_util.meaning(decode(:p_show_distributions,'Y',pda.destination_type_code,(select pda.destination_type_code from po_distributions_all pda where plla.line_location_id=pda.line_location_id and rownum=1)),'DESTINATION TYPE',201) destination_type, mp.organization_code ship_to_organization, hlat.location_code ship_to, rsh.receipt_num receipt, ( select distinct min(pah.action_date) keep (dense_rank first order by pah.sequence_num) over (partition by pah.object_type_code,pah.object_sub_type_code,pah.object_id) action_date from po_action_history pah where nvl(plla.po_release_id,pha.po_header_id)=pah.object_id and nvl2(plla.po_release_id,'RELEASE','PO')=pah.object_type_code and nvl2(plla.po_release_id,'BLANKET','STANDARD')=pah.object_sub_type_code and pah.action_code='APPROVE' ) approved_date, coalesce(plla.promised_date,plla.need_by_date,plla.last_accept_date) request_date, decode(pha.type_lookup_code,'STANDARD', case when plla.inspection_required_flag='N' and plla.receipt_required_flag='N' then '2-Way' when plla.inspection_required_flag='N' and plla.receipt_required_flag='Y' then '3-Way' when plla.inspection_required_flag='Y' and plla.receipt_required_flag='Y' then '4-Way' end) match_approval_level, xxen_util.meaning(plla.match_option,'POS_INVOICE_MATCH_OPTION',0) match_option, plla.accrue_on_receipt_flag, rt.transaction_date receipt_date, trunc(rt.transaction_date-coalesce(plla.promised_date,plla.need_by_date,plla.last_accept_date)) delivery_delay, ppx2.full_name receiver, hla.location_code, mp2.organization_code receiving_organization, rsh.packing_slip, rsl.line_num receipt_line_number, rt.quantity receipt_quantity, decode(:p_show_distributions,'Y',pda.quantity_ordered,nvl(plla.quantity, pla.quantity)) quantity_ordered, decode(:p_show_distributions,'Y',pda.quantity_cancelled,plla.quantity_cancelled) quantity_cancelled, decode(:p_show_distributions,'Y', plla.quantity_received*(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))/xxen_util.zero_to_null(plla.quantity-nvl(plla.quantity_cancelled,0)), plla.quantity_received ) quantity_received, decode(:p_show_distributions,'Y', pda.quantity_ordered-nvl(pda.quantity_cancelled,0)-(plla.quantity_received*(pda.quantity_ordered-nvl(pda.quantity_cancelled,0))/xxen_util.zero_to_null(plla.quantity-nvl(plla.quantity_cancelled,0))), nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0) ) quantity_due, decode(:p_show_distributions,'Y',pda.quantity_billed,plla.quantity_billed) quantity_billed, decode(:p_show_distributions,'Y',pda.quantity_delivered,0) quantity_delivered, rt.primary_quantity, rt.primary_unit_of_measure, coalesce(rt.po_unit_price,plla.price_override,pla.unit_price) po_unit_price, rsh.shipment_num receiving_shipment_number, rsh.shipped_date, rsl.quantity_shipped, rsl.vendor_item_num, xxen_util.meaning(rsl.shipment_line_status_code,'SHIPMENT LINE STATUS',201) shipment_line_status, xxen_util.meaning(rsl.asn_line_flag,'YES_NO',0) asn_line_flag, pla.note_to_vendor, pha.note_to_receiver header_note_to_receiver, plla.note_to_receiver line_note_to_receiver, aps.segment1 supplier_number, assa.address_line1 supplier_address1, assa.address_line2 supplier_address2, assa.address_line3 supplier_address3, assa.zip supplier_zip, assa.city supplier_city, nvl(ftv.territory_short_name,assa.country) supplier_country, pdtav.type_name document_type, pha.segment1 || nvl2(pra.po_release_id,' (' || pra.release_num || ')',null) document_number, nvl2(pra.po_release_id,pra.revision_num,pha.revision_num) document_revision, case when nvl2(pra.po_release_id,nvl(pra.closed_code,'x') ,nvl(pha.closed_code,'x')) in ('CLOSED','FINALLY CLOSED') then xxen_util.meaning('CLOSED','DOCUMENT STATE',201) else xxen_util.meaning('OPEN','DOCUMENT STATE',201) end document_closed_status, nvl2(pra.po_release_id,pra.creation_date,pha.creation_date) document_creation_date, xxen_util.user_name(nvl2(pra.po_release_id,pra.created_by,pha.created_by)) document_created_by, nvl2(pra.po_release_id,pra.revised_date,pha.revised_date) document_revised_date, to_number(null) document_total_amount, to_number(null) document_amount_limit, to_number(null) document_min_release_amount, case when pda.code_combination_id is not null then fnd_flex_xml_publisher_apis.process_kff_combination_1('seg','SQLGL','GL#',pda.chart_of_accounts_id,NULL,pda.code_combination_id,'ALL','Y','VALUE') end charge_account, case when pda.accrual_account_id is not null then fnd_flex_xml_publisher_apis.process_kff_combination_1('seg','SQLGL','GL#',pda.chart_of_accounts_id,NULL,pda.accrual_account_id,'ALL','Y','VALUE') else null end accrual_account, xxen_util.concatenated_segments(msiv.expense_account) item_expense_account, xxen_util.segments_description(msiv.expense_account) item_expense_account_desc, &dff_columns xxen_util.user_name(pha.created_by) po_created_by, pha.creation_date po_creation_date, xxen_util.user_name(pra.created_by) release_created_by, pra.creation_date release_creation_date, pha.vendor_id, pha.vendor_site_id, pha.po_header_id, pla.po_line_id, plla.line_location_id, pra.po_release_id, rt.transaction_id rcv_transaction_id from po_headers_all pha, ( select pla.rowid row_id, pla.*, (select fspa.inventory_organization_id from financials_system_params_all fspa where hou.set_of_books_id=fspa.set_of_books_id and pla.org_id=fspa.org_id) inventory_organization_id, hou.name operating_unit from po_lines_all pla, hr_operating_units hou where 2=2 and pla.org_id=hou.organization_id ) pla, po_line_locations_all plla, ( select pda.*, (select gsob.chart_of_accounts_id from gl_sets_of_books gsob where gsob.set_of_books_id = pda.set_of_books_id) chart_of_accounts_id from po_distributions_all pda where :p_show_distributions='Y' ) pda, po_releases_all pra, ( select pda.line_location_id, listagg(ppa.segment1,', ') within group (order by ppa.segment1) project from (select distinct pda.line_location_id, pda.project_id from po_distributions_all pda where pda.project_id is not null) pda, pa_projects_all ppa where pda.project_id=ppa.project_id group by pda.line_location_id ) u, ( select pda.line_location_id, listagg(pda.task_number,', ') within group (order by pda.task_number) task from ( select distinct pda.line_location_id, pt.task_number from po_distributions_all pda, pa_tasks pt where pda.task_id=pt.task_id ) pda group by pda.line_location_id ) v, hr_operating_units hou, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv, po_vendor_contacts pvc, po_document_types_all_vl pdtav, po_line_types_v pltv, hr_locations_all_tl hlat, per_people_x ppx, rcv_shipment_lines rsl, rcv_shipment_headers rsh, rcv_transactions rt, per_people_x ppx2, hr_locations_all hla, mtl_parameters mp, mtl_parameters mp2, mtl_system_items_vl msiv, mtl_units_of_measure_tl muomt, mtl_categories_kfv mck, cst_item_costs cic1, cst_item_costs cic3 where 1=1 and 3=3 and pha.type_lookup_code in ('STANDARD','BLANKET','PLANNED') and pha.po_header_id=pla.po_header_id and pla.po_line_id=plla.po_line_id and plla.shipment_type in ('STANDARD','BLANKET','PLANNED','SCHEDULED') and plla.line_location_id=pda.line_location_id(+) and plla.po_release_id=pra.po_release_id(+) and plla.line_location_id=u.line_location_id(+) and plla.line_location_id=v.line_location_id(+) and pha.vendor_id=aps.vendor_id and pha.vendor_site_id=assa.vendor_site_id and pha.org_id=hou.organization_id and assa.country=ftv.territory_code(+) and pha.vendor_contact_id=pvc.vendor_contact_id(+) and pha.vendor_site_id=pvc.vendor_site_id(+) and nvl2(pra.po_release_id,pra.release_type,pha.type_lookup_code)=pdtav.document_subtype and nvl2(pra.po_release_id,pra.org_id,pha.org_id)=pdtav.org_id and (pra.po_release_id is null and pdtav.document_type_code in ('PO','PA') or pra.po_release_id is not null and pdtav.document_type_code='RELEASE') and pla.line_type_id=pltv.line_type_id(+) and plla.ship_to_organization_id=mp.organization_id(+) and plla.ship_to_location_id=hlat.location_id(+) and hlat.language(+)=userenv('lang') and pla.inventory_organization_id=msiv.organization_id(+) and pla.item_id=msiv.inventory_item_id(+) and pla.unit_meas_lookup_code=muomt.unit_of_measure(+) and muomt.language(+)=userenv('lang') and pla.category_id=mck.category_id(+) and pla.inventory_organization_id=cic1.organization_id(+) and pla.inventory_organization_id=cic3.organization_id(+) and pla.item_id=cic1.inventory_item_id(+) and pla.item_id=cic3.inventory_item_id(+) and cic1.cost_type_id(+)=1 and cic3.cost_type_id(+)=3 and pha.agent_id=ppx.person_id(+) and &lp_shipment_line_join rsl.shipment_header_id=rsh.shipment_header_id(+) and rsl.shipment_line_id=rt.shipment_line_id(+) and rt.transaction_type(+)='RECEIVE' and rt.employee_id=ppx2.person_id(+) and rt.location_id=hla.location_id(+) and rt.organization_id=mp2.organization_id(+) union all --Q2 Blanket and Contract Purchase Agreements select hou.name operating_unit, pha.segment1 po_number, pha.revision_num revision, pha.closed_date, aps.vendor_name supplier_name, assa.vendor_site_code supplier_site, ppx.full_name buyer, po_headers_sv3.get_po_status(pha.po_header_id) status, pha.comments description, xxen_util.meaning(pha.pay_on_code,'PAY ON CODE',201) pay_on, po_inq_sv.get_po_total(pha.type_lookup_code,pha.po_header_id,null) po_amount, ( select sum(decode(polla.matching_basis,'AMOUNT', (nvl(polla.amount_financed,0)+nvl(polla.amount_billed,0)-nvl(polla.amount_recouped,0)), (nvl(polla.quantity_financed,0)+nvl(polla.quantity_billed,0)-nvl(polla.quantity_recouped,0))*nvl(polla.price_override,0) )) from po_line_locations_all polla where polla.po_header_id = pha.po_header_id and polla.shipment_type != 'SCHEDULED' ) po_matched_amount, null release, null release_status, null release_revision, null release_amount, null release_matched_amount, pla.line_num, pltv.line_type, null project, null task, msiv.concatenated_segments item, coalesce(msiv.description,pla.item_description) item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) item_type, nvl2(mp.organization_id,mp.organization_id,msiv.organization_id) organization_id, msiv.inventory_item_id, muomt.unit_of_measure_tl uom, cic1.item_cost frozen_cost, cic3.item_cost pending_cost, plla.shipment_num shipment_number, null distribution_num, pla.unit_price price, plla.quantity price_break_quantity, nvl(plla.price_override,pla.unit_price) break_price, plla.price_discount break_price_discount, null quantity, null amount, pha.currency_code currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = pha.rate_type) exchange_rate_type, pha.rate_date exchange_rate_date, pha.rate exchange_rate, null wip_job, null wip_job_batch, null need_by_date, null last_accept_date, null promised_date, null original_promise, pla.vendor_product_num supplier_item, nvl2(pvc.first_name,pvc.first_name||' ',null)||nvl2(pvc.middle_name,pvc.middle_name||' ',null)||pvc.first_name contact_name, pvc.area_code||pvc.phone contact_phone, pvc.email_address contact_email, null destination_type, mp.organization_code ship_to_organization, hlat.location_code ship_to, null receipt, ( select distinct min(pah.action_date) keep (dense_rank first order by pah.sequence_num) over (partition by pah.object_type_code,pah.object_sub_type_code,pah.object_id) action_date from po_action_history pah where pha.po_header_id=pah.object_id and pah.object_type_code = 'PA' and pah.object_sub_type_code=pha.type_lookup_code and pah.action_code='APPROVE' ) approved_date, null request_date, null match_approval_level, null match_option, plla.accrue_on_receipt_flag, null receipt_date, null delivery_delay, null receiver, null location_code, null receiving_organization, null packing_slip, null receipt_line_number, null receipt_quantity, nvl(plla.quantity, pla.quantity) quantity_ordered, null quantity_cancelled, null quantity_received, null quantity_delivered, null quantity_due, null quantity_billed, null primary_quantity, null primary_unit_of_measure, nvl(plla.price_override,pla.unit_price) po_unit_price, null receiving_shipment_number, null shipped_date, null quantity_shipped, null vendor_item_num, null shipment_line_status, null asn_line_flag, pla.note_to_vendor, null header_note_to_receiver, null line_note_to_receiver, aps.segment1 supplier_number, assa.address_line1 supplier_address1, assa.address_line2 supplier_address2, assa.address_line3 supplier_address3, assa.zip supplier_zip, assa.city supplier_city, nvl(ftv.territory_short_name,assa.country) supplier_country, pdtav.type_name document_type, pha.segment1 document_number, pha.revision_num document_revision, case when nvl(pha.closed_code,'x') in ('CLOSED','FINALLY CLOSED') then xxen_util.meaning('CLOSED','DOCUMENT STATE',201) else xxen_util.meaning('OPEN','DOCUMENT STATE',201) end document_closed_status, pha.creation_date document_creation_date, xxen_util.user_name(pha.created_by) document_created_by, pha.revised_date document_revised_date, pha.blanket_total_amount document_total_amount, pha.amount_limit document_amount_limit, pha.min_release_amount document_min_release_amount, null charge_account, null accrual_account, xxen_util.concatenated_segments(msiv.expense_account) item_expense_account, xxen_util.segments_description(msiv.expense_account) item_expense_account_desc, &dff_columns xxen_util.user_name(pha.created_by) po_created_by, pha.creation_date po_creation_date, null release_created_by, null release_creation_date, pha.vendor_id, pha.vendor_site_id, pha.po_header_id, pla.po_line_id, plla.line_location_id, null po_release_id, null rcv_transaction_id from po_headers_all pha, ( select pla.rowid row_id, pla.*, (select fspa.inventory_organization_id from financials_system_params_all fspa where hou.set_of_books_id=fspa.set_of_books_id and pla.org_id=fspa.org_id) inventory_organization_id, hou.name operating_unit from po_lines_all pla, hr_operating_units hou where 2=2 and pla.org_id=hou.organization_id ) pla, ( select pda.* from po_distributions_all pda where 'N'='Y' ) pda, po_line_locations_all plla, po_releases_all pra, hr_operating_units hou, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv, po_vendor_contacts pvc, po_document_types_all_vl pdtav, po_line_types_v pltv, mtl_parameters mp, hr_locations_all_tl hlat, per_people_x ppx, mtl_system_items_vl msiv, mtl_units_of_measure_tl muomt, mtl_categories_kfv mck, cst_item_costs cic1, cst_item_costs cic3 where 1=1 and 4=4 and pha.type_lookup_code in ('BLANKET','CONTRACT') and pha.po_header_id=pla.po_header_id(+) and pla.po_line_id=plla.po_line_id(+) and plla.shipment_type(+) not in ('BLANKET') and --po_releases added for the common dynamic parameter where clauses --but does not return anything in this query pra.po_release_id(+)= -plla.po_release_id and pda.po_header_id(+)=pha.po_header_id and pha.vendor_id=aps.vendor_id and pha.vendor_site_id=assa.vendor_site_id and pha.org_id=hou.organization_id and assa.country=ftv.territory_code(+) and pha.vendor_contact_id=pvc.vendor_contact_id(+) and pha.vendor_site_id=pvc.vendor_site_id(+) and pha.type_lookup_code=pdtav.document_subtype and pha.org_id=pdtav.org_id and pdtav.document_type_code in ('PA') and pla.line_type_id=pltv.line_type_id(+) and plla.ship_to_organization_id=mp.organization_id(+) and plla.ship_to_location_id=hlat.location_id(+) and hlat.language(+)=userenv('lang') and pla.inventory_organization_id=msiv.organization_id(+) and pla.item_id=msiv.inventory_item_id(+) and pla.unit_meas_lookup_code=muomt.unit_of_measure(+) and muomt.language(+)=userenv('lang') and pla.category_id=mck.category_id(+) and pla.inventory_organization_id=cic1.organization_id(+) and pla.inventory_organization_id=cic3.organization_id(+) and pla.item_id=cic1.inventory_item_id(+) and pla.item_id=cic3.inventory_item_id(+) and cic1.cost_type_id(+)=1 and cic3.cost_type_id(+)=3 and pha.agent_id=ppx.person_id(+) ) x, ap_invoice_lines_all aila, ap_invoices_all aia, (select distinct fad.pk1_value,&fad_document_id count(*) over (partition by fad.pk1_value) count from fnd_attached_documents fad where '&show_attachments'='Y' and fad.entity_name='PO_LINES') fad, fnd_documents fd, fnd_documents_tl fdt, fnd_document_datatypes fdd, fnd_document_categories_vl fdcv, fnd_lobs fl, fnd_documents_short_text fdst, fnd_documents_long_text fdlt &il_from where x.line_location_id=aila.po_line_location_id(+) and (x.rcv_transaction_id=aila.rcv_transaction_id or x.rcv_transaction_id is null or aila.rcv_transaction_id is null) and nvl(aila.discarded_flag(+),'N')='N' and aila.invoice_id=aia.invoice_id(+) and to_char(x.po_line_id)=fad.pk1_value(+) and fad.document_id=fd.document_id(+) and fd.document_id=fdt.document_id(+) and fdt.language(+)=userenv('lang') and fd.datatype_id=fdd.datatype_id(+) and fdd.language(+)=userenv('lang') and fd.category_id=fdcv.category_id(+) and fd.media_id=fl.file_id(+) and decode(fd.datatype_id,1,fd.media_id)=fdst.media_id(+) and decode(fd.datatype_id,2,fd.media_id)=fdlt.media_id(+) &il_where order by x.operating_unit, x.po_number, x.release desc, x.line_num, x.release desc nulls last, x.shipment_number desc, x.distribution_num, x.item, xxen_util.client_time(x.po_creation_date) desc, fad.seq_num Aggregated the project and task inline views with group by so the shipment join predicate can be pushed into them, and added India GST columns, displayed only when India Localization is installed. AR PO Headers and Lines رؤوس أوامر الشراء والبنود وحركات الاستلام وفواتير AP المقابلة D PO Headers and Lines Bestellkopf, Zeilen, Eingangstransaktionen und entsprechende Eingangsrechnungen E PO Headers and Lines Encabezados de pedidos, líneas, transacciones de recepción y facturas AP correspondientes F PO Headers and Lines les en-têtes, les lignes, les transactions de réception et les factures AP correspondantes I PO Headers and Lines Intestazioni di OP, linee, transazioni di ricezione e fatture AP corrispondenti JA PO Headers and Lines POヘッダー、ライン、受信取引、および対応するAP請求書 KO PO Headers and Lines PO 헤더, 라인, 입고 트랜잭션 및 해당 AP 송장 PTB PO Headers and Lines Cabeçalhos de PO, linhas, recebimento de transações e faturas de AP correspondentes RU PO Headers and Lines Заголовки PO, строки, получаемые транзакции и соответствующие AP-фактуры S PO Headers and Lines PO-rubriker, rader, mottagande av transaktioner och motsvarande AP-fakturor TR PO Headers and Lines PO başlıkları, satırlar, alım işlemleri ve ilgili AP faturaları US PO Headers and Lines PO headers, lines, receiving transactions and corresponding AP invoices When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CGST Rate, SGST Rate, IGST Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code. ZHS PO Headers and Lines PO标题、行、接收交易和相应的AP发票。 Enginatics &attachment_columns &category_columns &dff_columns &dff_columns2 &fad_document_id &il_cols_outer &il_from &il_reg_columns &il_where &lp_shipment_line_join &show_attachments 1=1 2=2 3=3 4=4 :p_show_distributions 1 -20 1=1 :India_Localization=:India_Localization Char Y xxen_util.jai_installed US India Localization 2 &il_cols_outer ,il_tax.cgst_amount "CGST Amount" ,il_tax.sgst_amount "SGST Amount" ,il_tax.igst_amount "IGST Amount" ,il_tax.cgst_tax_rate "CGST Rate" ,il_tax.sgst_tax_rate "SGST Rate" ,il_tax.igst_tax_rate "IGST Rate", il_tax.custom_amount "Custom Amount", il_tax.unclassified_amount "Unclassified Tax Amount", il_tax.taxable_value "Taxable Value", il_tax.hsn_sac_code "HSN SAC Code" Y US India Localization 3 &il_from ,(select jpr.party_id, jpr.party_site_id, coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.registration_type_code in ('GST','GSTIN') then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_site, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_site, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_site, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_site from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY_SITE' and jpr.supplier_flag='Y' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id, jpr.party_site_id) il_reg_site ,(select jpr.party_id, coalesce(max(case when jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') and jprl.registration_type_code in ('GST','GSTIN') then nvl(jprl.registration_number,jprl.secondary_registration_number) end),max(case when regexp_like(nvl(jprl.registration_number,jprl.secondary_registration_number),'^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z][0-9A-Z]Z[0-9A-Z]$') and jprl.regime_id in (select jr.regime_id from jai_regimes jr where jr.regime_type='T') then nvl(jprl.registration_number,jprl.secondary_registration_number) end)) gstin_hdr, max(decode(jprl.registration_type_code,'PAN',jprl.registration_number)) pan_hdr, max(decode(jprl.registration_type_code,'TAN',jprl.registration_number)) tan_hdr, max(decode(jprl.sec_registration_type_code,'PAN',jprl.secondary_registration_number)) sec_pan_hdr, max(decode(jprl.sec_registration_type_code,'TAN',jprl.secondary_registration_number)) sec_tan_hdr from jai_party_regs_v jpr, jai_party_reg_lines_v jprl where jpr.party_reg_id=jprl.party_reg_id and jpr.party_type_code='THIRD_PARTY' and jpr.supplier_flag='Y' and jprl.effective_from<=sysdate and (jprl.effective_to is null or jprl.effective_to>=sysdate) group by jpr.party_id) il_reg_hdr ,(select jtlv.trx_id, jtlv.trx_line_id, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_tax_amt_trx_curr)) cgst_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rounded_tax_amt_trx_curr)) sgst_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rounded_tax_amt_trx_curr)) igst_amount, sum(decode(jrav.reporting_code,'CESS',jtlv.rounded_tax_amt_trx_curr)) cess_amount, max(decode(jrav.reporting_code,'CGST',jtlv.tax_rate_code)) cgst_tax_rate, max(decode(jrav.reporting_code,'SGST',jtlv.tax_rate_code)) sgst_tax_rate, max(decode(jrav.reporting_code,'IGST',jtlv.tax_rate_code)) igst_tax_rate, max(decode(jrav.reporting_code,'CESS',jtlv.tax_rate_code)) cess_tax_rate, sum(decode(jrav.reporting_code,'CGST',jtlv.rec_tax_amt_trx_curr)) cgst_rec_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.nrec_tax_amt_trx_curr)) cgst_nrec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.rec_tax_amt_trx_curr)) sgst_rec_amount, sum(decode(jrav.reporting_code,'SGST',jtlv.nrec_tax_amt_trx_curr)) sgst_nrec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.rec_tax_amt_trx_curr)) igst_rec_amount, sum(decode(jrav.reporting_code,'IGST',jtlv.nrec_tax_amt_trx_curr)) igst_nrec_amount, max(jtlv.self_assessed_flag) reverse_charge_flag, sum(decode(jrav.reporting_code,'CUSTOM',jtlv.rounded_tax_amt_trx_curr)) custom_amount, sum(decode(jrav.reporting_code,null,jtlv.rounded_tax_amt_trx_curr)) unclassified_amount, sum(decode(jrav.reporting_code,'CGST',jtlv.rounded_taxable_amt_trx_curr,'IGST',jtlv.rounded_taxable_amt_trx_curr)) taxable_value, max(jrc.reporting_code) hsn_sac_code from jai_tax_lines_v jtlv, jai_reporting_associations_v jrav, jai_tax_det_factors jtdf, jai_reporting_codes jrc where jrav.entity_id(+)=jtlv.tax_type_id and jrav.entity_code(+)='TAX_TYPE' and jrav.reporting_type_code(+)='TAX_TYPES_CLASSIFICATION' and jtlv.det_factor_id=jtdf.det_factor_id(+) and jtdf.application_id(+)=201 and nvl(jtdf.hsn_code_id,jtdf.sac_code_id)=jrc.reporting_code_id(+) and jtlv.application_id=201 group by jtlv.trx_id, jtlv.trx_line_id ) il_tax Y US India Localization 4 &il_reg_columns ,nvl(il_reg_site.gstin,il_reg_hdr.gstin_hdr) "GST Registration No", nvl(il_reg_site.pan_site,nvl(il_reg_site.sec_pan_site,nvl(il_reg_hdr.pan_hdr,il_reg_hdr.sec_pan_hdr))) "GST PAN No", nvl(il_reg_site.tan_site,nvl(il_reg_site.sec_tan_site,nvl(il_reg_hdr.tan_hdr,il_reg_hdr.sec_tan_hdr))) "GST TAN No" Y US India Localization 5 &il_where and x.vendor_site_id=il_reg_site.party_site_id(+) and x.vendor_id=il_reg_hdr.party_id(+) and x.po_header_id=il_tax.trx_id(+) and x.po_line_id=il_tax.trx_line_id(+) Y US India Localization 6 -10 1=1 (plla.ship_to_organization_id,pla.item_id) in ( select distinct dbms_lob.substr(xrrpv.value,instr(xrrpv.value,'|')-1) organization_id, dbms_lob.substr(xrrpv.value,20,instr(xrrpv.value,'|')+1) inventory_item_id from xxen_report_parameters_v xrpv, xxen_report_run_param_values xrrpv where nvl(:tmp,'?') = nvl(:tmp,'?') and xrpv.parameter_name='organization_id|inventory_item_id' and xrpv.parameter_id=xrrpv.parameter_id and xrrpv.run_id=:run_id ) and nvl(pha.cancel_flag,'N')='N' and nvl(pla.cancel_flag,'N')='N' and nvl(plla.cancel_flag,'N')='N' and nvl(pra.cancel_flag,'N')='N' and nvl(pha.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(plla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pra.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') Char F organisation_id|inventory_item_id US organization_id|inventory_item_id 7 &lp_shipment_line_join plla.line_location_id=rsl.po_line_location_id(+) and US organization_id|inventory_item_id 8 10 2=2 hou.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 9 1=1 hou.name=:operating_unit F Unité d'exploitation US Operating Unit 10 20 3=3 nvl(mp2.organization_code,mp.organization_code)=:receiving_organization LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or not exists (select null from xxen_report_org_access xroa where xroa.access_type='INV') and ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) 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 F Organisation de réception US Receiving Organization 11 4=4 mp.organization_code=:receiving_organization US Receiving Organization 12 30 1=1 pha.segment1=:po_number LOV PO Number 8E2FF36EDEED79D2E0530100007F1FF2 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 F Numéro de PO US PO Number 13 40 1=1 pra.release_num=:release LOV PO Release D1CC0930FBE05C81E0530100007F5DC4 select pra.release_num value, fnd_date.date_to_displaydate(pra.release_date)||' ('||xxen_util.meaning(pra.authorization_status,'AUTHORIZATION STATUS',201)||')' description from po_releases_all pra where pra.po_header_id in (select pha.po_header_id from po_headers_all pha where pha.segment1=:$flex$.po_number and pha.type_lookup_code='BLANKET') and pra.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') order by pra.release_num desc F Communiqué de presse US Release 14 50 1=1 ppx.full_name=:buyer LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name F Acheteur US Buyer 15 60 1=1 aps.vendor_name=:supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 16 70 1=1 assa.vendor_site_code=:supplier_site LOV AP Supplier Site 8E2FF36EDF0279D2E0530100007F1FF2 select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where (:$flex$.ap_supplier is null or xxen_util.contains(:$flex$.ap_supplier,aps.vendor_name)='Y') and (:$flex$.ap_supplier_number is null or xxen_util.contains(:$flex$.ap_supplier_number,aps.segment1)='Y') and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code F Site du fournisseur US Supplier Site 17 80 1=1 msiv.concatenated_segments like :item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item 18 90 1=1 msiv.concatenated_segments >= :item_from LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article de US Item From 19 100 1=1 msiv.concatenated_segments <= :item_to LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments :$flex$.Item_From F Objet à US Item To 20 110 1=1 msiv.item_type=xxen_util.lookup_code(:item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code F Type d'article US Item Type 21 120 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 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 22 130 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 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 23 140 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'x') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 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 24 150 1=1 pla.po_line_id in ( select mipo.line_id from wip_entities we, mrp_gross_requirements mgr, mrp_full_pegging mfp, mrp_recommendations mr, mrp_item_purchase_orders mipo where we.wip_entity_name=:wip_job and we.wip_entity_id=mgr.disposition_id and mgr.origination_type in (2,3,17,25,26) and mgr.demand_id=mfp.demand_id and mfp.transaction_id=mr.transaction_id and mr.disposition_id=mipo.transaction_id and mr.order_type in (1,8) ) LOV custom Y Y select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700)||nvl2(we.description,': '||we.description,null) description from hr_all_organization_units_vl haouv, org_organization_definitions ood, wip_entities we where haouv.name=:$flex$.operating_unit and haouv.organization_id=ood.operating_unit and ood.organization_id=we.organization_id order by we.creation_date desc US WIP Job WIP job that the PO line is supplying, according to MRP pegging 25 160 1=1 pla.po_line_id in ( select pda.po_line_id from pa_projects_all ppa, po_distributions_all pda where ppa.segment1=:project and ppa.project_id=pda.project_id ) LOV PA Project Number 8E2FF36EDEDB79D2E0530100007F1FF2 select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) and ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc F Projet US Project 26 170 1=1 nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0)>0 LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Quantité ouverte US Has Open Quantity 27 1=1 nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0)=0 N F Quantité ouverte US Has Open Quantity 28 180 1=1 plla.promised_date is not null LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Promis US Promised 29 1=1 plla.promised_date is null N F Promis US Promised 30 190 3=3 plla.promised_date<=sysdate and rt.po_line_location_id is null and nvl(plla.quantity, pla.quantity)-nvl(plla.quantity_cancelled,0)-nvl(plla.quantity_received,0)>0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F En retard de paiement Date promise avant sysdate, mais pas encore de transaction de réception US Overdue Promised date before sysdate, but no receiving transaction yet 31 4=4 1=2 US Overdue 32 200 1=1 (pdtav.document_type_code,pdtav.document_subtype) in ( select pdtav2.document_type_code,pdtav2.document_subtype from po_document_types_all_vl pdtav2 where pdtav2.org_id = pha.org_id and pdtav2.type_name = :document_type ) LOV custom select pdtav.type_name value, null description from po_document_types_all_vl pdtav where pdtav.org_id in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') and pdtav.document_type_code in ('PO','PA','RELEASE') order by pdtav.type_name F Type de document US Document Type 33 210 1=1 nvl2(pra.po_release_id,nvl(pra.closed_code,'x') ,nvl(pha.closed_code,'x')) not in ('CLOSED','FINALLY CLOSED') LOV custom select meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'DOCUMENT STATE' and flvv.view_application_id = 201 and flvv.lookup_code in ('OPEN','CLOSED') order by flvv.meaning xxen_util.meaning('OPEN','DOCUMENT STATE',201) select xxen_util.meaning('OPEN','DOCUMENT STATE',201) value from dual where :$flex$.po_number is null and :$flex$.wip_job is null and :$flex$.project is null and :$flex$.need_by_date_from is null and :$flex$.need_by_date_to is null and :$flex$.receipt_date_from is null and :$flex$.receipt_date_to is null F Statut de clôture du document US Document Closure Status 34 1=1 nvl2(pra.po_release_id,nvl(pra.closed_code,'x') ,nvl(pha.closed_code,'x')) in ('CLOSED','FINALLY CLOSED') xxen_util.meaning('CLOSED','DOCUMENT STATE',201) F Statut de clôture du document US Document Closure Status 35 220 1=1 nvl2(pra.po_release_id,pra.creation_date,pha.creation_date)>=:creation_date_from Date F Date de création du document De US Document Creation Date From 36 230 1=1 nvl2(pra.po_release_id,pra.creation_date,pha.creation_date)<:creation_date_to+1 Date last_day(:$flex$.Document_Creation_Date_From) F Date de création du document au US Document Creation Date To 37 240 1=1 nvl2(pra.po_release_id,pra.created_by,pha.created_by)=xxen_util.user_id(:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 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 Document créé par US Document Created By 38 250 1=1 nvl(pha.cancel_flag,'N')='N' and nvl(pla.cancel_flag,'N')='N' and nvl(plla.cancel_flag,'N')='N' and nvl(pra.cancel_flag,'N')='N' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual nvl2(:$flex$.po_number,null,'Y') F Exclure Annulé US Exclude Cancelled 39 260 1=1 nvl(pha.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(plla.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') and nvl(pra.closed_code,'x') not in ('CLOSED','FINALLY CLOSED') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where nvl(:$flex$.Document_Closure_Status,'?')<>xxen_util.meaning('CLOSED','DOCUMENT STATE',201) and :$flex$.po_number is null and :$flex$.wip_job is null and :$flex$.project is null and :$flex$.need_by_date_from is null and :$flex$.need_by_date_to is null and :$flex$.receipt_date_from is null and :$flex$.receipt_date_to is null F Lignes ouvertes/Expéditions uniquement US Open Lines/Shipments only 40 270 3=3 plla.promised_date>=:promised_date_from Date US Promised Date From 41 4=4 1=2 US Promised Date From 42 280 3=3 plla.promised_date<:promised_date_to+1 Date last_day(:$flex$.promised_date_from) US Promised Date To 43 4=4 1=2 US Promised Date To 44 290 3=3 plla.need_by_date>=:need_by_date_from Date US Need By Date From 45 4=4 1=2 US Need By Date From 46 300 3=3 plla.need_by_date<:need_by_date_to+1 Date last_day(:$flex$.need_by_date_from) US Need By Date To 47 4=4 1=2 US Need By Date To 48 310 3=3 rt.transaction_date>=:receipt_date_from Date F Date de réception du US Receipt Date From 49 4=4 1=2 US Receipt Date From 50 320 3=3 rt.transaction_date<:receipt_date_to+1 Date last_day(:$flex$.receipt_date_from) F Date de réception au US Receipt Date To 51 4=4 1=2 US Receipt Date To 52 325 1=1 nvl(plla.price_override,pla.unit_price)>=:unit_price_from Number US PO Unit Price From 53 326 1=1 nvl(plla.price_override,pla.unit_price)<=:unit_price_to Number US PO Unit Price To 54 330 :p_show_distributions LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Show Distributions 55 &lp_shipment_line_join plla.line_location_id=rsl.po_line_location_id(+) and N US Show Distributions 56 &lp_shipment_line_join pda.line_location_id=rsl.po_line_location_id(+) and pda.po_distribution_id=nvl(rsl.po_distribution_id(+),pda.po_distribution_id) and Y US Show Distributions 57 340 &dff_columns2 select xxen_util.dff_columns(p_table_name=>'po_headers_all',p_column_name_prefix=>'PO Hdr: ',p_prefix=>'x.',p_display_mode=>:dff_display)|| xxen_util.dff_columns(p_table_name=>'po_lines_all',p_column_name_prefix=>'PO Lns: ',p_row_id=>'row_id',p_prefix=>'x.',p_display_mode=>:dff_display)|| xxen_util.dff_columns(p_table_name=>'po_line_locations_all',p_column_name_prefix=>'PO Loc: ',p_prefix=>'x.',p_display_mode=>:dff_display)|| case when :p_show_distributions='Y' then xxen_util.dff_columns(p_table_name=>'po_distributions_all',p_column_name_prefix=>'PO Dist: ',p_prefix=>'x.',p_display_mode=>:dff_display) end sql_text from dual LOV Blitz Report DFF Display 53B31EFFC6B85470E0630100007F501D 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 DFF Display 58 &dff_columns select xxen_util.dff_columns(p_table_name=>'po_headers_all',p_column_name_prefix=>'PO Hdr: ',p_display_mode=>:dff_display)|| xxen_util.dff_columns(p_table_name=>'po_lines_all',p_column_name_prefix=>'PO Lns: ',p_row_id=>'row_id',p_display_mode=>:dff_display)|| xxen_util.dff_columns(p_table_name=>'po_line_locations_all',p_column_name_prefix=>'PO Loc: ',p_display_mode=>:dff_display)|| case when :p_show_distributions='Y' then xxen_util.dff_columns(p_table_name=>'po_distributions_all',p_column_name_prefix=>'PO Dist: ',p_display_mode=>:dff_display) end sql_text from dual US DFF Display 59 350 &attachment_columns fad.seq_num po_line_attch_sequence, fdcv.user_name po_line_attch_category, fdt.title po_line_attch_title, fdd.user_name po_line_attch_data_type, decode(fd.datatype_id,5,fd.url,nvl(fl.file_name,fd.file_name)) po_line_attch_name, decode(fd.datatype_id, 5,'HYPERLINK("'||fd.url||'","'||fd.url||'")', nvl2(fd.media_id,'HYPERLINK("'||fnd_gfm.construct_download_url(fnd_web_config.gfm_agent,fd.media_id)||'","'||nvl(fl.file_name,fd.file_name)||'")',null) ) po_line_attch_url, decode(fd.datatype_id,1,to_clob(fdst.short_text),2,fdlt.long_text) po_line_attch_text, dbms_lob.substr(decode(fd.datatype_id,1,to_clob(fdst.short_text),2,fdlt.long_text),4000,1) po_line_attch_short_text, LOV Oracle Yes_No 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 US Show Attachment Details 60 &fad_document_id null seq_num, null document_id, N US Show Attachment Details 61 &fad_document_id fad.seq_num, fad.document_id, Y US Show Attachment Details 62 &show_attachments Y Y US Show Attachment Details 780E07B0604D59667BF5118B4AAD5E53 Default Y SYSADMIN 72 ACCOUNTING_DATE 119 ACCRUAL_ACCOUNT 43 AMOUNT 77 AMOUNT_PAID 61 APPROVED_DATE 101 ASN_LINE_FLAG 40 BREAK_PRICE 41 BREAK_PRICE_DISCOUNT 14 BUYER 134 CGST Amount 137 CGST Rate 118 CHARGE_ACCOUNT 11 CLOSED_DATE 57 CONTACT_EMAIL 55 CONTACT_NAME 56 CONTACT_PHONE 44 CURRENCY 28 Class 31 Commodity 140 Custom Amount 68 DELIVERY_DELAY 67 DELIVERY_TIME 15 DESCRIPTION 58 DESTINATION_TYPE 37 DISTRIBUTION_NUM 6 116 DOCUMENT_AMOUNT 114 DOCUMENT_AMOUNT_LIMIT 5 DOCUMENT_CLOSED_STATUS 7 DOCUMENT_CREATED_BY 6 DOCUMENT_CREATION_DATE 117 DOCUMENT_MATCHED_AMOUNT 115 DOCUMENT_MIN_RELEASE_AMOUNT 3 DOCUMENT_NUMBER 112 DOCUMENT_REVISED_DATE 4 DOCUMENT_REVISION Y 113 DOCUMENT_TOTAL_AMOUNT 2 DOCUMENT_TYPE 47 EXCHANGE_RATE 46 EXCHANGE_RATE_DATE 45 EXCHANGE_RATE_TYPE 34 FROZEN_COST 27 Family 92 GRNI_AMOUNT 91 GRNI_QUANTITY 132 GST PAN No 131 GST Registration No 133 GST TAN No 103 HEADER_NOTE_TO_RECEIVER 143 HSN SAC Code 136 IGST Amount 139 IGST Rate 69 INVOICE 76 INVOICE_AMOUNT 71 INVOICE_DATE 70 INVOICE_LINE 75 INVOICE_LINE_AMOUNT 74 INVOICE_STATUS 24 ITEM -25.0026 ITEM_CATEGORY 25 ITEM_DESCRIPTION 120 ITEM_EXPENSE_ACCOUNT 121 ITEM_EXPENSE_ACCOUNT_DESC 26 ITEM_TYPE 29 Inv.Items Description 30 Item Category 51 LAST_ACCEPT_DATE 129 LINE_LOCATION_ID 104 LINE_NOTE_TO_RECEIVER 20 LINE_NUM 4 21 LINE_TYPE 79 LOCATION_CODE 63 MATCH_APPROVAL_LEVEL 64 MATCH_OPTION 50 NEED_BY 102 NOTE_TO_VENDOR 1 OPERATING_UNIT 1 53 ORIGINAL_PROMISE 81 PACKING_SLIP 16 PAY_ON 35 PENDING_COST 73 PERIOD_NAME -120.0122 PO Lns: Attribute 13 -120.0121 PO Lns: DFF Context -120.0123 PO Lns: Order Sequence 122 PO_CREATED_BY 123 PO_CREATION_DATE 126 PO_HEADER_ID 128 PO_LINE_ID 8 PO_NUMBER 2 127 PO_RELEASE_ID 95 PO_UNIT_PRICE 38 PRICE 39 PRICE_BREAK_QUANTITY 93 PRIMARY_QUANTITY 94 PRIMARY_UNIT_OF_MEASURE 22 PROJECT 52 PROMISED 32 Purchasing Description 42 QUANTITY 90 QUANTITY_BILLED 86 QUANTITY_CANCELLED 88 QUANTITY_DELIVERED 89 QUANTITY_DUE 85 QUANTITY_ORDERED 87 QUANTITY_RECEIVED 98 QUANTITY_SHIPPED 130 RCV_TRANSACTION_ID 82 RECEIPT 65 RECEIPT_DATE 83 RECEIPT_LINE_NUMBER 84 RECEIPT_QUANTITY 66 RECEIPT_TIME 78 RECEIVER 80 RECEIVING_ORGANIZATION 96 RECEIVING_SHIPMENT_NUMBER 17 RELEASE -3 124 RELEASE_CREATED_BY 125 RELEASE_CREATION_DATE 18 RELEASE_REVISION 19 RELEASE_STATUS 62 REQUEST_DATE 9 REVISION 135 SGST Amount 138 SGST Rate 100 SHIPMENT_LINE_STATUS 36 SHIPMENT_NUMBER 5 97 SHIPPED_DATE 60 SHIP_TO 59 SHIP_TO_ORGANIZATION 10 STATUS 106 SUPPLIER_ADDRESS1 107 SUPPLIER_ADDRESS2 108 SUPPLIER_ADDRESS3 110 SUPPLIER_CITY 111 SUPPLIER_COUNTRY 54 SUPPLIER_ITEM 12 SUPPLIER_NAME 105 SUPPLIER_NUMBER 13 SUPPLIER_SITE 109 SUPPLIER_ZIP 23 TASK 142 Taxable Value 33 UOM 141 Unclassified Tax Amount 99 VENDOR_ITEM_NUM 48 WIP_JOB 49 WIP_JOB_BATCH S Site 4D65F0E8557EA9F046B8631A147A8F71 Document Summary Y Y SYSADMIN 87 ACCOUNTING_DATE 29 ACCRUAL_ACCOUNT 79 ACCRUE_ON_RECEIPT 68 AMOUNT 92 AMOUNT_PAID 75 APPROVED_DATE 116 ASN_LINE_FLAG 65 BREAK_PRICE 66 BREAK_PRICE_DISCOUNT 38 BUYER 138 CGST Amount 142 CGST Rate 28 CHARGE_ACCOUNT 3 CLOSED_DATE Y 71 CONTACT_EMAIL 69 CONTACT_NAME 70 CONTACT_PHONE 12 CURRENCY 53 Class 56 Commodity 145 Custom Amount 83 DELIVERY_DELAY 82 DELIVERY_TIME 40 DESCRIPTION 72 DESTINATION_TYPE 62 DISTRIBUTION_NUM 26 DOCUMENT_AMOUNT 24 DOCUMENT_AMOUNT_LIMIT 8 DOCUMENT_CLOSED_STATUS 10 DOCUMENT_CREATED_BY 9 DOCUMENT_CREATION_DATE 27 DOCUMENT_MATCHED_AMOUNT 25 DOCUMENT_MIN_RELEASE_AMOUNT 6 DOCUMENT_NUMBER 2 11 DOCUMENT_REVISED_DATE 7 DOCUMENT_REVISION 23 DOCUMENT_TOTAL_AMOUNT 5 DOCUMENT_TYPE 15 EXCHANGE_RATE 14 EXCHANGE_RATE_DATE 13 EXCHANGE_RATE_TYPE 59 FROZEN_COST 52 Family 107 GRNI_AMOUNT 106 GRNI_QUANTITY 134 GST PAN No 132 GST Registration No 136 GST TAN No 118 HEADER_NOTE_TO_RECEIVER 148 HSN SAC Code 141 IGST Amount 144 IGST Rate 84 INVOICE 91 INVOICE_AMOUNT 86 INVOICE_DATE 85 INVOICE_LINE 90 INVOICE_LINE_AMOUNT 89 INVOICE_STATUS 49 ITEM -44.0045 ITEM_CATEGORY 50 ITEM_DESCRIPTION 30 ITEM_EXPENSE_ACCOUNT 31 ITEM_EXPENSE_ACCOUNT_DESC 51 ITEM_TYPE 54 Inv.Items Description 55 Item Category 19 LAST_ACCEPT_DATE 135 LINE_LOCATION_ID 119 LINE_NOTE_TO_RECEIVER 45 LINE_NUM 46 LINE_TYPE 94 LOCATION_CODE 77 MATCH_APPROVAL_LEVEL 78 MATCH_OPTION 18 NEED_BY 117 NOTE_TO_VENDOR 1 OPERATING_UNIT 1 21 ORIGINAL_PROMISE 96 PACKING_SLIP 41 PAY_ON 60 PENDING_COST 88 PERIOD_NAME 33 PO Lns: Attribute 13 32 PO Lns: DFF Context 34 PO Lns: Order Sequence 127 PO_CREATED_BY 128 PO_CREATION_DATE 131 PO_HEADER_ID 35 PO_LINE_ATTACHMENT_COUNT 133 PO_LINE_ID 2 PO_NUMBER 137 PO_RELEASE_ID 110 PO_UNIT_PRICE 63 PRICE 64 PRICE_BREAK_QUANTITY 108 PRIMARY_QUANTITY 109 PRIMARY_UNIT_OF_MEASURE 47 PROJECT 20 PROMISED 57 Purchasing Description 67 QUANTITY 105 QUANTITY_BILLED 101 QUANTITY_CANCELLED 103 QUANTITY_DELIVERED 104 QUANTITY_DUE 100 QUANTITY_ORDERED 102 QUANTITY_RECEIVED 113 QUANTITY_SHIPPED 139 RCV_TRANSACTION_ID 97 RECEIPT 80 RECEIPT_DATE 98 RECEIPT_LINE_NUMBER 99 RECEIPT_QUANTITY 81 RECEIPT_TIME 93 RECEIVER 95 RECEIVING_ORGANIZATION 111 RECEIVING_SHIPMENT_NUMBER 42 RELEASE 129 RELEASE_CREATED_BY 130 RELEASE_CREATION_DATE 43 RELEASE_REVISION 44 RELEASE_STATUS 76 REQUEST_DATE 4 REVISION 140 SGST Amount 143 SGST Rate 115 SHIPMENT_LINE_STATUS 61 SHIPMENT_NUMBER 112 SHIPPED_DATE 74 SHIP_TO 73 SHIP_TO_ORGANIZATION 39 STATUS 121 SUPPLIER_ADDRESS1 122 SUPPLIER_ADDRESS2 123 SUPPLIER_ADDRESS3 125 SUPPLIER_CITY 126 SUPPLIER_COUNTRY 22 SUPPLIER_ITEM 36 SUPPLIER_NAME 120 SUPPLIER_NUMBER 37 SUPPLIER_SITE 124 SUPPLIER_ZIP 48 TASK 147 Taxable Value 58 UOM 146 Unclassified Tax Amount 114 VENDOR_ITEM_NUM 16 WIP_JOB 17 WIP_JOB_BATCH S Site 70474015B5A18FC01CDE372CCE4C2B60 PO Receipts by Date Y SYSADMIN 60 ACCOUNTING_DATE 112 ACCRUAL_ACCOUNT 31 AMOUNT 65 AMOUNT_PAID 49 APPROVED_DATE 88 ASN_LINE_FLAG 28 BREAK_PRICE 29 BREAK_PRICE_DISCOUNT 7 BUYER 125 CGST Amount 128 CGST Rate 111 CHARGE_ACCOUNT 3 CLOSED_DATE Y 45 CONTACT_EMAIL 43 CONTACT_NAME 44 CONTACT_PHONE 32 CURRENCY 131 Custom Amount 56 DELIVERY_DELAY 55 DELIVERY_TIME 9 DESCRIPTION 46 DESTINATION_TYPE 25 DISTRIBUTION_NUM 109 DOCUMENT_AMOUNT 107 DOCUMENT_AMOUNT_LIMIT 102 DOCUMENT_CLOSED_STATUS 104 DOCUMENT_CREATED_BY 103 DOCUMENT_CREATION_DATE 110 DOCUMENT_MATCHED_AMOUNT 108 DOCUMENT_MIN_RELEASE_AMOUNT 100 DOCUMENT_NUMBER 105 DOCUMENT_REVISED_DATE 101 DOCUMENT_REVISION 106 DOCUMENT_TOTAL_AMOUNT 99 DOCUMENT_TYPE 35 EXCHANGE_RATE 34 EXCHANGE_RATE_DATE 33 EXCHANGE_RATE_TYPE 22 FROZEN_COST 79 GRNI_AMOUNT 78 GRNI_QUANTITY 123 GST PAN No 122 GST Registration No 124 GST TAN No 90 HEADER_NOTE_TO_RECEIVER 134 HSN SAC Code 127 IGST Amount 130 IGST Rate 57 INVOICE 64 INVOICE_AMOUNT 59 INVOICE_DATE 58 INVOICE_LINE 63 INVOICE_LINE_AMOUNT 62 INVOICE_STATUS 17 ITEM 3 20 ITEM_CATEGORY 18 ITEM_DESCRIPTION 19 ITEM_TYPE 39 LAST_ACCEPT_DATE 119 LINE_LOCATION_ID 91 LINE_NOTE_TO_RECEIVER 13 LINE_NUM 14 LINE_TYPE 67 LOCATION_CODE 51 MATCH_APPROVAL_LEVEL 52 MATCH_OPTION 38 NEED_BY 89 NOTE_TO_VENDOR 1 OPERATING_UNIT 1 41 ORIGINAL_PROMISE 69 PACKING_SLIP 23 PENDING_COST 61 PERIOD_NAME 113 PO_CREATED_BY 114 PO_CREATION_DATE 117 PO_HEADER_ID 118 PO_LINE_ID 2 PO_NUMBER 2 120 PO_RELEASE_ID 82 PO_UNIT_PRICE 26 PRICE 27 PRICE_BREAK_QUANTITY 80 PRIMARY_QUANTITY 81 PRIMARY_UNIT_OF_MEASURE 15 PROJECT 40 PROMISED 30 QUANTITY 77 QUANTITY_BILLED 74 QUANTITY_CANCELLED 76 QUANTITY_DUE 73 QUANTITY_ORDERED 75 QUANTITY_RECEIVED 85 QUANTITY_SHIPPED 121 RCV_TRANSACTION_ID 70 RECEIPT 5 53 RECEIPT_DATE 4 71 RECEIPT_LINE_NUMBER 72 RECEIPT_QUANTITY 54 RECEIPT_TIME 66 RECEIVER 68 RECEIVING_ORGANIZATION 83 RECEIVING_SHIPMENT_NUMBER 10 RELEASE 115 RELEASE_CREATED_BY 116 RELEASE_CREATION_DATE 11 RELEASE_REVISION 12 RELEASE_STATUS 50 REQUEST_DATE 4 REVISION 126 SGST Amount 129 SGST Rate 87 SHIPMENT_LINE_STATUS 24 SHIPMENT_NUMBER 84 SHIPPED_DATE 48 SHIP_TO 47 SHIP_TO_ORGANIZATION 8 STATUS 93 SUPPLIER_ADDRESS1 94 SUPPLIER_ADDRESS2 95 SUPPLIER_ADDRESS3 97 SUPPLIER_CITY 98 SUPPLIER_COUNTRY 42 SUPPLIER_ITEM 5 SUPPLIER_NAME 92 SUPPLIER_NUMBER 6 SUPPLIER_SITE 96 SUPPLIER_ZIP 16 TASK 133 Taxable Value 21 UOM 132 Unclassified Tax Amount 86 VENDOR_ITEM_NUM 36 WIP_JOB 37 WIP_JOB_BATCH ITEM ROW 3 ITEM_DESCRIPTION ROW 4 OPERATING_UNIT FILTER 1 PO_NUMBER ROW 1 RECEIPT ROW 5 RECEIPT_DATE FILTER 2 RECEIPT_QUANTITY VALUE 1 SUM SUPPLIER_NAME ROW 2 UOM ROW 6 S Site 780E07B0604D59667BF5118B4AAD5E53