DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_UOM_S

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

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)

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

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))

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

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)

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

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))

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

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)

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

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))

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

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)

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

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))

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

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)

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

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))

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

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)

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

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))

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

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)

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

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))

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

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)

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

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))

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

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)

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

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: )

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

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)

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

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: )

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

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)

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

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: )

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

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)

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

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: )

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

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)

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

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: )

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

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)

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

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: )

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

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)

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

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: )

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

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)

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

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: )