[Home] [Help]
1274: count(*)
1275: into
1276: l_dist_count
1277: FROM
1278: po_distributions_all
1279: WHERE
1280: -- begin fix for perf bug 2581067
1281: (
1282: (l_doc_level = 'D' AND po_distribution_id = l_doc_id)
1325: DECODE(POLL.MATCHING_BASIS, 'AMOUNT', POD.AMOUNT_ORDERED, -- Changed for Complex work procurement
1326: 'QUANTITY',POD.QUANTITY_ORDERED*l_uom_ratio) ) "TAX"
1327: -----------------------------------------------------------------------------------------
1328: FROM
1329: po_distributions_all pod,
1330: po_line_locations_all poll,
1331: -- J Changes ----------------------------------------------------------------------------
1332: PO_LINES_ALL POL,
1333: -----------------------------------------------------------------------------------------
2440: 'AMOUNT', POD.AMOUNT_ORDERED,
2441: 'QUANTITY',POD.QUANTITY_ORDERED*l_uom_ratio) "TAX"
2442: ---------------------------------------------------------------------------------------------------
2443: FROM
2444: po_distributions_all pod,
2445: po_line_locations_all poll,
2446: -- J Changes --------------------------------------------------------------------------------------
2447: PO_LINES_ALL POL,
2448: ---------------------------------------------------------------------------------------------------
2847: FROM
2848: po_headers_all POH,
2849: po_lines_all POL,
2850: po_line_locations_all POLL,
2851: po_distributions_all POD,
2852: rcv_transactions RT
2853: WHERE
2854: POH.po_header_id = POD.po_header_id AND
2855: POL.po_line_id = POD.po_line_id AND
2884: FROM
2885: po_headers_all POH,
2886: po_lines_all POL,
2887: po_line_locations_all POLL,
2888: po_distributions_all POD,
2889: rcv_transactions RT
2890: WHERE
2891: POH.po_header_id = POD.po_header_id
2892: AND POL.po_line_id = POD.po_line_id
3490: count(*)
3491: into
3492: l_dist_count
3493: FROM
3494: po_distributions_all
3495: WHERE
3496: (
3497: (l_doc_level = 'D' AND po_distribution_id = l_doc_id)
3498: OR (l_doc_level = 'S' AND line_location_id = l_doc_id)
3547: 'AMOUNT', pod.amount_ordered,
3548: pod.quantity_ordered)) "UNIT_PRICE",
3549: NVL(poll.match_option,'P') "MATCH_OPTION"
3550: FROM
3551: po_distributions_all pod,
3552: po_line_locations_all poll,
3553: po_lines_all pol,
3554: rcv_parameters rp
3555: WHERE