31:
32: /* SELECT DISTINCT poh.segment1
33: , poh.po_header_id
34: , poh.type_lookup_code
35: , MO_GLOBAL.get_ou_name(poh.org_id) --
37: , poh.vendor_id
38: , poh.vendor_site_id
39: , 'Vendor'
79:
80: SELECT DISTINCT poh.Segment1 ,
81: poh.po_Header_Id ,
82: poh.Type_LookUp_Code ,
83: MO_GLOBAL.get_ou_name(poh.org_id) ,--
85: poh.Vendor_Id ,
86: poh.Vendor_Site_Id ,
87: 'Vendor' ,
148:
149: SELECT DISTINCT poh.segment1
150: , poh.po_header_id
151: , poh.type_lookup_code
152: , MO_GLOBAL.get_ou_name(poh.org_id) --
154: , poh.vendor_id
155: , poh.vendor_site_id
156: , 'Vendor'
190:
191: SELECT DISTINCT poh.segment1
192: , poh.po_header_id
193: , poh.type_lookup_code
194: , MO_GLOBAL.get_ou_name(poh.org_id) --
196: , poh.vendor_id
197: , poh.vendor_site_id
198: , 'Vendor'
238: */
239: SELECT DISTINCT poh.segment1 ,
240: poh.po_header_id ,
241: poh.type_lookup_code ,
242: MO_GLOBAL.get_ou_name(poh.org_id) ,
243: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) ,
244: poh.vendor_id ,
245: poh.vendor_site_id ,
246: 'Vendor' ,
750: OPEN x_requisition_num_lov FOR
751:
752: SELECT DISTINCT
753: prh.segment1,
754: MO_GLOBAL.get_ou_name(prh.org_id), --
756: prh.description,
757: NULL,
758: to_char(prh.org_id) --
790: OPEN x_requisition_num_lov FOR
791:
792: SELECT DISTINCT
793: prh.segment1,
794: MO_GLOBAL.get_ou_name(prh.org_id), --
796: prh.description,
797: null,
798: to_char(prh.org_id) --
818: --'NOT INSPECTED'
819: OPEN x_requisition_num_lov FOR
820: SELECT DISTINCT
821: prh.segment1,
822: MO_GLOBAL.get_ou_name(prh.org_id), --
824: prh.description,
825: null,
826: to_char(prh.org_id) --
1499: meaning FIELD0 ,
1500: poh.segment1 FIELD1 ,
1501: to_char(poh.po_header_id) FIELD2 ,
1502: poh.type_lookup_code FIELD3 ,
1503: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4, --
1505: to_char(poh.vendor_id) FIELD6 ,
1506: to_char(poh.vendor_site_id) FIELD7 ,
1507: 'Vendor' FIELD8 ,
1562: meaning FIELD0 ,
1563: poh.segment1 FIELD1 ,
1564: to_char(poh.po_header_id) FIELD2 ,
1565: poh.type_lookup_code FIELD3 ,
1566: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4, --
1568: to_char(poh.vendor_id) FIELD6 ,
1569: to_char(poh.vendor_site_id) FIELD7 ,
1570: 'Vendor' FIELD8 ,
1651: meaning FIELD0 ,
1652: poh.segment1 FIELD1 ,
1653: to_char(poh.po_header_id) FIELD2 ,
1654: poh.type_lookup_code FIELD3 ,
1655: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4, --
1657: to_char(poh.vendor_id) FIELD6 ,
1658: to_char(poh.vendor_site_id) FIELD7 ,
1659: 'Vendor' FIELD8 ,
1709: meaning FIELD0 ,
1710: poh.segment1 FIELD1 ,
1711: to_char(poh.po_header_id) FIELD2 ,
1712: poh.type_lookup_code FIELD3 ,
1713: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4, --
1715: to_char(poh.vendor_id) FIELD6 ,
1716: to_char(poh.vendor_site_id) FIELD7 ,
1717: 'Vendor' FIELD8 ,
1771: meaning FIELD0 ,
1772: poh.segment1 FIELD1 ,
1773: to_char(poh.po_header_id) FIELD2 ,
1774: poh.type_lookup_code FIELD3 ,
1775: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4, --
1777: to_char(poh.vendor_id) FIELD5 ,
1778: to_char(poh.vendor_site_id) FIELD7 ,
1779: 'Vendor' FIELD8 ,
1838: meaning FIELD0 ,
1839: poh.segment1 FIELD1 ,
1840: to_char(poh.po_header_id) FIELD2 ,
1841: poh.type_lookup_code FIELD3 ,
1842: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4 , --
1844: to_char(poh.vendor_id) FIELD6 ,
1845: to_char(poh.vendor_site_id) FIELD7 ,
1846: 'Vendor' FIELD8 ,
1905: meaning FIELD0 ,
1906: poh.segment1 FIELD1 ,
1907: to_char(poh.po_header_id) FIELD2 ,
1908: poh.type_lookup_code FIELD3 ,
1909: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4 , --
1911: to_char(poh.vendor_id) FIELD6 ,
1912: to_char(poh.vendor_site_id) FIELD7 ,
1913: 'Vendor' FIELD8 ,
2336: meaning FIELD0,
2337: prh.segment1 FIELD1,
2338: to_char(prh.requisition_header_id) FIELD2,
2339: prh.description FIELD3,
2340: MO_GLOBAL.get_ou_name (prh.org_id) FIELD4 , --
2342: NULL FIELD6,
2343: NULL FIELD7,
2344: NULL FIELD8,
2383: meaning FIELD0 ,
2384: poh.segment1 FIELD1 ,
2385: to_char(poh.po_header_id) FIELD2 ,
2386: poh.type_lookup_code FIELD3 ,
2387: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4 , --
2389: to_char(poh.vendor_id) FIELD6 ,
2390: to_char(poh.vendor_site_id) FIELD7 ,
2391: 'Vendor' FIELD8 ,
2447: meaning FIELD0 ,
2448: poh.segment1 FIELD1 ,
2449: to_char(poh.po_header_id) FIELD2 ,
2450: poh.type_lookup_code FIELD3 ,
2451: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4, --
2453: to_char(poh.vendor_id) FIELD6 ,
2454: to_char(poh.vendor_site_id) FIELD7 ,
2455: 'Vendor' FIELD8 ,
2528: meaning FIELD0 ,
2529: poh.segment1 FIELD1 ,
2530: to_char(poh.po_header_id) FIELD2 ,
2531: poh.type_lookup_code FIELD3 ,
2532: MO_GLOBAL.get_ou_name(poh.org_id) FIELD4 , --
2534: to_char(poh.vendor_id) FIELD6 ,
2535: to_char(poh.vendor_site_id) FIELD7 ,
2536: 'Vendor' FIELD8 ,
2810: meaning FIELD0,
2811: prh.segment1 FIELD1,
2812: to_char(prh.requisition_header_id) FIELD2,
2813: prh.description FIELD3,
2814: MO_GLOBAL.get_ou_name (prh.org_id) FIELD4 , --
2816: NULL FIELD6,
2817: NULL FIELD7,
2818: NULL FIELD8,