[Home] [Help]
1247: count(*)
1248: into
1249: l_dist_count
1250: FROM
1251: po_distributions_all
1252: WHERE
1253: -- begin fix for perf bug 2581067
1254: (
1255: (l_doc_level = 'D' AND po_distribution_id = l_doc_id)
1298: DECODE(POLL.MATCHING_BASIS, 'AMOUNT', POD.AMOUNT_ORDERED, -- Changed for Complex work procurement
1299: 'QUANTITY',POD.QUANTITY_ORDERED) ) "TAX"
1300: -----------------------------------------------------------------------------------------
1301: FROM
1302: po_distributions_all pod,
1303: po_line_locations_all poll,
1304: -- J Changes ----------------------------------------------------------------------------
1305: PO_LINES_ALL POL,
1306: -----------------------------------------------------------------------------------------
2160: 'AMOUNT', POD.AMOUNT_ORDERED,
2161: 'QUANTITY',POD.QUANTITY_ORDERED) "TAX"
2162: ---------------------------------------------------------------------------------------------------
2163: FROM
2164: po_distributions_all pod,
2165: po_line_locations_all poll,
2166: -- J Changes --------------------------------------------------------------------------------------
2167: PO_LINES_ALL POL,
2168: ---------------------------------------------------------------------------------------------------
2487: FROM
2488: po_headers_all POH,
2489: po_lines_all POL,
2490: po_line_locations_all POLL,
2491: po_distributions_all POD,
2492: rcv_transactions RT
2493: WHERE
2494: POH.po_header_id = POD.po_header_id AND
2495: POL.po_line_id = POD.po_line_id AND
2524: FROM
2525: po_headers_all POH,
2526: po_lines_all POL,
2527: po_line_locations_all POLL,
2528: po_distributions_all POD,
2529: rcv_transactions RT
2530: WHERE
2531: POH.po_header_id = POD.po_header_id
2532: AND POL.po_line_id = POD.po_line_id
3130: count(*)
3131: into
3132: l_dist_count
3133: FROM
3134: po_distributions_all
3135: WHERE
3136: (
3137: (l_doc_level = 'D' AND po_distribution_id = l_doc_id)
3138: OR (l_doc_level = 'S' AND line_location_id = l_doc_id)
3187: 'AMOUNT', pod.amount_ordered,
3188: pod.quantity_ordered)) "UNIT_PRICE",
3189: NVL(poll.match_option,'P') "MATCH_OPTION"
3190: FROM
3191: po_distributions_all pod,
3192: po_line_locations_all poll,
3193: po_lines_all pol,
3194: rcv_parameters rp
3195: WHERE