ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0643869E053B46B63588994Y select distinct h.shipment_num SHIP_NUMBER, l.line_num line_no, nvl(mip.packslip_number,0) old_packslip_number, decode(mip.packslip_number,null, fnd_date.date_to_chardate(sysdate,2), fnd_date.date_to_chardate(mip.packslip_date,2)) DOC_DATE, hou.name name, substr(hrloc.address_line_1,1,60) rep_ent_add1, substr(hrloc.address_line_2,1,60) rep_ent_add2, nvl(substr(hrloc.address_line_3,1,60),hrloc.town_or_city || decode(hrloc.town_or_city,'','',' ') || hrloc.postal_code || decode(hrloc.postal_code,'','',' ') || hrloc.country) rep_ent_add3, decode(hrloc.address_line_3,'','',hrloc.town_or_city || decode(hrloc.town_or_city,'','',' ') || hrloc.postal_code || decode(hrloc.town_or_city,'','',' ') || hrloc.country) rep_ent_add4, NULL vat_registration_num, decode(hrl.GLOBAL_ATTRIBUTE_CATEGORY, 'JE.IT.PERWSLOC.LOC' ,hrl.global_attribute1, NULL) fiscal_code, substr(hrl3.description,1,40) shipmaint_wharehouse, substr(hrl3.address_line_1,1,60) shipmaint_address1, substr(hrl3.address_line_2,1,60) shipmaint_address2, nvl(substr(hrl3.address_line_3,1,60),hrl3.town_or_city || decode(hrl3.town_or_city,'','',' ') || hrl3.postal_code || decode(hrl3.postal_code,'','',' ') || hrl3.country) shipmaint_address3, decode(hrl3.address_line_3,'','',hrl3.town_or_city || decode(hrl3.town_or_city,'','',' ') || hrl3.postal_code || decode(hrl3.postal_code,'','',' ') || hrl3.country) shipmaint_address4, substr(hou.name,1,40) shipfrom_wharehouse, substr(hrl.address_line_1,1,60) shipfrom_add1, substr(hrl.address_line_2,1,60) shipfrom_add2, nvl(substr(hrl.address_line_3,1,60),hrl.town_or_city || decode(hrl.town_or_city,'','',' ') || hrl.postal_code || decode(hrl.postal_code,'','',' ') || hrl.country) shipfrom_add3, decode(hrl.address_line_3,'','',hrl.town_or_city || decode(hrl.town_or_city,'','',' ') || hrl.postal_code || decode(hrl.postal_code,'','',' ') || hrl.country) shipfrom_add4, substr(hou2.name,1,40) shipto_wharehouse, substr(hrl2.address_line_1,1,60) shipto_add1, substr(hrl2.address_line_2,1,60) shipto_add2, nvl(substr(hrl2.address_line_3,1,60),hrl2.town_or_city || decode(hrl2.town_or_city,'','',' ') || hrl2.postal_code || decode(hrl3.postal_code,'','',' ') || hrl2.country) shipto_add3, decode(hrl2.address_line_3,'','',hrl2.town_or_city || decode(hrl2.town_or_city,'','',' ') || hrl2.postal_code || decode(hrl2.postal_code,'','',' ') || hrl2.country) shipto_add4, mtt.transaction_type_name reason, h.shipment_header_id ship_header_id, h.shipped_date, substr(l.item_description,1,40) item, mtluom.uom_code UOM, l.quantity_shipped QTY_SHIP, --orgf.description freight_carrier,Commented for bug 18842431 h.num_of_containers num_containers, substr(h.comments,1,40) HEADER_COMMENTS, INV_INVINPSR_XMLP_PKG.pslip_number(nvl ( mip.packslip_number , 0 ), l.line_num,h.shipment_header_id) C_PACKSLIP_NUM, --INV_INVINPSR_XMLP_PKG.ins_pkslip_rec(nvl ( mip.packslip_number , 0 ), l.line_num, :C_PACKSLIP_NUM, h.shipment_header_id) C_INS_PKSLIP_REC INV_INVINPSR_XMLP_PKG.CF_FREIGHT_CODE(l.from_organization_id,h.freight_carrier_code) freight_carrier from rcv_shipment_headers h, mtl_material_transactions mmt, mtl_transaction_types mtt, rcv_shipment_lines l, hr_all_organization_units hou, hr_all_organization_units hou2, hr_locations_all hrl, hr_locations_all hrl2, hr_locations_all hrl3, fnd_territories_vl ft, fnd_territories_vl ft2, fnd_territories_vl ft3, --org_freight orgf, Commented for bug 18842431 mtl_inv_packslips mip, mtl_units_of_measure mtluom, hr_locations_all hrloc where h.shipment_header_id = l.shipment_header_id and h.shipment_num(+) = mmt.shipment_number and l.mmt_transaction_id(+) = mmt.transaction_id and mmt.transaction_type_id = mtt.transaction_type_id and mmt.organization_id = l.from_organization_id and mmt.transaction_action_id = 21 and upper(hrloc.office_site_flag) like 'Y%' and hrl3.location_id(+) = h.ship_to_location_id and hrl3.country = ft3.territory_code(+) and hrloc.location_id = hou.location_id and hou.organization_id = l.from_organization_id and hou2.organization_id = l.to_organization_id and hrl.location_id = hou.location_id and hrl2.location_id = hou2.location_id and hrl.country = ft.territory_code(+) and hrl2.country = ft2.territory_code(+) ---and orgf.freight_code(+) = h.freight_carrier_code Commented for bug 18842431 ---and orgf.organization_id = :P_ISSUING_ORG --add for bug 18072625--Commented for bug 18842431 and mip.shipment_header_id(+) = h.shipment_header_id and mtluom.unit_of_measure(+) = l.unit_of_measure and l.from_organization_id = :P_ISSUING_ORG &C_SHIPNUM_WHERE &C_TRANS_TYPE_WHERE &C_PACKSLIP_WHERE &C_SHIP_VIA_WHERE &C_RECEIVING_ORG_WHERE ORDER BY 1,2 INV INVINPSR_XML AR INV بطاقة تعبئة المخزون (بتنسيق XML) Application: المخازن Source: بطاقة تعبئة المخزون (بتنسيق XML) Short Name: INVINPSR_XML DB package: INV_INVINPSR_XMLP_PKG D INV Packzettel Lager Application: Lager Source: Packzettel Lager (XML) Short Name: INVINPSR_XML DB package: INV_INVINPSR_XMLP_PKG F INV Bordereau d'expédition Inventory Application: Inventory Source: Bordereau d'expédition Inventory (XML) Short Name: INVINPSR_XML DB package: INV_INVINPSR_XMLP_PKG US INV Inventory Packing Slip Application: Inventory Source: Inventory Packing Slip (XML) Short Name: INVINPSR_XML DB package: INV_INVINPSR_XMLP_PKG ZHS INV 库存装箱单 Application: 库存管理系统 Source: 库存装箱单 (XML) Short Name: INVINPSR_XML DB package: INV_INVINPSR_XMLP_PKG BI Publisher &c_packslip_where &c_receiving_org_where &c_ship_via_where &c_shipnum_where &c_trans_type_where :c_message_no_data :p_conc_request_id :p_issuing_org :p_packslip_high :p_packslip_lo :p_print_shipper_details :p_receiving_org_high :p_receiving_org_lo :p_set_of_books_id :p_ship_via_high :p_ship_via_lo :p_shipno_high :p_shipno_lo :p_trans_type_id_high :p_trans_type_id_lo 1 10 :p_issuing_org LOV Oracle INV_SRS_PSLP_ORG Y select organization_id id, organization_name value, null description from org_organization_definitions where inventory_enabled_flag='Y' order by value,description Y US Issuing_Warehouse 2 20 :p_shipno_lo LOV Oracle INV_SRS_PSLP_SHIPNUM Y select a.shipment_num id, a.shipment_num value, null description from rcv_shipment_headers a where a.rowid in (select min (rowid) from rcv_shipment_headers b where a.shipment_num=b.shipment_num) order by a.shipment_num AR أرقام الشحنات من D Von Liefernummer F Numéros d'expédition - De US Shipment Numbers From ZHS 发运编号自 3 90 :p_packslip_high LOV Oracle INV_SRS_PSLP_IPKSLP_NUM Y select packslip_number id, packslip_number value, null description from mtl_inv_packslips order by value,description AR إلى D Bis F A US To ZHS 至 4 50 :p_receiving_org_high LOV Oracle INV_SRS_PSLP_ORG Y select organization_id id, organization_name value, null description from org_organization_definitions where inventory_enabled_flag='Y' order by value,description AR إلى D Bis F A US To ZHS 至 5 70 :p_ship_via_high LOV Oracle INV_SRS_PSLP_SO_FREIGHT Y select freight_code id, freight_code value, description description from org_freight where organization_id=:$flex$.issuing_warehouse order by freight_code AR إلى D Bis F A US To ZHS 至 6 30 :p_shipno_high LOV Oracle INV_SRS_PSLP_SHIPNUM Y select a.shipment_num id, a.shipment_num value, null description from rcv_shipment_headers a where a.rowid in (select min (rowid) from rcv_shipment_headers b where a.shipment_num=b.shipment_num) order by a.shipment_num AR إلى D Bis F A US To ZHS 至 7 110 :p_trans_type_id_high LOV Oracle INV_SRS_PSLP_TRANS_TYPE Y select transaction_type_id id, transaction_type_name value, description description from mtl_transaction_types where transaction_type_id>=100 order by transaction_type_id AR إلى D Bis F A US To ZHS 至 8 40 :p_receiving_org_lo LOV Oracle INV_SRS_PSLP_ORG Y select organization_id id, organization_name value, null description from org_organization_definitions where inventory_enabled_flag='Y' order by value,description AR استلام المستودعات من D Von empfangendes Lager F Entrepôts de réception - De US Receiving Warehouses From ZHS 接收仓库自 9 60 :p_ship_via_lo LOV Oracle INV_SRS_PSLP_SO_FREIGHT Y select freight_code id, freight_code value, description description from org_freight where organization_id=:$flex$.issuing_warehouse order by freight_code AR ناقلات الشحن من D Von Transporteur F Transporteurs - De US Freight Carriers From ZHS 承运人自 10 80 :p_packslip_lo LOV Oracle INV_SRS_PSLP_IPKSLP_NUM Y select packslip_number id, packslip_number value, null description from mtl_inv_packslips order by value,description AR بطاقات التعبئة من D Von Packzettel F Bordereaux d'expédition - De US Packing Slips From ZHS 装箱单自 11 100 :p_trans_type_id_lo LOV Oracle INV_SRS_PSLP_TRANS_TYPE Y select transaction_type_id id, transaction_type_name value, description description from mtl_transaction_types where transaction_type_id>=100 order by transaction_type_id AR الأسباب من D Von Grund F Motifs - De US Reasons From ZHS 原因自 12 120 :p_print_shipper_details 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 SELECT meaning FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'YES_NO' AND LOOKUP_CODE = 'N' Y AR طباعة تفاصيل الشاحن (نعم/لا) D Absender drucken {Ja/Nein} F Imprimer détails expéditeur {Oui/Non} US Print Shipper Details {Yes/No} ZHS 打印发货人详细信息 {是/否}