[Home] [Help]
492: CURSOR c_promise_date_changes(p_po_header_id_csr IN NUMBER,p_change_group_id_csr IN NUMBER) IS
493: SELECT nvl(pcr.old_promised_date,pcr.old_need_by_date) old_promise_date,
494: pcr.new_promised_date, pll.promised_date,pll.need_by_date
495: FROM po_change_requests pcr,
496: po_line_locations_all pll
497: WHERE pcr.document_header_id=p_po_header_id_csr
498: AND pcr.document_line_location_id = pll.line_location_id
499: AND pcr.CHANGE_REQUEST_GROUP_ID=p_change_group_id_csr
500: AND pcr.request_level = 'SHIPMENT'
510: l_prom_date_dec NUMBER;
511: l_prom_date_incr NUMBER;
512: l_old_promise_date po_change_requests.old_promised_date%type;
513: l_new_promise_date po_change_requests.new_promised_date%type;
514: l_promised_date po_line_locations_all.promised_date%type;
515: l_need_by_date po_line_locations_all.need_by_date%type;
516: x_progress VARCHAR2(1000);
517: l_return_val VARCHAR2(1):='Y';
518: l_po_style_type VARCHAR2(10);
511: l_prom_date_incr NUMBER;
512: l_old_promise_date po_change_requests.old_promised_date%type;
513: l_new_promise_date po_change_requests.new_promised_date%type;
514: l_promised_date po_line_locations_all.promised_date%type;
515: l_need_by_date po_line_locations_all.need_by_date%type;
516: x_progress VARCHAR2(1000);
517: l_return_val VARCHAR2(1):='Y';
518: l_po_style_type VARCHAR2(10);
519: l_doc_type VARCHAR2(10);
643: -- pcr.old_price is added to consider price breaks for release
644: CURSOR c_ship_unit_price_rel (p_po_release_id_csr IN NUMBER,p_po_header_id IN NUMBER,p_change_group_id_csr IN NUMBER) IS
645: SELECT plla.price_override,nvl(pcr.new_price,pcr.old_price)
646: FROM po_change_requests pcr,
647: po_line_locations_all plla
648: WHERE pcr.po_release_id= p_po_release_id_csr
649: AND pcr.CHANGE_REQUEST_GROUP_ID=p_change_group_id_csr
650: AND pcr.request_level = 'SHIPMENT'
651: AND pcr.new_price IS NOT NULL
953: -- Picks up Old Amount for SPO
954: CURSOR c_old_doc_amt_changes(p_po_header_id_csr IN NUMBER) IS
955: SELECT sum(decode(pl.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_cancelled,0)),(pl.unit_price * (pll.quantity - nvl(pll.quantity_cancelled,0)))))
956: FROM po_lines_all pl,
957: po_line_locations_all pll
958: WHERE pl.po_header_id = p_po_header_id_csr
959: AND pll.po_line_id = pl.po_line_id;
960: -- Picks up Old Amount For Releases
961: CURSOR c_old_doc_amt_changes_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) IS
960: -- Picks up Old Amount For Releases
961: CURSOR c_old_doc_amt_changes_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) IS
962: SELECT sum(decode(pl.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_cancelled,0)),(pll.price_override * (pll.quantity - nvl(pll.quantity_cancelled,0)))))
963: FROM po_lines_all pl,
964: po_line_locations_all pll
965: WHERE pll.po_release_id = p_po_release_id_csr
966: AND pll.po_header_id = p_po_header_id_csr
967: AND pll.po_line_id = pl.po_line_id;
968:
977: (pll.amount - NVL(pll.amount_cancelled,0)),
978: 'RATE',
979: (pll.quantity - NVL(pll.quantity_cancelled,0))*(pll.price_override))))
980: FROM po_lines_all pl,
981: po_line_locations_all pll
982: WHERE pl.po_header_id = p_po_header_id_csr
983: AND pll.po_line_id = pl.po_line_id;
984:
985:
1164: (nvl(pcr1.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
1165: FROM po_change_requests pcr, --line amount/price change
1166: po_change_requests pcr1, --shipment quantity change
1167: po_lines_all pl,
1168: po_line_locations_all pll
1169: WHERE pl.po_header_id = p_po_header_id_csr
1170: AND pll.po_line_id = pl.po_line_id
1171: AND pcr1.document_header_id (+) = p_po_header_id_csr
1172: AND pcr1.document_line_location_id(+) = pll.line_location_id
1185: (nvl(pcr.new_price,pl.unit_price) * pcr2.new_quantity))),0)
1186: FROM po_change_requests pcr, --line amount/price change
1187: po_change_requests pcr2, --for split shipments
1188: po_lines_all pl,
1189: po_line_locations_all pll
1190: WHERE pl.po_header_id = p_po_header_id_csr
1191: AND pll.po_line_id = pl.po_line_id
1192: AND pcr2.document_header_id = p_po_header_id_csr
1193: AND pcr2.parent_line_location_id = pll.line_location_id
1206: CURSOR c_new_doc_amt_changes_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER ) IS
1207: SELECT nvl(sum(decode(pl.matching_basis, 'AMOUNT', (nvl(pcr.new_amount, pll.amount) - nvl(pll.amount_cancelled,0)), (nvl(nvl(pcr.new_price,pcr.old_price),pll.price_override) * (nvl(pcr.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
1208: FROM po_change_requests pcr,
1209: po_lines_all pl,
1210: po_line_locations_all pll
1211: WHERE pll.po_header_id = p_po_header_id_csr
1212: AND pll.po_release_id = p_po_release_id_csr
1213: AND pll.po_line_id = pl.po_line_id
1214: AND pcr.po_release_id(+) = p_po_release_id_csr
1222: UNION ALL
1223: SELECT nvl(sum(decode(pl.matching_basis, 'AMOUNT', nvl(pcr2.new_amount, pll.amount), (nvl(pcr2.new_price,pll.price_override) * nvl(pcr2.new_quantity,pll.quantity)))),0)
1224: FROM po_change_requests pcr2, -- for splitted shipments
1225: po_lines_all pl,
1226: po_line_locations_all pll
1227: WHERE pll.po_header_id = p_po_header_id_csr
1228: AND pll.po_line_id = pl.po_line_id
1229: AND pcr2.po_release_id(+) = p_po_release_id_csr
1230: AND pcr2.document_header_id(+) = p_po_header_id_csr
1249: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
1250: FROM
1251: po_change_requests pcr, --shipment changes
1252: po_lines_all pl,
1253: po_line_locations_all pll
1254: WHERE
1255: pl.po_header_id = p_po_header_id_csr
1256: AND pll.po_line_id = pl.po_line_id
1257: AND pcr.document_header_id (+) = p_po_header_id_csr
1273: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
1274: FROM
1275: po_change_requests pcr, --shipment changes
1276: po_lines_all pl,
1277: po_line_locations_all pll
1278: WHERE
1279: pl.po_header_id = p_po_header_id_csr
1280: AND pll.po_line_id = pl.po_line_id
1281: AND pcr.document_header_id = p_po_header_id_csr
1390: -- Picks up Old Line Amount for SPO
1391: CURSOR c_line_amt_old(p_po_header_id_csr IN NUMBER) IS
1392: select sum(decode(pol.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_cancelled,0)), (pol.unit_price * (pll.quantity - nvl(pll.quantity_cancelled,0))))),pll.po_line_id
1393: from po_lines_all pol,
1394: po_line_locations_all pll
1395: where pll.po_header_id = p_po_header_id_csr
1396: AND pll.po_line_id = pol.po_line_id
1397: GROUP BY pll.po_line_id;
1398:
1398:
1399: CURSOR c_line_amt_old_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) IS
1400: select sum(decode(pol.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_cancelled,0)), (pol.unit_price * (pll.quantity - nvl(pll.quantity_cancelled,0))))),pll.po_line_id
1401: from po_lines_all pol,
1402: po_line_locations_all pll
1403: where pll.po_release_id =p_po_release_id_csr
1404: AND pll.po_header_id = p_po_header_id_csr
1405: AND pll.po_line_id = pol.po_line_id
1406: GROUP BY pll.po_line_id;
1424: (pll.amount - NVL(pll.amount_cancelled,0)),
1425: 'RATE',
1426: (pll.quantity - NVL(pll.quantity_cancelled,0))*(pll.price_override)))),pll.po_line_id
1427: FROM po_lines_all pl,
1428: po_line_locations_all pll
1429: WHERE pl.po_header_id = p_po_header_id_csr
1430: AND pll.po_line_id = pl.po_line_id
1431: GROUP BY pll.po_line_id;
1432:
1645: (nvl(pcr1.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
1646: FROM po_change_requests pcr, --line amount/price change
1647: po_change_requests pcr1, --shipment quantity change
1648: po_lines_all pl,
1649: po_line_locations_all pll
1650: WHERE pl.po_header_id = p_po_header_id_csr
1651: AND pl.po_line_id = p_temp_po_line_id_csr
1652: AND pll.po_line_id = pl.po_line_id
1653: AND pcr1.document_header_id (+) = p_po_header_id_csr
1667: (nvl(pcr.new_price,pl.unit_price) * pcr2.new_quantity))),0)
1668: FROM po_change_requests pcr, --line amount/price change
1669: po_change_requests pcr2, --for split shipments
1670: po_lines_all pl,
1671: po_line_locations_all pll
1672: WHERE pl.po_header_id = p_po_header_id_csr
1673: AND pl.po_line_id = p_temp_po_line_id_csr
1674: AND pll.po_line_id = pl.po_line_id
1675: AND pcr2.document_header_id = p_po_header_id_csr
1692: (nvl(nvl(pcr.new_price,pcr.old_price),pll.price_override) *
1693: (nvl(pcr.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
1694: FROM po_change_requests pcr,
1695: po_lines_all pl,
1696: po_line_locations_all pll
1697: WHERE pll.po_header_id = p_po_header_id_csr
1698: AND pll.po_line_id = p_temp_po_line_id_csr
1699: AND pll.po_line_id = pl.po_line_id
1700: AND pll.po_release_id = p_po_release_id_csr
1709: UNION ALL
1710: SELECT nvl(sum(decode(pl.matching_basis, 'AMOUNT', nvl(pcr2.new_amount, pll.amount), (nvl(nvl(pcr2.new_price,pcr2.old_price),pll.price_override) * nvl(pcr2.new_quantity,pll.quantity)))),0)
1711: FROM po_change_requests pcr2, -- for splitted shipments
1712: po_lines_all pl,
1713: po_line_locations_all pll
1714: WHERE pll.po_header_id = p_po_header_id_csr
1715: AND pll.po_line_id = p_temp_po_line_id_csr
1716: AND pll.po_line_id = pl.po_line_id
1717: AND pcr2.po_release_id = p_po_release_id_csr
1737: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
1738: FROM
1739: po_change_requests pcr, --shipment quantity changes
1740: po_lines_all pl,
1741: po_line_locations_all pll
1742: WHERE
1743: pl.po_header_id = p_po_header_id_csr
1744: AND pl.po_line_id = p_temp_po_line_id_csr
1745: AND pll.po_line_id = pl.po_line_id
1762: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
1763: FROM
1764: po_change_requests pcr, --shipment quantity changes
1765: po_lines_all pl,
1766: po_line_locations_all pll
1767: WHERE
1768: pl.po_header_id = p_po_header_id_csr
1769: AND pl.po_line_id = p_temp_po_line_id_csr
1770: AND pll.po_line_id = pl.po_line_id
1884:
1885: -- Calculates the old shipment amount
1886: CURSOR c_old_ship_amt(p_po_header_id_csr IN NUMBER) IS
1887: select sum(decode(pol.matching_basis,'AMOUNT',(nvl(pll.amount,0) - nvl(pll.amount_cancelled,0)),(pol.unit_price *(pll.quantity-nvl(pll.quantity_cancelled,0))))),pll.line_location_id
1888: from po_line_locations_all pll,
1889: po_lines_all pol
1890: where pll.po_header_id = p_po_header_id_csr
1891: AND pll.po_line_id = pol.po_line_id
1892: GROUP BY pll.line_location_id;
1895: CURSOR c_old_ship_amt_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) IS
1896: SELECT sum(decode(pl.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_cancelled,0)),(pll.price_override * (pll.quantity - nvl(pll.quantity_cancelled,0))))),
1897: pll.line_location_id
1898: FROM po_lines_all pl,
1899: po_line_locations_all pll
1900: WHERE pll.po_release_id = p_po_release_id_csr
1901: AND pll.po_header_id = p_po_header_id_csr
1902: AND pll.po_line_id = pl.po_line_id
1903: GROUP BY pll.line_location_id;
1913: (pll.amount - NVL(pll.amount_cancelled,0)),
1914: 'RATE',
1915: (pll.quantity - NVL(pll.quantity_cancelled,0))*(pll.price_override)))),pll.line_location_id
1916: FROM po_lines_all pl,
1917: po_line_locations_all pll
1918: WHERE pl.po_header_id = p_po_header_id_csr
1919: AND pll.po_line_id = pl.po_line_id
1920: GROUP BY pll.line_location_id;
1921:
2151: (nvl(pcr1.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
2152: FROM po_change_requests pcr, --line amount/price change
2153: po_change_requests pcr1, --shipment quantity change
2154: po_lines_all pl,
2155: po_line_locations_all pll
2156: WHERE pl.po_header_id = p_po_header_id_csr
2157: AND pll.line_location_id = p_line_location_id_csr
2158: AND pll.po_line_id = pl.po_line_id
2159: AND pcr1.document_header_id (+) = p_po_header_id_csr
2174: (nvl(pcr.new_price,pl.unit_price) * pcr2.new_quantity))),0)
2175: FROM po_change_requests pcr, --line amount/price change
2176: po_change_requests pcr2, --for split shipments
2177: po_lines_all pl,
2178: po_line_locations_all pll
2179: WHERE pl.po_header_id = p_po_header_id_csr
2180: AND pll.line_location_id = p_line_location_id_csr
2181: AND pll.po_line_id = pl.po_line_id
2182: AND pcr2.document_header_id = p_po_header_id_csr
2199: (nvl(nvl(pcr.new_price,pcr.old_price),pll.price_override) *
2200: (nvl(pcr.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
2201: FROM po_change_requests pcr,
2202: po_lines_all pl,
2203: po_line_locations_all pll
2204: WHERE pll.po_header_id = p_po_header_id_csr
2205: AND pll.line_location_id = p_line_location_id_csr
2206: AND pll.po_release_id = p_po_release_id_csr
2207: AND pll.po_line_id = pl.po_line_id
2217: CURSOR c_new_ship_amt_rel_split(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER, p_line_location_id_csr IN NUMBER,req_status IN VARCHAR,req_initiator IN VARCHAR,p_po_shipment_num IN NUMBER) IS
2218: SELECT nvl(sum(decode(pl.matching_basis, 'AMOUNT', nvl(pcr2.new_amount, pll.amount), (nvl(nvl(pcr2.new_price,pcr2.old_price),pll.price_override) * nvl(pcr2.new_quantity,pll.quantity)))),0)
2219: FROM po_change_requests pcr2, -- for splitted shipments
2220: po_lines_all pl,
2221: po_line_locations_all pll
2222: WHERE pll.po_header_id = p_po_header_id_csr
2223: AND pll.line_location_id = p_line_location_id_csr
2224: AND pll.po_line_id = pl.po_line_id
2225: AND pcr2.po_release_id = p_po_release_id_csr
2245: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
2246: FROM
2247: po_change_requests pcr, --shipment quantity changes
2248: po_lines_all pl,
2249: po_line_locations_all pll
2250: WHERE
2251: pl.po_header_id = p_po_header_id_csr
2252: AND pll.line_location_id = p_line_location_id_csr
2253: AND pll.po_line_id = pl.po_line_id
2271: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
2272: FROM
2273: po_change_requests pcr, --shipment quantity changes
2274: po_lines_all pl,
2275: po_line_locations_all pll
2276: WHERE
2277: pl.po_header_id = p_po_header_id_csr
2278: AND pll.line_location_id = p_line_location_id_csr
2279: AND pll.po_line_id = pl.po_line_id
2755: select distinct porh.requisition_header_id
2756: from po_requisition_headers_all porh,
2757: po_requisition_lines_all porl,
2758: po_headers_all poh,
2759: po_line_locations_all poll
2760: where porh.requisition_header_id = porl.requisition_header_id AND
2761: porl.line_location_id = poll.line_location_id AND
2762: poh.po_header_id = poll.po_header_id AND
2763: poh.po_header_id = p_po_header_id_csr;
2766: select distinct porh.requisition_header_id
2767: from po_requisition_headers_all porh,
2768: po_requisition_lines_all porl,
2769: po_headers_all poh,
2770: po_line_locations_all poll
2771: where porh.requisition_header_id = porl.requisition_header_id AND
2772: porl.line_location_id = poll.line_location_id AND
2773: poh.po_header_id = poll.po_header_id AND
2774: poh.po_header_id = p_po_header_id_csr AND
2983:
2984: CURSOR c_reqs_count(p_po_header_id_csr IN NUMBER) is
2985: SELECT count(distinct porl.requisition_header_id)
2986: FROM po_requisition_lines_all porl, --
2987: po_line_locations_all poll
2988: WHERE poll.line_location_id = porl.line_location_id AND
2989: NVL(poll.cancel_flag, 'N') = 'N' AND
2990: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
2991: poll.shipment_type IN('STANDARD', 'BLANKET')
2995:
2996: CURSOR c_reqs_count_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
2997: SELECT count(distinct porl.requisition_header_id)
2998: FROM po_requisition_lines_all porl, --
2999: po_line_locations_all poll
3000: WHERE poll.line_location_id = porl.line_location_id AND
3001: NVL(poll.cancel_flag, 'N') = 'N' AND
3002: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
3003: poll.shipment_type IN('STANDARD', 'BLANKET')
3008: -- Cursor for checking all shipments should be mappped to one req.
3009:
3010: CURSOR c_req_map_ship(p_po_header_id_csr IN NUMBER) is
3011: SELECT count(1)
3012: FROM po_line_locations_all plla
3013: WHERE plla.po_header_id = p_po_header_id_csr
3014: AND plla.line_location_id NOT IN (SELECT plla2.line_location_id
3015: FROM po_requisition_lines_all porla,
3016: po_line_locations_all plla2
3012: FROM po_line_locations_all plla
3013: WHERE plla.po_header_id = p_po_header_id_csr
3014: AND plla.line_location_id NOT IN (SELECT plla2.line_location_id
3015: FROM po_requisition_lines_all porla,
3016: po_line_locations_all plla2
3017: WHERE plla2.po_header_id = p_po_header_id_csr
3018: AND porla.line_location_id = plla2.line_location_id);
3019:
3020:
3020:
3021: -- Cursor for checking all shipments should be mappped to one req for the releases
3022: CURSOR c_req_map_ship_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) IS
3023: SELECT count(1)
3024: FROM po_line_locations_all plla
3025: WHERE plla.po_header_id = p_po_header_id_csr
3026: AND plla.po_release_id = p_po_release_id_csr
3027: AND plla.line_location_id NOT IN ( SELECT plla2.line_location_id
3028: FROM po_requisition_lines_all porla,
3025: WHERE plla.po_header_id = p_po_header_id_csr
3026: AND plla.po_release_id = p_po_release_id_csr
3027: AND plla.line_location_id NOT IN ( SELECT plla2.line_location_id
3028: FROM po_requisition_lines_all porla,
3029: po_line_locations_all plla2
3030: WHERE plla2.po_header_id = p_po_header_id_csr
3031: AND plla2.po_release_id = p_po_release_id_csr
3032: AND porla.line_location_id = plla2.line_location_id);
3033:
3037: cursor c_cat_price_change(p_po_header_id_csr IN NUMBER) is
3038: select count(1)
3039: from po_change_requests pcr,
3040: po_requisition_lines_all porl1,
3041: po_line_locations_all pll
3042: where pcr.document_header_id = p_po_header_id_csr
3043: AND pcr.REQUEST_LEVEL = 'LINE'
3044: AND pcr.new_price is not NULL
3045: AND pcr.request_status = 'PENDING'
3052: cursor c_ship_price_change(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3053: select count(1)
3054: from po_change_requests pcr,
3055: po_requisition_lines_all porl1,
3056: po_line_locations_all pll
3057: where pcr.document_header_id = p_po_header_id_csr
3058: AND pcr.po_release_id = p_po_release_id_csr
3059: AND pcr.REQUEST_LEVEL = 'SHIPMENT'
3060: AND nvl(pcr.new_price,pcr.new_amount) is not NULL -- NEW_AMOUNT in case of FPS
3067: cursor c_fps_price_change(p_po_header_id_csr IN NUMBER) IS
3068: select count(1)
3069: from po_change_requests pcr,
3070: po_requisition_lines_all porl1,
3071: po_line_locations_all pll
3072: where pcr.document_header_id = p_po_header_id_csr
3073: AND pcr.REQUEST_LEVEL = 'SHIPMENT'
3074: AND pcr.new_amount is not NULL
3075: AND pcr.request_status = 'PENDING'
3084: select count(1)
3085: from po_requisition_headers_all porh,
3086: po_requisition_lines_all porl,
3087: po_headers_all poh,
3088: po_line_locations_all poll
3089: where porh.requisition_header_id = porl.requisition_header_id AND
3090: porl.line_location_id = poll.line_location_id AND
3091: poh.po_header_id = poll.po_header_id AND
3092: poh.po_header_id = p_po_header_id_csr AND
3099: select count(1)
3100: from po_requisition_headers_all porh,
3101: po_requisition_lines_all porl,
3102: po_headers_all poh,
3103: po_line_locations_all poll
3104: where porh.requisition_header_id = porl.requisition_header_id AND
3105: porl.line_location_id = poll.line_location_id AND
3106: poh.po_header_id = poll.po_header_id AND
3107: poh.po_header_id = p_po_header_id_csr AND
3896: prda.distribution_id
3897: FROM po_change_requests pcr,
3898: po_requisition_lines_all prla,
3899: po_req_distributions_all prda,
3900: po_line_locations_all plla
3901: WHERE document_header_id= p_po_header_id_csr
3902: AND request_status='BUYER_APP'
3903: AND change_active_flag='Y'
3904: AND initiator='SUPPLIER'
3929: prla.requisition_header_id,
3930: prla.line_location_id,
3931: null distribution_id
3932: FROM po_change_requests pcr,
3933: po_line_locations_all plla,
3934: po_requisition_lines_all prla
3935: WHERE document_header_id=p_po_header_id_csr
3936: AND request_status='BUYER_APP'
3937: AND change_active_flag='Y'
3960: prda.distribution_id
3961: FROM po_change_requests pcr,
3962: po_requisition_lines_all prla,
3963: po_req_distributions_all prda,
3964: po_line_locations_all plla
3965: WHERE pcr.po_release_id= p_po_release_id_csr
3966: AND request_status='BUYER_APP'
3967: AND change_active_flag='Y'
3968: AND initiator='SUPPLIER'
3994: prla.requisition_header_id,
3995: prla.line_location_id,
3996: null distribution_id
3997: FROM po_change_requests pcr,
3998: po_line_locations_all plla,
3999: po_requisition_lines_all prla
4000: WHERE pcr.po_release_id=p_po_release_id_csr
4001: AND request_status='BUYER_APP'
4002: AND change_active_flag='Y'
4348: select porh.PREPARER_ID
4349: from po_requisition_headers_all porh,
4350: po_requisition_lines_all porl,
4351: po_headers_all poh,
4352: po_line_locations_all poll
4353: where porh.requisition_header_id = porl.requisition_header_id AND
4354: porl.line_location_id = poll.line_location_id AND
4355: poh.po_header_id = poll.po_header_id AND
4356: poh.po_header_id = c_po_header_id;