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.PO_CHG_REQUEST_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 961: update po_line_locations_all

957: end if; -- if only so has changed
958:
959: if (l_po_change_requests(i).New_Supplier_Order_Line_Number is not null) then
960: begin
961: update po_line_locations_all
962: set supplier_order_line_number = l_po_change_requests(i).New_Supplier_Order_Line_Number
963: where line_location_id = l_po_change_requests(i).document_line_location_id;
964: exception
965: WHEN OTHERS THEN

Line 1235: update po_line_locations_all

1231: -- Approved flag for cancellation records as asked by DBI team
1232: -- bug 4306375
1233: -- jai
1234:
1235: update po_line_locations_all
1236: set approved_flag = 'R'
1237: where line_location_id in (select document_line_location_id
1238: from po_change_requests
1239: where request_level = 'SHIPMENT' and

Line 1253: update po_line_locations_all

1249: -- Approved flag for cancellation records as asked by DBI team
1250: -- bug 4306375
1251: -- jai
1252:
1253: update po_line_locations_all
1254: set approved_flag = 'R'
1255: where po_header_id in (select document_header_id
1256: from po_change_requests
1257: where request_level = 'HEADER' and

Line 1264: update po_line_locations_all

1260: initiator = 'SUPPLIER' and
1261: request_status ='PENDING') and
1262: approved_flag='Y';
1263:
1264: update po_line_locations_all
1265: set approved_flag = 'R'
1266: where po_line_id in (select document_line_id
1267: from po_change_requests
1268: where request_level = 'LINE' and

Line 1302: update po_line_locations_all

1298: where po_release_id = p_po_release_id;
1299:
1300: -- Now Update the approved_flag to R for all the shipments that has been
1301: -- changed to prevent receiving
1302: update po_line_locations_all
1303: set approved_flag = 'R'
1304: where line_location_id in (select document_line_location_id
1305: from po_change_requests
1306: where request_level = 'SHIPMENT' and

Line 1314: update po_line_locations_all

1310: request_status = 'PENDING') and
1311: approved_flag='Y';
1312:
1313: --New DBI request
1314: update po_line_locations_all
1315: set approved_flag = 'R'
1316: where po_release_id in (select po_release_id
1317: from po_change_requests
1318: where request_level = 'HEADER' and

Line 2077: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL

2073: BEGIN
2074: if (p_po_release_id is not null) then
2075: SELECT count(*)
2076: INTO x_ship_count
2077: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL
2078: WHERE POLL.po_release_id = p_po_release_id
2079: AND POLL.po_line_id = POL.po_line_id
2080: AND nvl(POLL.cancel_flag, 'N') = 'N'
2081: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH

2086: AND POL.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE');
2087: else
2088: SELECT count(*)
2089: INTO x_ship_count
2090: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2091: WHERE
2092: POH.PO_HEADER_ID = p_po_header_id
2093: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2094: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

Line 2211: from po_line_locations_all pll,

2207: (1.0,FND_API.G_FALSE,pll.line_location_id,
2208: pll.po_header_id, p_po_release_id,p_revision_num),nvl(poh.acceptance_required_flag,'N'),
2209: poh.revision_num,nvl(pll.consigned_flag,'N')
2210: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2211: from po_line_locations_all pll,
2212: po_headers_all poh,
2213: po_lookup_codes polc
2214: where
2215: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and

Line 2274: from po_line_locations_all pll,

2270: (1.0,FND_API.G_FALSE,pll.line_location_id,
2271: pll.po_header_id, p_po_release_id,p_revision_num),nvl(por.acceptance_required_flag,'N'),
2272: por.revision_num,nvl(pll.consigned_flag,'N')
2273: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2274: from po_line_locations_all pll,
2275: po_releases_all por,
2276: po_lookup_codes polc
2277: where
2278: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and

Line 3102: from po_line_locations_All

3098: v_progress := '111';
3099:
3100: select max(shipment_num)
3101: into v_ship_num
3102: from po_line_locations_All
3103: where po_line_id = p_po_line_id
3104: group by po_line_id;
3105:
3106: RETURN v_ship_num;

Line 3278: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3274: l_quan_billed := -1;
3275: begin
3276: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3277: into l_quan_ordered, l_quan_billed, l_quan_recd
3278: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3279: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3280: AND POLL.po_line_id = POL.po_line_id
3281: AND nvl(POLL.cancel_flag, 'N') = 'N'
3282: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 3309: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3305: l_quan_billed := -1;
3306: begin
3307: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3308: into l_quan_ordered, l_quan_billed, l_quan_recd
3309: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3310: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3311: AND POLL.po_line_id = POL.po_line_id
3312: AND nvl(POLL.cancel_flag, 'N') = 'N'
3313: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'