1860: DECODE
1861: (NVL(poll.accrue_on_receipt_flag,'N'),
1862: 'N',
1863: (prd.req_line_quantity
1864: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1865: prl.unit_meas_lookup_code,
1866: prl.item_id)
1867: * GREATEST(NVL(pod.quantity_billed,0),
1868: NVL(pod.unencumbered_quantity,0)
1869: )
1870: ),
1871: 'Y',
1872: (prd.req_line_quantity
1873: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1874: prl.unit_meas_lookup_code,
1875: prl.item_id)
1876: * GREATEST(NVL(pod.quantity_delivered,0),
1877: NVL(pod.unencumbered_quantity,0))
1888: DECODE
1889: (NVL(poll.accrue_on_receipt_flag,'N'),
1890: 'N',
1891: (prd.req_line_quantity
1892: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1893: prl.unit_meas_lookup_code,
1894: prl.item_id)
1895: * GREATEST(NVL(pod.quantity_billed,0),
1896: NVL(pod.unencumbered_quantity,0)
1897: )
1898: ),
1899: 'Y',
1900: (prd.req_line_quantity
1901: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1902: prl.unit_meas_lookup_code,
1903: prl.item_id)
1904: * GREATEST (NVL(pod.quantity_delivered,0),
1905: NVL(pod.unencumbered_quantity,0))
1920: DECODE
1921: (NVL(poll.accrue_on_receipt_flag,'N'),
1922: 'N',
1923: (prd.req_line_quantity
1924: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1925: prl.unit_meas_lookup_code,
1926: prl.item_id)
1927: * GREATEST(NVL(pod.quantity_billed,0),
1928: NVL(pod.unencumbered_quantity,0)
1929: )
1930: ),
1931: 'Y',
1932: (prd.req_line_quantity
1933: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1934: prl.unit_meas_lookup_code,
1935: prl.item_id)
1936: * GREATEST(NVL(pod.quantity_delivered,0),
1937: NVL(pod.unencumbered_quantity,0))
1948: DECODE
1949: (NVL(poll.accrue_on_receipt_flag,'N'),
1950: 'N',
1951: (prd.req_line_quantity
1952: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1953: prl.unit_meas_lookup_code,
1954: prl.item_id)
1955: * GREATEST(NVL(pod.quantity_billed,0),
1956: NVL(pod.unencumbered_quantity,0)
1957: )
1958: ),
1959: 'Y',
1960: (prd.req_line_quantity
1961: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1962: prl.unit_meas_lookup_code,
1963: prl.item_id)
1964: * GREATEST(NVL(pod.quantity_delivered,0),
1965: NVL(pod.unencumbered_quantity,0))
2097: DECODE
2098: (NVL(poll.accrue_on_receipt_flag,'N'),
2099: 'N',
2100: (prd.req_line_quantity
2101: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2102: prl.unit_meas_lookup_code,
2103: prl.item_id)
2104: * GREATEST(NVL(pod.quantity_billed,0),
2105: NVL(pod.unencumbered_quantity,0)
2106: )
2107: ),
2108: 'Y',
2109: (prd.req_line_quantity
2110: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2111: prl.unit_meas_lookup_code,
2112: prl.item_id)
2113: * GREATEST(NVL(pod.quantity_delivered,0),
2114: NVL(pod.unencumbered_quantity,0))
2125: DECODE
2126: (NVL(poll.accrue_on_receipt_flag,'N'),
2127: 'N',
2128: (prd.req_line_quantity
2129: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2130: prl.unit_meas_lookup_code,
2131: prl.item_id)
2132: * GREATEST(NVL(pod.quantity_billed,0),
2133: NVL(pod.unencumbered_quantity,0)
2134: )
2135: ),
2136: 'Y',
2137: (prd.req_line_quantity
2138: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2139: prl.unit_meas_lookup_code,
2140: prl.item_id)
2141: * GREATEST(NVL(pod.quantity_delivered,0),
2142: NVL(pod.unencumbered_quantity,0))
2156: DECODE
2157: (NVL(poll.accrue_on_receipt_flag,'N'),
2158: 'N',
2159: (prd.req_line_quantity
2160: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2161: prl.unit_meas_lookup_code,
2162: prl.item_id)
2163: * GREATEST(NVL(pod.quantity_billed,0),
2164: NVL(pod.unencumbered_quantity,0)
2165: )
2166: ),
2167: 'Y',
2168: (prd.req_line_quantity
2169: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2170: prl.unit_meas_lookup_code,
2171: prl.item_id)
2172: * GREATEST(NVL(pod.quantity_delivered,0),
2173: NVL(pod.unencumbered_quantity,0))
2184: DECODE
2185: (NVL(poll.accrue_on_receipt_flag,'N'),
2186: 'N',
2187: (prd.req_line_quantity
2188: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2189: prl.unit_meas_lookup_code,
2190: prl.item_id)
2191: * GREATEST(NVL(pod.quantity_billed,0),
2192: NVL(pod.unencumbered_quantity,0)
2193: )
2194: ),
2195: 'Y',
2196: (prd.req_line_quantity
2197: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2198: prl.unit_meas_lookup_code,
2199: prl.item_id)
2200: * GREATEST(NVL(pod.quantity_delivered,0),
2201: NVL(pod.unencumbered_quantity,0))
2334: DECODE
2335: (NVL(poll.accrue_on_receipt_flag,'N'),
2336: 'N',
2337: (prd.req_line_quantity
2338: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2339: prl.unit_meas_lookup_code,
2340: prl.item_id)
2341: * GREATEST(NVL(pod.quantity_billed,0),
2342: NVL(pod.quantity_delivered,0)
2343: )
2344: ),
2345: 'Y',
2346: (prd.req_line_quantity
2347: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2348: prl.unit_meas_lookup_code,
2349: prl.item_id)
2350: * NVL(pod.quantity_delivered,0)
2351: )
2361: DECODE
2362: (NVL(poll.accrue_on_receipt_flag,'N'),
2363: 'N',
2364: (prd.req_line_quantity
2365: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2366: prl.unit_meas_lookup_code,
2367: prl.item_id)
2368: * GREATEST(NVL(pod.quantity_billed,0),
2369: NVL(pod.quantity_delivered,0)
2370: )
2371: ),
2372: 'Y',
2373: (prd.req_line_quantity
2374: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2375: prl.unit_meas_lookup_code,
2376: prl.item_id)
2377: * NVL(pod.quantity_delivered,0)
2378: )
2391: DECODE
2392: (NVL(poll.accrue_on_receipt_flag,'N'),
2393: 'N',
2394: (prd.req_line_quantity
2395: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2396: prl.unit_meas_lookup_code,
2397: prl.item_id)
2398: * GREATEST(NVL(pod.quantity_billed,0),
2399: NVL(pod.quantity_delivered,0)
2400: )
2401: ),
2402: 'Y',
2403: (prd.req_line_quantity
2404: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2405: prl.unit_meas_lookup_code,
2406: prl.item_id)
2407: * NVL(pod.quantity_delivered,0)
2408: )
2418: DECODE
2419: (NVL(poll.accrue_on_receipt_flag,'N'),
2420: 'N',
2421: (prd.req_line_quantity
2422: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2423: prl.unit_meas_lookup_code,
2424: prl.item_id)
2425: * GREATEST(NVL(pod.quantity_billed,0),
2426: NVL(pod.quantity_delivered,0)
2427: )
2428: ),
2429: 'Y',
2430: (prd.req_line_quantity
2431: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2432: prl.unit_meas_lookup_code,
2433: prl.item_id)
2434: * NVL(pod.quantity_delivered,0)
2435: )
2556: DECODE
2557: (NVL(poll.accrue_on_receipt_flag,'N'),
2558: 'N',
2559: (prd.req_line_quantity
2560: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2561: prl.unit_meas_lookup_code,
2562: prl.item_id)
2563: * GREATEST(NVL(pod.quantity_billed,0),
2564: NVL(pod.quantity_delivered,0)
2565: )
2566: ),
2567: 'Y',
2568: (prd.req_line_quantity
2569: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2570: prl.unit_meas_lookup_code,
2571: prl.item_id)
2572: * NVL(pod.quantity_delivered,0)
2573: )
2583: DECODE
2584: (NVL(poll.accrue_on_receipt_flag,'N'),
2585: 'N',
2586: (prd.req_line_quantity
2587: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2588: prl.unit_meas_lookup_code,
2589: prl.item_id)
2590: * GREATEST(NVL(pod.quantity_billed,0),
2591: NVL(pod.quantity_delivered,0)
2592: )
2593: ),
2594: 'Y',
2595: (prd.req_line_quantity
2596: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2597: prl.unit_meas_lookup_code,
2598: prl.item_id)
2599: * NVL(pod.quantity_delivered,0)
2600: )
2613: DECODE
2614: (NVL(poll.accrue_on_receipt_flag,'N'),
2615: 'N',
2616: (prd.req_line_quantity
2617: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2618: prl.unit_meas_lookup_code,
2619: prl.item_id)
2620: * GREATEST(NVL(pod.quantity_billed,0),
2621: NVL(pod.quantity_delivered,0)
2622: )
2623: ),
2624: 'Y',
2625: (prd.req_line_quantity
2626: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2627: prl.unit_meas_lookup_code,
2628: prl.item_id)
2629: * NVL(pod.quantity_delivered,0)
2630: )
2640: DECODE
2641: (NVL(poll.accrue_on_receipt_flag,'N'),
2642: 'N',
2643: (prd.req_line_quantity
2644: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2645: prl.unit_meas_lookup_code,
2646: prl.item_id)
2647: * GREATEST(NVL(pod.quantity_billed,0),
2648: NVL(pod.quantity_delivered,0)
2649: )
2650: ),
2651: 'Y',
2652: (prd.req_line_quantity
2653: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2654: prl.unit_meas_lookup_code,
2655: prl.item_id)
2656: * NVL(pod.quantity_delivered,0)
2657: )