ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFE13869E053B46B63588994 SELECT 1 temp, ORG.NAME ORGANISATION , WHSE.WHSE_CODE WHSE_CODE, ITM.ITEM_NO ITEM_NO, DTL.SCHEDULE_SHIP_DATE SHIP_DATE, HDR.ORDER_NUMBER ORDER_NO, DTL.SHIPMENT_NUMBER, DTL.LINE_NUMBER, dtl.line_id, CUST.CUSTOMER_NAME, dtl.order_quantity_uom UOM, DTL.ORDERED_QUANTITY, (-1 * PND.TRANS_QTY) UNALLOCATED_INVENTORY, PND.ITEM_ID, PND.QC_GRADE, GML_GMLUNALC_XMLP_PKG.cf_line_numberformula(DTL.LINE_NUMBER, DTL.SHIPMENT_NUMBER) CF_line_number, GML_GMLUNALC_XMLP_PKG.cf_1formula(PND.ITEM_ID, WHSE.WHSE_CODE, PND.QC_GRADE, dtl.order_quantity_uom) CF_Avail_qty, GML_GMLUNALC_XMLP_PKG.cf_unallocated_inventoryformul(PND.ITEM_ID, dtl.line_id, ( - 1 * PND.TRANS_QTY ), dtl.order_quantity_uom) CF_UNALLOCATED_INVENTORY FROM OE_ORDER_LINES_ALL DTL, OE_ORDER_HEADERS_ALL HDR, RA_CUSTOMERS CUST, IC_TRAN_PND PND, ic_whse_mst whse, IC_ITEM_MST ITM, HR_ALL_ORGANIZATION_UNITS ORG WHERE HDR.ORG_ID = ORG.ORGANIZATION_ID AND DTL.HEADER_ID = HDR.HEADER_ID AND DTL.LINE_ID=PND.LINE_ID AND PND.DOC_TYPE = 'OMSO' AND PND.COMPLETED_IND = 0 AND PND.DELETE_MARK = 0 AND whse.mtl_ORGANIZATION_ID=DTL.SHIP_FROM_ORG_ID AND DTL.SOLD_TO_ORG_ID = CUST.CUSTOMER_ID AND ITM.ITEM_ID=PND.ITEM_ID AND ((ITM.LOT_CTL > 0 AND PND.LOT_ID = 0) OR (ITM.LOCT_CTL > 0 AND WHSE.LOCT_CTL > 0 AND PND.LOCATION = :P_DEFAULT_LOCATION )) AND PND.TRANS_QTY < 0 &PARAM_WHERE_CLAUSE UNION SELECT 1 temp, ORG.NAME ORGANISATION, whse.whse_code WHSE_CODE, ITM.ITEM_NO ITEM_NO, DTL.SCHEDULE_SHIP_DATE SHIP_DATE, HDR.ORDER_NUMBER ORDER_NO, DTL.SHIPMENT_NUMBER, DTL.LINE_NUMBER, dtl.line_id, CUST.CUSTOMER_NAME, dtl.order_quantity_uom UOM, DTL.ORDERED_QUANTITY, (dtl.ordered_quantity) UNALLOCATED_INVENTORY, itm.ITEM_ID, dtl.preferred_grade, GML_GMLUNALC_XMLP_PKG.cf_line_numberformula(DTL.LINE_NUMBER, DTL.SHIPMENT_NUMBER) CF_line_number, GML_GMLUNALC_XMLP_PKG.cf_1formula(itm.ITEM_ID, WHSE.WHSE_CODE, dtl.preferred_grade, dtl.order_quantity_uom) CF_Avail_qty, GML_GMLUNALC_XMLP_PKG.cf_unallocated_inventoryformul(itm.ITEM_ID, dtl.line_id, ( dtl.ordered_quantity ), dtl.order_quantity_uom) CF_UNALLOCATED_INVENTORY FROM OE_ORDER_LINES_ALL DTL, OE_ORDER_HEADERS_ALL HDR, RA_CUSTOMERS CUST, IC_WHSE_MST WHSE, IC_ITEM_MST ITM, HR_ALL_ORGANIZATION_UNITS ORG, mtl_system_items MTL WHERE HDR.ORG_ID = ORG.ORGANIZATION_ID AND DTL.HEADER_ID = HDR.HEADER_ID AND DTL.LINE_ID NOT IN (SELECT PND.LINE_ID FROM IC_TRAN_PND PND WHERE PND.DOC_TYPE = 'OMSO' AND PND.COMPLETED_IND = 0 AND PND.DELETE_MARK = 0 AND PND.TRANS_QTY < 0 ) AND WHSE.MTL_ORGANIZATION_ID = DTL.SHIP_FROM_ORG_ID AND mtl.segment1 = itm.item_no AND mtl.organization_id = dtl.ship_from_org_id AND mtl.inventory_item_id = dtl.inventory_item_id AND DTL.SOLD_TO_ORG_ID = CUST.CUSTOMER_ID AND DTL.FLOW_STATUS_CODE IN ('AWAITING_SHIPPING' , 'BOOKED', 'ENTERED') AND nvl(DTL.SCHEDULE_STATUS_CODE, 'xxx') <> 'SCHEDULED' AND nvl(dtl.line_category_code, 'xxx') <> 'RETURN' AND nvl(dtl.source_type_code, 'xxx') <> 'EXTERNAL' &PARAM_WHERE_CLAUSE ORDER BY temp &p_sort Y GML GMLUNALLOC_XML AR GML تقرير الطلبات غير المخصصة (OPM - OM) Application: الإجراءات التنظيمية للتصنيع التشغيلي Source: تقرير الطلبات غير المخصصة (OPM - OM) (XML) Short Name: GMLUNALLOC_XML DB package: GML_GMLUNALC_XMLP_PKG D GML Aufträge ohne Bestandsreservierung (OPM - OM) Application: Process Manufacturing Logistik Source: Aufträge ohne Bestandsreservierung (OPM - OM) (XML) Short Name: GMLUNALLOC_XML DB package: GML_GMLUNALC_XMLP_PKG F GML Commandes non allouées (OPM - OM) Application: Process Manufacturing Logistics Source: Commandes non allouées (OPM - OM) (XML) Short Name: GMLUNALLOC_XML DB package: GML_GMLUNALC_XMLP_PKG US GML Unallocated Orders Report (OPM - OM) Application: Process Manufacturing Logistics Source: Unallocated Orders Report (OPM - OM) (XML) Short Name: GMLUNALLOC_XML DB package: GML_GMLUNALC_XMLP_PKG ZHS GML 未分配订单报表 (OPM - OM) Application: OPM 采购管理系统 Source: 未分配订单报表 (OPM - OM) (XML) Short Name: GMLUNALLOC_XML DB package: GML_GMLUNALC_XMLP_PKG BI Publisher &p_sort &param_where_clause :cp_orgn_name :cp_sort_1 :cp_sort_2 :cp_sort_3 :cp_sort_4 :cp_user :p_conc_request_id :p_default_location :p_default_orgn :p_default_user :p_from_cust_no :p_from_item_no :p_from_order_no :p_from_shipdate :p_from_whse :p_order_by_clause :p_sort :p_sort_1 :p_sort_2 :p_sort_3 :p_sort_4 :p_to_cust_no :p_to_item_no :p_to_order_no :p_to_shipdate :p_to_whse :param_where_clause