ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0AD3869E053B46B63588994 SELECT j57f4.form_id, j57f4.form_number CHALLAN_NO, hou.name NAME, loc.address_line_1||','||loc.address_line_2||','||loc.address_line_3||','||loc.town_or_city||','|| loc.country ADDRS, pov.vendor_name||','|| povs.address_line1||','|| povs.address_line2||','|| povs.address_line3||','|| povs.city||','|| povs.country VENDOR, msi.description DESCRIPTION, j57f4l.identification IDENTIFICATION, j57f4l.tariff_code TCODE, j57f4l.despatch_qty QUANTITY, j57f4l.item_uom IUOM, j57f4l.item_value ASSES_VALUE, j57f4l.excise_rate ED_RATE, ((j57f4l.despatch_qty * j57f4l.item_value * j57f4l.excise_rate) / 100) DUTY_AMT, j57f4l.process_reqd PROCESS_REQD, j57f4.process_time PROCESS_TIME, j57f4.dr_register REGISTER_NAME, j57f4.dr_reg_slno DR_SLNO, j57f4.dr_reg_entry_date DR_DATE, j57f4.creation_date FRM_DATE , to_char(j57f4.issue_date, 'DD-MON-YYYY HH:MI:SS') ISSUE_DATE, j57f4.print_original , j57f4.print_duplicate, j57f4.vendor_id , j57f4.vendor_site_id , MSI.concatenated_segments ITEM_CODE, j57f4.po_header_id, j57f4.oth_doc_id PO_RELEASE_ID, j57f4.organization_id, j57f4l.wip_entity_id, j57f4l.assembly_id, j57f4.cancel_flag, JA_JAIN57F4_XMLP_PKG.cf_1formula(j57f4.cancel_flag, j57f4.print_original) CF_1_PRINT, JA_JAIN57F4_XMLP_PKG.cf_vendor_site_nameformula(j57f4.vendor_id, j57f4.vendor_site_id) CF_VENDOR_SITE_NAME, JA_JAIN57F4_XMLP_PKG.cf_po_numberformula(j57f4.po_header_id) CF_PO_NUMBER, JA_JAIN57F4_XMLP_PKG.cf_release_numberformula(j57f4.oth_doc_id) CF_RELEASE_NUMBER, JA_JAIN57F4_XMLP_PKG.cf_job_nameformula(j57f4l.wip_entity_id, j57f4.organization_id) CF_JOB_NAME, JA_JAIN57F4_XMLP_PKG.cf_job_start_dateformula(j57f4l.wip_entity_id, j57f4.organization_id) CF_JOB_START_DATE, JA_JAIN57F4_XMLP_PKG.cf_assembly_item_codeformula(j57f4l.assembly_id, j57f4.organization_id) CF_ASSEMBLY_ITEM_CODE FROM JAI_PO_OSP_HDRS j57f4, JAI_PO_OSP_LINES j57f4L, hr_organization_units HOU, hr_locations LOC, po_vendors POV, po_vendor_sites_all POVS, mtl_system_items_kfv MSI WHERE trunc(j57f4.issue_date) <= nvl(:P_TO_DATE,trunc(sysdate)) AND j57f4.organization_id = nvl(:p_organization_id,j57f4.organization_id) AND j57f4.location_id = nvl(:p_location_id,j57f4.location_id) AND j57f4.fin_year = nvl(:p_fin_year,j57f4.fin_year) AND trunc(j57f4.issue_date) >= trunc(nvl(:P_FROM_DATE,trunc(j57f4.issue_date))) AND trunc(j57f4.form_id) >= nvl(:P_FORM_ID_FROM,trunc(j57f4.form_id)) AND trunc(j57f4.form_id) <= nvl(:P_FORM_ID_TO,trunc(j57f4.form_id)) AND upper(j57f4.issue_approved) = 'Y' AND j57f4.vendor_id = nvl(:P_VENDOR_ID,j57f4.vendor_id) AND j57f4l.form_id = j57f4.form_id AND hou.organization_id = j57f4.organization_id AND loc.location_id = j57f4.location_id AND pov.vendor_id = j57f4.vendor_id AND povs.vendor_site_id (+) = j57f4.vendor_site_id AND msi.organization_id = j57f4.organization_id AND msi.inventory_item_id = j57f4l.item_id and ( j57f4.print_original = 'Y' or j57f4.print_duplicate = 'Y' or nvl(j57f4.cancel_flag,'N') = 'Y') ORDER BY msi.description JA JAIN57F4_XML US JA India - Outside Processing Challan - draft Application: Asia/Pacific Localizations Source: India - Outside Processing Challan (XML) - Not Supported: Reserved For Future Use Short Name: JAIN57F4_XML DB package: JA_JAIN57F4_XMLP_PKG ZHS JA 印度 - 外协加工 Challan- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - 外协加工 Challan (XML) - 不支持：已保留供将来使用 Short Name: JAIN57F4_XML DB package: JA_JAIN57F4_XMLP_PKG BI Publisher :p_conc_request_id :p_fin_year :p_form_id_from :p_form_id_to :p_from_date :p_location_id :p_organization_id :p_place :p_to_date :p_vendor_id 1 10 :p_organization_id LOV Oracle ORGANIZATION_NAME_57PR Y select organization_id id, name value, null description from hr_organization_units hou where exists (select 'X' from jai_po_osp_hdrs j57f4 where hou.organization_id=j57f4.organization_id) order by value,description Y US Organization Name ZHS 组织名 2 20 :p_location_id LOV Oracle LOCATION_NAME_57PR Y select location_id id, location_code value, null description from hr_locations loc where exists (select 'X' from jai_po_osp_hdrs j57f4 where j57f4.location_id=loc.location_id and j57f4.organization_id=:$flex$.organization_name_57pr) order by value,description Y US Location Name ZHS 地点名称 3 30 :p_fin_year LOV Oracle JA_IN_57F4_FIN_YEAR Y select a.fin_year id, a.fin_year value, null description from jai_po_osp_hdrs a where a.organization_id=:$flex$.organization_name_57pr and a.location_id=:$flex$.location_name_57pr and rowid in (select min(rowid) from jai_po_osp_hdrs b where b.organization_id=:$flex$.organization_name_57pr and b.location_id=:$flex$.location_name_57pr group by b.fin_year ) order by a.form_number Y US Fin Year ZHS 财政年度 4 40 :p_from_date Date US From Date ZHS 自日期 5 50 :p_to_date Date US Issue Dates To ZHS 发放日期至 6 60 :p_form_id_from LOV Oracle FROM_FORM_ID_57F4 Y select form_id id, form_number value, null description from jai_po_osp_hdrs where upper(issue_approved)='Y' and (upper(print_original)='Y' or upper(print_duplicate)='Y' ) and organization_id=:$flex$.organization_name_57pr and fin_year=:$flex$.ja_in_57f4_fin_year order by form_number US Form Numbers From ZHS 表单编号自 7 70 :p_form_id_to LOV Oracle TO_FORM_ID_57F4 Y select form_id id, form_number value, null description from jai_po_osp_hdrs where upper(issue_approved)='Y' and (upper(print_original)='Y' or upper(print_duplicate)='Y' ) and organization_id=:$flex$.organization_name_57pr and fin_year=:$flex$.ja_in_57f4_fin_year order by form_number US Form Numbers To ZHS 表单编号至 8 80 :p_vendor_id LOV Oracle VENDOR_57F4 Y select vendor_id id, vendor_name value, null description from po_vendors pov where exists (select 'X' from jai_po_osp_hdrs j57f4 where j57f4.vendor_id=pov.vendor_id) order by value,description US Vendor Name ZHS 供应商名称 9 90 :p_place Char US Place ZHS 地点 :$flex$.ja_in_57f4_fin_year Fin Year Form Numbers From :$flex$.ja_in_57f4_fin_year Fin Year Form Numbers To :$flex$.location_name_57pr Location Name Fin Year :$flex$.organization_name_57pr Organization Name Fin Year :$flex$.organization_name_57pr Organization Name Form Numbers From :$flex$.organization_name_57pr Organization Name Form Numbers To :$flex$.organization_name_57pr Organization Name Location Name