ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472BB51A9E05362FB09050512 SELECT det.inventory_item_id c_inv_item_id , &p_customer_item_number c_customer_item_number , fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flex', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') c_item_flex , msi.description c_item_description , det.customer_item_id c_customer_item_id , det.source_header_number c_so_number , det.source_line_number c_so_line_number , det.cust_po_number c_po_number , sum ( round(nvl(det.requested_quantity,0),:p_quantity_precision)) c_req_qty , sum (round(nvl(det.requested_quantity2,0), :p_quantity_precision)) c_req_qty2 , det.requested_quantity_uom c_req_qty_uom , det.requested_quantity_uom2 c_req_qty_uom2 , det.src_requested_quantity_uom c_src_req_uom , det.src_requested_quantity_uom2 c_src_req_uom2 , det.requested_quantity_uom2 c_secondary_qty_shipped_uom , det.requested_quantity_uom2 c_secondary_qty_unshipped_uom ,avg( round(nvl(det.src_requested_quantity,0),:p_quantity_precision) )c_src_req_qty ,avg( round(nvl(det.src_requested_quantity2,0),:p_quantity_precision) ) c_src_req_qty2 , sum(round(nvl(det.shipped_quantity,0),:p_quantity_precision) ) c_ship_qty ,sum( round(nvl(det.shipped_quantity2,0),:p_quantity_precision)) c_ship_qty2 ,sum( round(nvl(det.delivered_quantity,0),:p_quantity_precision) ) c_del_qty ,sum( round(nvl(det.src_requested_quantity,0)-nvl(det.shipped_quantity,0)-nvl(det.requested_quantity,0),:p_quantity_precision) )c_back_qty , sum(round(nvl(det.src_requested_quantity2,0)-nvl(det.shipped_quantity2,0)-nvl(det.requested_quantity2,0),:p_quantity_precision) )c_back_qty2 , det.customer_id c_customer_id , det.source_code c_src_code , det.source_header_id c_src_hdr_id , to_char(det.source_header_id) c_src_hdr_chr , det.source_line_id c_src_line_id , det.lot_number c_lot_number , det.preferred_grade c_preferred_grade , det.shipping_instructions c_ship_instructions , det.packing_instructions c_pack_instructions ,det.organization_id c_organization_id ,det.source_header_id attach_order_id, WSH_WSHRDPAK_XMLP_PKG.cf_item_descriptionformula(msi.description, det.inventory_item_id, det.organization_id) CF_Item_description, WSH_WSHRDPAK_XMLP_PKG.cf_item_numformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flex', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), det.inventory_item_id, :C_DEL_ORG_ID) CF_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_cust_item_numformula(det.customer_item_id) CF_CUST_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_requestor_nameformula(det.source_line_id) CF_requestor_name, WSH_WSHRDPAK_XMLP_PKG.cf_unshipped_qtyformula(det.source_line_id) CF_UNSHIPPED_QTY, WSH_WSHRDPAK_XMLP_PKG.cf_cum_qtyformula(:C_DEL_CUSTOMER_ID, det.customer_id, det.source_line_id) CF_CUM_QTY, WSH_WSHRDPAK_XMLP_PKG.CP_internal_sales_order_p CP_internal_sales_order FROM wsh_delivery_details det , wsh_delivery_assignments_v das , mtl_system_items_vl msi ,mtl_customer_items mci WHERE det.delivery_detail_id=das.delivery_detail_id AND det.container_flag='N' AND das.delivery_id is not null AND das.delivery_id=:c_q2_delivery_id AND det.inventory_item_id is not null &p_organizationid_1 AND msi.organization_id=det.organization_id AND msi.inventory_item_id (+) =det.inventory_item_id AND mci.customer_item_id (+)= det.customer_item_id AND EXISTS (select 'EXISTS' from bom_inventory_components bic, bom_bill_of_materials bil where bic.component_item_id = det.inventory_item_id and bic.include_on_ship_docs = 1 and bil.common_bill_sequence_id = bic.bill_sequence_id and ( bil.organization_id = det.organization_id or bil.organization_id = det.org_id) and bic.component_sequence_id = ( select component_sequence_id from oe_order_lines_all where line_id = det.source_line_id) and det.top_model_line_id is not null UNION select 'EXISTS' from dual where det.top_model_line_id is null UNION select 'EXISTS' from dual where msi.auto_created_config_flag = 'Y' and det.top_model_line_id is not null UNION select 'EXISTS' from dual where det.top_model_line_id = det.source_line_id UNION select 'EXISTS' from dual where det.top_model_line_id is not null and det.ato_line_id is not null) group by fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flex', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ,det.inventory_item_id , msi.description ,&p_customer_item_number , det.customer_item_id , det.source_header_number ,det.source_line_number , det.cust_po_number , det.requested_quantity_uom , det.requested_quantity_uom2 , det.src_requested_quantity_uom , det.src_requested_quantity_uom2 , det.customer_id , det.source_code , det.source_header_id , det.source_line_id , det.lot_number , det.preferred_grade , det.shipping_instructions , det.packing_instructions , det.organization_id UNION SELECT det.inventory_item_id c_inv_item_id , NULL c_customer_item_number , NULL c_item_flex , det.item_description c_item_description , det.customer_item_id c_customer_item_id , det.source_header_number c_so_number ,det.source_line_number c_so_line_number , det.cust_po_number c_po_number , sum ( round(nvl(det.requested_quantity,0),:p_quantity_precision)) c_req_qty , sum (round(nvl(det.requested_quantity2,0), :p_quantity_precision)) c_req_qty2 , det.requested_quantity_uom c_req_qty_uom , det.requested_quantity_uom2 c_req_qty_uom2 , det.src_requested_quantity_uom c_src_req_uom , det.src_requested_quantity_uom2 c_src_req_uom2 , det.requested_quantity_uom2 c_secondary_qty_shipped_uom , det.requested_quantity_uom2 c_secondary_qty_unshipped_uom ,avg( round(nvl(det.src_requested_quantity,0),:p_quantity_precision) )c_src_req_qty ,avg( round(nvl(det.src_requested_quantity2,0),:p_quantity_precision) ) c_src_req_qty2 , sum(round(nvl(det.shipped_quantity,0),:p_quantity_precision) ) c_ship_qty ,sum( round(nvl(det.shipped_quantity2,0),:p_quantity_precision)) c_ship_qty2 ,sum( round(nvl(det.delivered_quantity,0),:p_quantity_precision) ) c_del_qty ,sum( round(nvl(det.src_requested_quantity,0)-nvl(det.shipped_quantity,0)-nvl(det.requested_quantity,0),:p_quantity_precision) )c_back_qty , sum(round(nvl(det.src_requested_quantity2,0)-nvl(det.shipped_quantity2,0)-nvl(det.requested_quantity2,0),:p_quantity_precision) )c_back_qty2 , det.customer_id c_customer_id , det.source_code c_src_code , det.source_header_id c_src_hdr_id , to_char(det.source_header_id) c_src_hdr_chr , det.source_line_id c_src_line_id , det.lot_number c_lot_number , det.preferred_grade c_preferred_grade , det.shipping_instructions c_ship_instructions , det.packing_instructions c_pack_instructions ,det.organization_id c_organization_id ,det.source_header_id attach_order_id, WSH_WSHRDPAK_XMLP_PKG.cf_item_descriptionformula(NULL, det.inventory_item_id, det.organization_id) CF_Item_description, WSH_WSHRDPAK_XMLP_PKG.cf_item_numformula(NULL, det.inventory_item_id, :C_DEL_ORG_ID) CF_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_cust_item_numformula(det.customer_item_id) CF_CUST_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_requestor_nameformula(det.source_line_id) CF_requestor_name, WSH_WSHRDPAK_XMLP_PKG.cf_unshipped_qtyformula(det.source_line_id) CF_UNSHIPPED_QTY, WSH_WSHRDPAK_XMLP_PKG.cf_cum_qtyformula(:C_DEL_CUSTOMER_ID, det.customer_id, det.source_line_id) CF_CUM_QTY, WSH_WSHRDPAK_XMLP_PKG.CP_internal_sales_order_p CP_internal_sales_order FROM wsh_delivery_details det , wsh_delivery_assignments_v das WHERE det.delivery_detail_id=das.delivery_detail_id AND det.container_flag='N' AND das.delivery_id is not null AND das.delivery_id=:c_q2_delivery_id &p_organizationid_1 AND det.inventory_item_id is null group by NULL ,det.inventory_item_id , det.item_description , det.customer_item_id , det.source_header_number ,det.source_line_number , det.cust_po_number , det.requested_quantity_uom , det.requested_quantity_uom2 , det.src_requested_quantity_uom , det.src_requested_quantity_uom2 , det.customer_id , det.source_code , det.source_header_id , det.source_line_id , det.lot_number , det.preferred_grade , det.shipping_instructions , det.packing_instructions , det.organization_id ORDER BY 27 ASC,26 ASC,2 ASC,3 ASC,4 ASC WSH WSHRDPAKX_XML US WSH Packing Slip Report PDF Output Imported from BI Publisher Description: Packing Slip Report PDF Output Application: Shipping Execution Source: Packing Slip Report PDF Output (XML) Short Name: WSHRDPAKX_XML DB package: WSH_WSHRDPAK_XMLP_PKG BI Publisher &p_customer_item_number &p_organizationid_1 :c_del_customer_id :c_del_org_id :c_q2_delivery_id :cp_bill_address_line_1 :cp_bill_address_line_2 :cp_bill_address_line_3 :cp_bill_address_line_4 :cp_bill_country :cp_bill_postal_code :cp_bill_region :cp_bill_to_contact_id :cp_bill_town_or_city :cp_draft_or_final :cp_internal_sales_order :cp_print_date :cp_rlm_print_cum_data :cp_ship_to_contact_id :cp_source_code :cp_warehouse_name :p_conc_request_id :p_customer_item_number :p_delivery_date_high :p_delivery_date_low :p_delivery_id :p_display_unshipped :p_doc_type :p_entity_name_oed :p_entity_name_oeh :p_entity_name_wdd :p_entity_name_wnd :p_freight_code :p_func_name :p_item_display :p_item_flex :p_order_by :p_organization_id :p_organizationid :p_organizationid_1 :p_print_cust_item :p_print_mode :p_quantity_precision :p_sort :p_standalone :p_tax_vat_flag 1 -20 :p_quantity_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y US Quantity Precision Quantity Precision 2 10 :p_organization_id LOV Oracle WSH_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions order by organization_code select organization_code from org_organization_definitions where organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y US Warehouse Warehouse 3 20 :p_delivery_id LOV Oracle WSH_MGD_SRS_PACK_DELIVERIES Y select delivery_id id, delivery_name value, null description from wsh_pack_slip_v where organization_id=:$flex$.wsh_srs_organizations and exists (select 1 from wsh_delivery_assignments wda where wda.delivery_id=wsh_pack_slip_v.delivery_id) order by delivery_name Y US Delivery Name Delivery Name 4 30 :p_print_cust_item 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 US Print Customer Item Print Customer Item 5 40 :p_item_display LOV Oracle WSH_MGD_ITEM_DISPLAY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='ITEM_DISPLAY' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'ITEM_DISPLAY' and lookup_code = 'D' Y US Item Display Item Display Option 6 50 :p_print_mode LOV Oracle WSH_MGD_PACK_MODE Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='PACK_MODE' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'PACK_MODE' and lookup_code = 'DRAFT' Y US Print Mode Print Mode 7 60 :p_sort LOV Oracle WSH_MGD_PACK_SORT Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='PACK_SORT' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'PACK_SORT' and lookup_code = 'INV' Y US Sort by Sort Option 8 70 :p_delivery_date_low Date US Delivery Date (Low) Delivery Date (Low) 9 80 :p_delivery_date_high Date US Delivery Date (High) Delivery Date (High) 10 90 :p_display_unshipped 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 = 'Y' Y US Display Unshipped Items Display Unshipped Items :$flex$.wsh_srs_organizations Warehouse Delivery Name