eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 496: po_line_locations_all pll

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'

Line 514: l_promised_date po_line_locations_all.promised_date%type;

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

Line 515: l_need_by_date po_line_locations_all.need_by_date%type;

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

Line 647: po_line_locations_all plla

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

Line 957: po_line_locations_all pll

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

Line 964: po_line_locations_all pll

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:

Line 981: po_line_locations_all pll

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:

Line 1168: po_line_locations_all pll

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

Line 1189: po_line_locations_all pll

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

Line 1210: po_line_locations_all pll

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

Line 1226: po_line_locations_all pll

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

Line 1253: po_line_locations_all pll

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

Line 1277: po_line_locations_all pll

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

Line 1394: po_line_locations_all pll

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:

Line 1402: po_line_locations_all pll

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;

Line 1428: po_line_locations_all pll

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:

Line 1649: po_line_locations_all pll

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

Line 1671: po_line_locations_all pll

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

Line 1696: po_line_locations_all pll

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

Line 1713: po_line_locations_all pll

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

Line 1741: po_line_locations_all pll

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

Line 1766: po_line_locations_all pll

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

Line 1897: from po_line_locations_all pll,

1893:
1894: -- Calculates the old shipment amount
1895: CURSOR c_old_ship_amt(p_po_header_id_csr IN NUMBER) IS
1896: 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
1897: from po_line_locations_all pll,
1898: po_lines_all pol
1899: where pll.po_header_id = p_po_header_id_csr
1900: AND pll.po_line_id = pol.po_line_id
1901: GROUP BY pll.line_location_id;

Line 1908: po_line_locations_all pll

1904: CURSOR c_old_ship_amt_rel(p_po_header_id_csr IN NUMBER, p_po_release_id_csr IN NUMBER) IS
1905: SELECT sum(decode(pl.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_cancelled,0)),(pll.price_override * (pll.quantity - nvl(pll.quantity_cancelled,0))))),
1906: pll.line_location_id
1907: FROM po_lines_all pl,
1908: po_line_locations_all pll
1909: WHERE pll.po_release_id = p_po_release_id_csr
1910: AND pll.po_header_id = p_po_header_id_csr
1911: AND pll.po_line_id = pl.po_line_id
1912: GROUP BY pll.line_location_id;

Line 1926: po_line_locations_all pll

1922: (pll.amount - NVL(pll.amount_cancelled,0)),
1923: 'RATE',
1924: (pll.quantity - NVL(pll.quantity_cancelled,0))*(pll.price_override)))),pll.line_location_id
1925: FROM po_lines_all pl,
1926: po_line_locations_all pll
1927: WHERE pl.po_header_id = p_po_header_id_csr
1928: AND pll.po_line_id = pl.po_line_id
1929: GROUP BY pll.line_location_id;
1930:

Line 2164: po_line_locations_all pll

2160: (nvl(pcr1.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
2161: FROM po_change_requests pcr, --line amount/price change
2162: po_change_requests pcr1, --shipment quantity change
2163: po_lines_all pl,
2164: po_line_locations_all pll
2165: WHERE pl.po_header_id = p_po_header_id_csr
2166: AND pll.line_location_id = p_line_location_id_csr
2167: AND pll.po_line_id = pl.po_line_id
2168: AND pcr1.document_header_id (+) = p_po_header_id_csr

Line 2187: po_line_locations_all pll

2183: (nvl(pcr.new_price,pl.unit_price) * pcr2.new_quantity))),0)
2184: FROM po_change_requests pcr, --line amount/price change
2185: po_change_requests pcr2, --for split shipments
2186: po_lines_all pl,
2187: po_line_locations_all pll
2188: WHERE pl.po_header_id = p_po_header_id_csr
2189: AND pll.line_location_id = p_line_location_id_csr
2190: AND pll.po_line_id = pl.po_line_id
2191: AND pcr2.document_header_id = p_po_header_id_csr

Line 2212: po_line_locations_all pll

2208: (nvl(nvl(pcr.new_price,pcr.old_price),pll.price_override) *
2209: (nvl(pcr.new_quantity,pll.quantity) - nvl(pll.quantity_cancelled,0))))),0)
2210: FROM po_change_requests pcr,
2211: po_lines_all pl,
2212: po_line_locations_all pll
2213: WHERE pll.po_header_id = p_po_header_id_csr
2214: AND pll.line_location_id = p_line_location_id_csr
2215: AND pll.po_release_id = p_po_release_id_csr
2216: AND pll.po_line_id = pl.po_line_id

Line 2230: po_line_locations_all pll

2226: 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
2227: 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)
2228: FROM po_change_requests pcr2, -- for splitted shipments
2229: po_lines_all pl,
2230: po_line_locations_all pll
2231: WHERE pll.po_header_id = p_po_header_id_csr
2232: AND pll.line_location_id = p_line_location_id_csr
2233: AND pll.po_line_id = pl.po_line_id
2234: AND pcr2.po_release_id = p_po_release_id_csr

Line 2258: po_line_locations_all pll

2254: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
2255: FROM
2256: po_change_requests pcr, --shipment quantity changes
2257: po_lines_all pl,
2258: po_line_locations_all pll
2259: WHERE
2260: pl.po_header_id = p_po_header_id_csr
2261: AND pll.line_location_id = p_line_location_id_csr
2262: AND pll.po_line_id = pl.po_line_id

Line 2284: po_line_locations_all pll

2280: (nvl(pcr.new_quantity,pll.quantity) - NVL(pll.quantity_cancelled,0))*(nvl(pcr.new_price,pll.price_override))))),0)
2281: FROM
2282: po_change_requests pcr, --shipment quantity changes
2283: po_lines_all pl,
2284: po_line_locations_all pll
2285: WHERE
2286: pl.po_header_id = p_po_header_id_csr
2287: AND pll.line_location_id = p_line_location_id_csr
2288: AND pll.po_line_id = pl.po_line_id

Line 2824: po_line_locations_all poll

2820: select distinct porh.requisition_header_id
2821: from po_requisition_headers_all porh,
2822: po_requisition_lines_all porl,
2823: po_headers_all poh,
2824: po_line_locations_all poll
2825: where porh.requisition_header_id = porl.requisition_header_id AND
2826: porl.line_location_id = poll.line_location_id AND
2827: poh.po_header_id = poll.po_header_id AND
2828: poh.po_header_id = p_po_header_id_csr;

Line 2835: po_line_locations_all poll

2831: select distinct porh.requisition_header_id
2832: from po_requisition_headers_all porh,
2833: po_requisition_lines_all porl,
2834: po_headers_all poh,
2835: po_line_locations_all poll
2836: where porh.requisition_header_id = porl.requisition_header_id AND
2837: porl.line_location_id = poll.line_location_id AND
2838: poh.po_header_id = poll.po_header_id AND
2839: poh.po_header_id = p_po_header_id_csr AND

Line 3052: po_line_locations_all poll

3048:
3049: CURSOR c_reqs_count(p_po_header_id_csr IN NUMBER) is
3050: SELECT count(distinct porl.requisition_header_id)
3051: FROM po_requisition_lines_all porl, --
3052: po_line_locations_all poll
3053: WHERE poll.line_location_id = porl.line_location_id AND
3054: NVL(poll.cancel_flag, 'N') = 'N' AND
3055: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
3056: poll.shipment_type IN('STANDARD', 'BLANKET')

Line 3064: po_line_locations_all poll

3060:
3061: CURSOR c_reqs_count_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3062: SELECT count(distinct porl.requisition_header_id)
3063: FROM po_requisition_lines_all porl, --
3064: po_line_locations_all poll
3065: WHERE poll.line_location_id = porl.line_location_id AND
3066: NVL(poll.cancel_flag, 'N') = 'N' AND
3067: NVL(poll.CLOSEd_code, 'OPEN') <> 'FINALLY CLOSED' AND
3068: poll.shipment_type IN('STANDARD', 'BLANKET')

Line 3077: FROM po_line_locations_all plla

3073: -- Cursor for checking all shipments should be mappped to one req.
3074:
3075: CURSOR c_req_map_ship(p_po_header_id_csr IN NUMBER) is
3076: SELECT count(1)
3077: FROM po_line_locations_all plla
3078: WHERE plla.po_header_id = p_po_header_id_csr
3079: AND plla.line_location_id NOT IN (SELECT plla2.line_location_id
3080: FROM po_requisition_lines_all porla,
3081: po_line_locations_all plla2

Line 3081: po_line_locations_all plla2

3077: FROM po_line_locations_all plla
3078: WHERE plla.po_header_id = p_po_header_id_csr
3079: AND plla.line_location_id NOT IN (SELECT plla2.line_location_id
3080: FROM po_requisition_lines_all porla,
3081: po_line_locations_all plla2
3082: WHERE plla2.po_header_id = p_po_header_id_csr
3083: AND porla.line_location_id = plla2.line_location_id);
3084:
3085:

Line 3089: FROM po_line_locations_all plla

3085:
3086: -- Cursor for checking all shipments should be mappped to one req for the releases
3087: CURSOR c_req_map_ship_rel(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) IS
3088: SELECT count(1)
3089: FROM po_line_locations_all plla
3090: WHERE plla.po_header_id = p_po_header_id_csr
3091: AND plla.po_release_id = p_po_release_id_csr
3092: AND plla.line_location_id NOT IN ( SELECT plla2.line_location_id
3093: FROM po_requisition_lines_all porla,

Line 3094: po_line_locations_all plla2

3090: WHERE plla.po_header_id = p_po_header_id_csr
3091: AND plla.po_release_id = p_po_release_id_csr
3092: AND plla.line_location_id NOT IN ( SELECT plla2.line_location_id
3093: FROM po_requisition_lines_all porla,
3094: po_line_locations_all plla2
3095: WHERE plla2.po_header_id = p_po_header_id_csr
3096: AND plla2.po_release_id = p_po_release_id_csr
3097: AND porla.line_location_id = plla2.line_location_id);
3098:

Line 3106: po_line_locations_all pll

3102: cursor c_cat_price_change(p_po_header_id_csr IN NUMBER) is
3103: select count(1)
3104: from po_change_requests pcr,
3105: po_requisition_lines_all porl1,
3106: po_line_locations_all pll
3107: where pcr.document_header_id = p_po_header_id_csr
3108: AND pcr.REQUEST_LEVEL = 'LINE'
3109: AND pcr.new_price is not NULL
3110: AND pcr.request_status = 'PENDING'

Line 3121: po_line_locations_all pll

3117: cursor c_ship_price_change(p_po_header_id_csr IN NUMBER,p_po_release_id_csr IN NUMBER) is
3118: select count(1)
3119: from po_change_requests pcr,
3120: po_requisition_lines_all porl1,
3121: po_line_locations_all pll
3122: where pcr.document_header_id = p_po_header_id_csr
3123: AND pcr.po_release_id = p_po_release_id_csr
3124: AND pcr.REQUEST_LEVEL = 'SHIPMENT'
3125: AND nvl(pcr.new_price,pcr.new_amount) is not NULL -- NEW_AMOUNT in case of FPS

Line 3136: po_line_locations_all pll

3132: cursor c_fps_price_change(p_po_header_id_csr IN NUMBER) IS
3133: select count(1)
3134: from po_change_requests pcr,
3135: po_requisition_lines_all porl1,
3136: po_line_locations_all pll
3137: where pcr.document_header_id = p_po_header_id_csr
3138: AND pcr.REQUEST_LEVEL = 'SHIPMENT'
3139: AND pcr.new_amount is not NULL
3140: AND pcr.request_status = 'PENDING'

Line 3153: po_line_locations_all poll

3149: select count(1)
3150: from po_requisition_headers_all porh,
3151: po_requisition_lines_all porl,
3152: po_headers_all poh,
3153: po_line_locations_all poll
3154: where porh.requisition_header_id = porl.requisition_header_id AND
3155: porl.line_location_id = poll.line_location_id AND
3156: poh.po_header_id = poll.po_header_id AND
3157: poh.po_header_id = p_po_header_id_csr AND

Line 3168: po_line_locations_all poll

3164: select count(1)
3165: from po_requisition_headers_all porh,
3166: po_requisition_lines_all porl,
3167: po_headers_all poh,
3168: po_line_locations_all poll
3169: where porh.requisition_header_id = porl.requisition_header_id AND
3170: porl.line_location_id = poll.line_location_id AND
3171: poh.po_header_id = poll.po_header_id AND
3172: poh.po_header_id = p_po_header_id_csr AND

Line 4017: po_line_locations_all plla

4013: prda.distribution_id
4014: FROM po_change_requests pcr,
4015: po_requisition_lines_all prla,
4016: po_req_distributions_all prda,
4017: po_line_locations_all plla
4018: WHERE document_header_id= p_po_header_id_csr
4019: AND request_status='BUYER_APP'
4020: AND change_active_flag='Y'
4021: AND initiator='SUPPLIER'

Line 4050: po_line_locations_all plla,

4046: prla.requisition_header_id,
4047: prla.line_location_id,
4048: null distribution_id
4049: FROM po_change_requests pcr,
4050: po_line_locations_all plla,
4051: po_requisition_lines_all prla
4052: WHERE document_header_id=p_po_header_id_csr
4053: AND request_status='BUYER_APP'
4054: AND change_active_flag='Y'

Line 4081: po_line_locations_all plla

4077: prda.distribution_id
4078: FROM po_change_requests pcr,
4079: po_requisition_lines_all prla,
4080: po_req_distributions_all prda,
4081: po_line_locations_all plla
4082: WHERE pcr.po_release_id= p_po_release_id_csr
4083: AND request_status='BUYER_APP'
4084: AND change_active_flag='Y'
4085: AND initiator='SUPPLIER'

Line 4115: po_line_locations_all plla,

4111: prla.requisition_header_id,
4112: prla.line_location_id,
4113: null distribution_id
4114: FROM po_change_requests pcr,
4115: po_line_locations_all plla,
4116: po_requisition_lines_all prla
4117: WHERE pcr.po_release_id=p_po_release_id_csr
4118: AND request_status='BUYER_APP'
4119: AND change_active_flag='Y'

Line 4499: po_line_locations_all poll

4495: select UNIQUE(porh.PREPARER_ID)
4496: from po_requisition_headers_all porh,
4497: po_requisition_lines_all porl,
4498: po_headers_all poh,
4499: po_line_locations_all poll
4500: where porh.requisition_header_id = porl.requisition_header_id AND
4501: porl.line_location_id = poll.line_location_id AND
4502: poh.po_header_id = poll.po_header_id AND
4503: poh.po_header_id = c_po_header_id;