DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_UOM_S

Line 1863: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1859: DECODE
1860: (NVL(poll.accrue_on_receipt_flag,'N'),
1861: 'N',
1862: (prd.req_line_quantity
1863: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1864: prl.unit_meas_lookup_code,
1865: prl.item_id)
1866: * GREATEST(NVL(pod.quantity_billed,0),
1867: NVL(pod.unencumbered_quantity,0)

Line 1872: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1868: )
1869: ),
1870: 'Y',
1871: (prd.req_line_quantity
1872: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1873: prl.unit_meas_lookup_code,
1874: prl.item_id)
1875: * GREATEST(NVL(pod.quantity_delivered,0),
1876: NVL(pod.unencumbered_quantity,0))

Line 1891: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1887: DECODE
1888: (NVL(poll.accrue_on_receipt_flag,'N'),
1889: 'N',
1890: (prd.req_line_quantity
1891: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1892: prl.unit_meas_lookup_code,
1893: prl.item_id)
1894: * GREATEST(NVL(pod.quantity_billed,0),
1895: NVL(pod.unencumbered_quantity,0)

Line 1900: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1896: )
1897: ),
1898: 'Y',
1899: (prd.req_line_quantity
1900: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1901: prl.unit_meas_lookup_code,
1902: prl.item_id)
1903: * GREATEST (NVL(pod.quantity_delivered,0),
1904: NVL(pod.unencumbered_quantity,0))

Line 1923: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1919: DECODE
1920: (NVL(poll.accrue_on_receipt_flag,'N'),
1921: 'N',
1922: (prd.req_line_quantity
1923: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1924: prl.unit_meas_lookup_code,
1925: prl.item_id)
1926: * GREATEST(NVL(pod.quantity_billed,0),
1927: NVL(pod.unencumbered_quantity,0)

Line 1932: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1928: )
1929: ),
1930: 'Y',
1931: (prd.req_line_quantity
1932: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1933: prl.unit_meas_lookup_code,
1934: prl.item_id)
1935: * GREATEST(NVL(pod.quantity_delivered,0),
1936: NVL(pod.unencumbered_quantity,0))

Line 1951: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1947: DECODE
1948: (NVL(poll.accrue_on_receipt_flag,'N'),
1949: 'N',
1950: (prd.req_line_quantity
1951: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1952: prl.unit_meas_lookup_code,
1953: prl.item_id)
1954: * GREATEST(NVL(pod.quantity_billed,0),
1955: NVL(pod.unencumbered_quantity,0)

Line 1960: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

1956: )
1957: ),
1958: 'Y',
1959: (prd.req_line_quantity
1960: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
1961: prl.unit_meas_lookup_code,
1962: prl.item_id)
1963: * GREATEST(NVL(pod.quantity_delivered,0),
1964: NVL(pod.unencumbered_quantity,0))

Line 2100: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2096: DECODE
2097: (NVL(poll.accrue_on_receipt_flag,'N'),
2098: 'N',
2099: (prd.req_line_quantity
2100: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2101: prl.unit_meas_lookup_code,
2102: prl.item_id)
2103: * GREATEST(NVL(pod.quantity_billed,0),
2104: NVL(pod.unencumbered_quantity,0)

Line 2109: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2105: )
2106: ),
2107: 'Y',
2108: (prd.req_line_quantity
2109: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2110: prl.unit_meas_lookup_code,
2111: prl.item_id)
2112: * GREATEST(NVL(pod.quantity_delivered,0),
2113: NVL(pod.unencumbered_quantity,0))

Line 2128: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2124: DECODE
2125: (NVL(poll.accrue_on_receipt_flag,'N'),
2126: 'N',
2127: (prd.req_line_quantity
2128: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2129: prl.unit_meas_lookup_code,
2130: prl.item_id)
2131: * GREATEST(NVL(pod.quantity_billed,0),
2132: NVL(pod.unencumbered_quantity,0)

Line 2137: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2133: )
2134: ),
2135: 'Y',
2136: (prd.req_line_quantity
2137: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2138: prl.unit_meas_lookup_code,
2139: prl.item_id)
2140: * GREATEST(NVL(pod.quantity_delivered,0),
2141: NVL(pod.unencumbered_quantity,0))

Line 2159: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2155: DECODE
2156: (NVL(poll.accrue_on_receipt_flag,'N'),
2157: 'N',
2158: (prd.req_line_quantity
2159: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2160: prl.unit_meas_lookup_code,
2161: prl.item_id)
2162: * GREATEST(NVL(pod.quantity_billed,0),
2163: NVL(pod.unencumbered_quantity,0)

Line 2168: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2164: )
2165: ),
2166: 'Y',
2167: (prd.req_line_quantity
2168: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2169: prl.unit_meas_lookup_code,
2170: prl.item_id)
2171: * GREATEST(NVL(pod.quantity_delivered,0),
2172: NVL(pod.unencumbered_quantity,0))

Line 2187: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2183: DECODE
2184: (NVL(poll.accrue_on_receipt_flag,'N'),
2185: 'N',
2186: (prd.req_line_quantity
2187: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2188: prl.unit_meas_lookup_code,
2189: prl.item_id)
2190: * GREATEST(NVL(pod.quantity_billed,0),
2191: NVL(pod.unencumbered_quantity,0)

Line 2196: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2192: )
2193: ),
2194: 'Y',
2195: (prd.req_line_quantity
2196: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2197: prl.unit_meas_lookup_code,
2198: prl.item_id)
2199: * GREATEST(NVL(pod.quantity_delivered,0),
2200: NVL(pod.unencumbered_quantity,0))

Line 2337: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2333: DECODE
2334: (NVL(poll.accrue_on_receipt_flag,'N'),
2335: 'N',
2336: (prd.req_line_quantity
2337: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2338: prl.unit_meas_lookup_code,
2339: prl.item_id)
2340: * GREATEST(NVL(pod.quantity_billed,0),
2341: NVL(pod.quantity_delivered,0)

Line 2346: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2342: )
2343: ),
2344: 'Y',
2345: (prd.req_line_quantity
2346: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2347: prl.unit_meas_lookup_code,
2348: prl.item_id)
2349: * NVL(pod.quantity_delivered,0)
2350: )

Line 2364: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2360: DECODE
2361: (NVL(poll.accrue_on_receipt_flag,'N'),
2362: 'N',
2363: (prd.req_line_quantity
2364: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2365: prl.unit_meas_lookup_code,
2366: prl.item_id)
2367: * GREATEST(NVL(pod.quantity_billed,0),
2368: NVL(pod.quantity_delivered,0)

Line 2373: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2369: )
2370: ),
2371: 'Y',
2372: (prd.req_line_quantity
2373: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2374: prl.unit_meas_lookup_code,
2375: prl.item_id)
2376: * NVL(pod.quantity_delivered,0)
2377: )

Line 2394: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2390: DECODE
2391: (NVL(poll.accrue_on_receipt_flag,'N'),
2392: 'N',
2393: (prd.req_line_quantity
2394: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2395: prl.unit_meas_lookup_code,
2396: prl.item_id)
2397: * GREATEST(NVL(pod.quantity_billed,0),
2398: NVL(pod.quantity_delivered,0)

Line 2403: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2399: )
2400: ),
2401: 'Y',
2402: (prd.req_line_quantity
2403: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2404: prl.unit_meas_lookup_code,
2405: prl.item_id)
2406: * NVL(pod.quantity_delivered,0)
2407: )

Line 2421: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2417: DECODE
2418: (NVL(poll.accrue_on_receipt_flag,'N'),
2419: 'N',
2420: (prd.req_line_quantity
2421: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2422: prl.unit_meas_lookup_code,
2423: prl.item_id)
2424: * GREATEST(NVL(pod.quantity_billed,0),
2425: NVL(pod.quantity_delivered,0)

Line 2430: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2426: )
2427: ),
2428: 'Y',
2429: (prd.req_line_quantity
2430: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2431: prl.unit_meas_lookup_code,
2432: prl.item_id)
2433: * NVL(pod.quantity_delivered,0)
2434: )

Line 2559: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2555: DECODE
2556: (NVL(poll.accrue_on_receipt_flag,'N'),
2557: 'N',
2558: (prd.req_line_quantity
2559: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2560: prl.unit_meas_lookup_code,
2561: prl.item_id)
2562: * GREATEST(NVL(pod.quantity_billed,0),
2563: NVL(pod.quantity_delivered,0)

Line 2568: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2564: )
2565: ),
2566: 'Y',
2567: (prd.req_line_quantity
2568: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2569: prl.unit_meas_lookup_code,
2570: prl.item_id)
2571: * NVL(pod.quantity_delivered,0)
2572: )

Line 2586: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2582: DECODE
2583: (NVL(poll.accrue_on_receipt_flag,'N'),
2584: 'N',
2585: (prd.req_line_quantity
2586: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2587: prl.unit_meas_lookup_code,
2588: prl.item_id)
2589: * GREATEST(NVL(pod.quantity_billed,0),
2590: NVL(pod.quantity_delivered,0)

Line 2595: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2591: )
2592: ),
2593: 'Y',
2594: (prd.req_line_quantity
2595: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2596: prl.unit_meas_lookup_code,
2597: prl.item_id)
2598: * NVL(pod.quantity_delivered,0)
2599: )

Line 2616: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2612: DECODE
2613: (NVL(poll.accrue_on_receipt_flag,'N'),
2614: 'N',
2615: (prd.req_line_quantity
2616: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2617: prl.unit_meas_lookup_code,
2618: prl.item_id)
2619: * GREATEST(NVL(pod.quantity_billed,0),
2620: NVL(pod.quantity_delivered,0)

Line 2625: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2621: )
2622: ),
2623: 'Y',
2624: (prd.req_line_quantity
2625: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2626: prl.unit_meas_lookup_code,
2627: prl.item_id)
2628: * NVL(pod.quantity_delivered,0)
2629: )

Line 2643: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2639: DECODE
2640: (NVL(poll.accrue_on_receipt_flag,'N'),
2641: 'N',
2642: (prd.req_line_quantity
2643: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2644: prl.unit_meas_lookup_code,
2645: prl.item_id)
2646: * GREATEST(NVL(pod.quantity_billed,0),
2647: NVL(pod.quantity_delivered,0)

Line 2652: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,

2648: )
2649: ),
2650: 'Y',
2651: (prd.req_line_quantity
2652: - po_uom_s.po_uom_convert_p(pol.unit_meas_lookup_code,
2653: prl.unit_meas_lookup_code,
2654: prl.item_id)
2655: * NVL(pod.quantity_delivered,0)
2656: )