Use this query \/ script to find the link between a internal requisition and internal sales order.<\/p>\n
Please note that a internal sales order which is created from internal requisition may not always have sales order type as “INTERNAL” or “INTERCOMPANY”. Sales order type can also me “MIXED” or any other custom type so do not filter based on Sales order type.<\/p>\n
Use this query \/ script to find the link between a internal requisition and internal sales order. Please note that a internal sales order which is created from internal requisition may not always have sales order type as “INTERNAL” or “INTERCOMPANY”. Sales order type can also me “MIXED” or any other custom type so do […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[123,124,125],"class_list":["post-4052","post","type-post","status-publish","format-standard","hentry","category-scripts","tag-internal-requisition","tag-internal-sales-order","tag-script"],"yoast_head":"\n
\nSELECT OOH.ORDER_NUMBER SO,
\n PRH.SEGMENT1 REQ
\nFROM OE_ORDER_HEADERS_ALL OOH,
\n PO_REQUISITION_HEADERS_ALL PRH,
\n PO_REQUISITION_LINES_ALL PRL
\nWHERE 1 = 1
\nAND PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
\n--AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
\nAND PRH.REQUISITION_HEADER_ID = OOH.SOURCE_DOCUMENT_ID
\nAND ORDER_NUMBER = '66534' --Sales Order Number
\nAND PRH.SEGMENT1 = '14375' -- Requisition Number
\nAND PRH.TYPE_LOOKUP_CODE = 'INTERNAL'
\n;
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"