[Home] [Help]
49: /* SELECT DISTINCT poh.segment1
50: , poh.po_header_id
51: , poh.type_lookup_code
52: , MO_GLOBAL.get_ou_name(poh.org_id) --
53: , PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID)
54: , poh.vendor_id
55: , poh.vendor_site_id
56: , 'Vendor'
57: , poh.note_to_receiver
98: poh.po_Header_Id ,
99: poh.Type_LookUp_Code ,
100: wms_deploy.get_po_client_name(poh.po_header_id) ,--LSP
101: MO_GLOBAL.get_ou_name(poh.org_id) ,--
102: po_Vendors_sv2.Get_vendor_name_func(poh.Vendor_Id),
103: poh.Vendor_Id ,
104: poh.Vendor_Site_Id ,
105: 'Vendor' ,
106: poh.Note_To_Receiver ,
168: , poh.po_header_id
169: , poh.type_lookup_code
170: , wms_deploy.get_po_client_name(poh.po_header_id) --LSP
171: , MO_GLOBAL.get_ou_name(poh.org_id) --
172: , PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID)
173: , poh.vendor_id
174: , poh.vendor_site_id
175: , 'Vendor'
176: , poh.note_to_receiver
211: , poh.po_header_id
212: , poh.type_lookup_code
213: , wms_deploy.get_po_client_name(poh.po_header_id) --LSP
214: , MO_GLOBAL.get_ou_name(poh.org_id) --
215: , PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID)
216: , poh.vendor_id
217: , poh.vendor_site_id
218: , 'Vendor'
219: , poh.note_to_receiver
260: poh.po_header_id ,
261: poh.type_lookup_code ,
262: wms_deploy.get_po_client_name(poh.po_header_id) ,--LSP
263: MO_GLOBAL.get_ou_name(poh.org_id) ,
264: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) ,
265: poh.vendor_id ,
266: poh.vendor_site_id ,
267: 'Vendor' ,
268: poh.note_to_receiver ,
1535: to_char(poh.po_header_id) FIELD2 ,
1536: poh.type_lookup_code FIELD3 ,
1537: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP
1538: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1539: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1540: to_char(poh.vendor_id) FIELD7 ,
1541: to_char(poh.vendor_site_id) FIELD8 ,
1542: 'Vendor' FIELD9 ,
1543: poh.note_to_receiver FIELD10 ,
1599: to_char(poh.po_header_id) FIELD2 ,
1600: poh.type_lookup_code FIELD3 ,
1601: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP
1602: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1603: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1604: to_char(poh.vendor_id) FIELD7 ,
1605: to_char(poh.vendor_site_id) FIELD8 ,
1606: 'Vendor' FIELD9 ,
1607: poh.note_to_receiver FIELD10 ,
1689: to_char(poh.po_header_id) FIELD2 ,
1690: poh.type_lookup_code FIELD3 ,
1691: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1692: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1693: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1694: to_char(poh.vendor_id) FIELD7 ,
1695: to_char(poh.vendor_site_id) FIELD8 ,
1696: 'Vendor' FIELD9 ,
1697: poh.note_to_receiver FIELD10 ,
1748: to_char(poh.po_header_id) FIELD2 ,
1749: poh.type_lookup_code FIELD3 ,
1750: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP
1751: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1752: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1753: to_char(poh.vendor_id) FIELD7 ,
1754: to_char(poh.vendor_site_id) FIELD8 ,
1755: 'Vendor' FIELD9 ,
1756: poh.note_to_receiver FIELD10 ,
1811: to_char(poh.po_header_id) FIELD2 ,
1812: poh.type_lookup_code FIELD3 ,
1813: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1814: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1815: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1816: to_char(poh.vendor_id) FIELD7 ,
1817: to_char(poh.vendor_site_id) FIELD8 ,
1818: 'Vendor' FIELD9 ,
1819: poh.note_to_receiver FIELD10 ,
1879: to_char(poh.po_header_id) FIELD2 ,
1880: poh.type_lookup_code FIELD3 ,
1881: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1882: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
1883: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1884: to_char(poh.vendor_id) FIELD7 ,
1885: to_char(poh.vendor_site_id) FIELD8 ,
1886: 'Vendor' FIELD9 ,
1887: poh.note_to_receiver FIELD10 ,
1947: to_char(poh.po_header_id) FIELD2 ,
1948: poh.type_lookup_code FIELD3 ,
1949: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1950: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
1951: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1952: to_char(poh.vendor_id) FIELD7 ,
1953: to_char(poh.vendor_site_id) FIELD8 ,
1954: 'Vendor' FIELD9 ,
1955: poh.note_to_receiver FIELD10 ,
2435: to_char(poh.po_header_id) FIELD2 ,
2436: poh.type_lookup_code FIELD3 ,
2437: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
2438: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
2439: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
2440: to_char(poh.vendor_id) FIELD7 ,
2441: to_char(poh.vendor_site_id) FIELD8 ,
2442: 'Vendor' FIELD9 ,
2443: poh.note_to_receiver FIELD10 ,
2500: to_char(poh.po_header_id) FIELD2 ,
2501: poh.type_lookup_code FIELD3 ,
2502: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
2503: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
2504: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
2505: to_char(poh.vendor_id) FIELD7 ,
2506: to_char(poh.vendor_site_id) FIELD8 ,
2507: 'Vendor' FIELD9 ,
2508: poh.note_to_receiver FIELD10 ,
2582: to_char(poh.po_header_id) FIELD2 ,
2583: poh.type_lookup_code FIELD3 ,
2584: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
2585: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
2586: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
2587: to_char(poh.vendor_id) FIELD7 ,
2588: to_char(poh.vendor_site_id) FIELD8 ,
2589: 'Vendor' FIELD9 ,
2590: poh.note_to_receiver FIELD10 ,