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

Line 220: -- Also update approved flag on the po_line_locations to restrict receiving

216: startWf := FND_API.G_TRUE;
217: -- initialize return status
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: -- Also update approved flag on the po_line_locations to restrict receiving
221: -- call workflow if this is the final action
222:
223: if p_po_release_id is null then
224: select wf_item_key,wf_item_type

Line 1065: update po_line_locations_all

1061: end if; -- if only so has changed
1062:
1063: if (l_po_change_requests(i).New_Supplier_Order_Line_Number is not null) then
1064: begin
1065: update po_line_locations_all
1066: set supplier_order_line_number = l_po_change_requests(i).New_Supplier_Order_Line_Number
1067: where line_location_id = l_po_change_requests(i).document_line_location_id;
1068: exception
1069: WHEN OTHERS THEN

Line 1348: update po_line_locations_all

1344: -- Approved flag for cancellation records as asked by DBI team
1345: -- bug 4306375
1346: -- jai
1347:
1348: update po_line_locations_all
1349: set approved_flag = 'R'
1350: where line_location_id in (select document_line_location_id
1351: from po_change_requests
1352: where request_level = 'SHIPMENT' and

Line 1366: update po_line_locations_all

1362: -- Approved flag for cancellation records as asked by DBI team
1363: -- bug 4306375
1364: -- jai
1365:
1366: update po_line_locations_all
1367: set approved_flag = 'R'
1368: where po_header_id in (select document_header_id
1369: from po_change_requests
1370: where request_level = 'HEADER' and

Line 1377: update po_line_locations_all

1373: initiator = 'SUPPLIER' and
1374: request_status ='PENDING') and
1375: approved_flag='Y';
1376:
1377: update po_line_locations_all
1378: set approved_flag = 'R'
1379: where po_line_id in (select document_line_id
1380: from po_change_requests
1381: where request_level = 'LINE' and

Line 1416: update po_line_locations_all

1412: where po_release_id = p_po_release_id;
1413:
1414: -- Now Update the approved_flag to R for all the shipments that has been
1415: -- changed to prevent receiving
1416: update po_line_locations_all
1417: set approved_flag = 'R'
1418: where line_location_id in (select document_line_location_id
1419: from po_change_requests
1420: where request_level = 'SHIPMENT' and

Line 1428: update po_line_locations_all

1424: request_status = 'PENDING') and
1425: approved_flag='Y';
1426:
1427: --New DBI request
1428: update po_line_locations_all
1429: set approved_flag = 'R'
1430: where po_release_id in (select po_release_id
1431: from po_change_requests
1432: where request_level = 'HEADER' and

Line 1574: from po_line_locations_archive_all poll

1570: from po_headers_all poh
1571: where poh.global_agreement_flag='Y'
1572: and poh.po_header_id=pol.from_header_id) and
1573: exists(select poll.line_location_id
1574: from po_line_locations_archive_all poll
1575: where poll.po_line_id = pol.po_line_id and
1576: nvl(poll.closed_code,'OPEN') not in('FINALLY CLOSED') and
1577: nvl(poll.cancel_flag,'N') <> 'Y' and
1578: poll.latest_external_flag='Y');

Line 1582: from po_line_locations_archive_all

1578: poll.latest_external_flag='Y');
1579:
1580: cursor ga_ship_csr(p_line_id in number) is
1581: select line_location_id,quantity
1582: from po_line_locations_archive_all
1583: where po_line_id = p_line_id and
1584: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and
1585: nvl(cancel_flag,'N') <> 'Y' and
1586: latest_external_flag='Y' ;

Line 1801: from po_line_locations_archive_all

1797: -- Get the price break for the total quantity for each line using the min shipment
1798: -- need by date and ship to org
1799: select ship_to_location_id, ship_to_organization_id,need_by_date
1800: into l_shipToLoc,l_shipToOrg,l_needBydate
1801: from po_line_locations_archive_all
1802: where shipment_num = (select min(shipment_num)
1803: from po_line_locations_archive_all
1804: where po_line_id = l_ga_lineId and
1805: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and

Line 1803: from po_line_locations_archive_all

1799: select ship_to_location_id, ship_to_organization_id,need_by_date
1800: into l_shipToLoc,l_shipToOrg,l_needBydate
1801: from po_line_locations_archive_all
1802: where shipment_num = (select min(shipment_num)
1803: from po_line_locations_archive_all
1804: where po_line_id = l_ga_lineId and
1805: nvl(closed_code,'OPEN') not in('FINALLY CLOSED') and
1806: nvl(cancel_flag,'N') <> 'Y' and
1807: latest_external_flag='Y' ) and

Line 2224: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL

2220: BEGIN
2221: if (p_po_release_id is not null) then
2222: SELECT count(*)
2223: INTO x_ship_count
2224: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL
2225: WHERE POLL.po_release_id = p_po_release_id
2226: AND POLL.po_line_id = POL.po_line_id
2227: AND nvl(POLL.cancel_flag, 'N') = 'N'
2228: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

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

2233: AND POL.order_type_lookup_code NOT IN ('RATE', 'FIXED PRICE');
2234: else
2235: SELECT count(*)
2236: INTO x_ship_count
2237: FROM PO_LINE_LOCATIONS_ALL POLL,PO_LINES_ALL POL,PO_HEADERS_ALL POH
2238: WHERE
2239: POH.PO_HEADER_ID = p_po_header_id
2240: AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
2241: AND POH.TYPE_LOOKUP_CODE ='STANDARD'

Line 2312: x_cons_flag po_line_locations.consigned_flag%type;

2308:
2309: x_ack_stat varchar2(40);
2310: x_accp_flag po_headers_all.acceptance_required_flag%type;
2311: x_revision number;
2312: x_cons_flag po_line_locations.consigned_flag%type;
2313:
2314: BEGIN
2315: if p_line_location_id is not null then
2316: if (p_po_release_id is null) then

Line 2358: from po_line_locations_all pll,

2354: (1.0,FND_API.G_FALSE,pll.line_location_id,
2355: pll.po_header_id, p_po_release_id,p_revision_num),nvl(poh.acceptance_required_flag,'N'),
2356: poh.revision_num,nvl(pll.consigned_flag,'N')
2357: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2358: from po_line_locations_all pll,
2359: po_headers_all poh,
2360: po_lookup_codes polc
2361: where
2362: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and

Line 2421: from po_line_locations_all pll,

2417: (1.0,FND_API.G_FALSE,pll.line_location_id,
2418: pll.po_header_id, p_po_release_id,p_revision_num),nvl(por.acceptance_required_flag,'N'),
2419: por.revision_num,nvl(pll.consigned_flag,'N')
2420: into x_msg_display,x_msg_code,x_ack_stat,x_accp_flag,x_revision,x_cons_flag
2421: from po_line_locations_all pll,
2422: po_releases_all por,
2423: po_lookup_codes polc
2424: where
2425: polc.lookup_code = NVL(pll.closed_code, 'OPEN') and

Line 3475: from po_line_locations_All

3471: v_progress := '111';
3472:
3473: select max(shipment_num)
3474: into v_ship_num
3475: from po_line_locations_All
3476: where po_line_id = p_po_line_id
3477: group by po_line_id;
3478:
3479: RETURN v_ship_num;

Line 3679: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3675: l_quan_billed := -1;
3676: begin
3677: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3678: into l_quan_ordered, l_quan_billed, l_quan_recd
3679: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3680: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3681: AND POLL.po_line_id = POL.po_line_id
3682: AND nvl(POLL.cancel_flag, 'N') = 'N'
3683: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 3710: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL

3706: l_quan_billed := -1;
3707: begin
3708: SELECT nvl(POLL.quantity, 0), nvl(POLL.quantity_billed, 0), nvl(POLL.quantity_received, 0)
3709: into l_quan_ordered, l_quan_billed, l_quan_recd
3710: FROM PO_LINE_LOCATIONS_ALL POLL, PO_LINES_ALL POL
3711: WHERE POLL.line_location_id = l_po_change_requests(j).document_line_location_id
3712: AND POLL.po_line_id = POL.po_line_id
3713: AND nvl(POLL.cancel_flag, 'N') = 'N'
3714: AND nvl(POLL.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 3759: FROM po_line_locations_all

3755: l_api_name VARCHAR2(100) := 'IS_ASN_EXIST';
3756: CURSOR ship_cur(
3757: p_po_line_id NUMBER) IS
3758: SELECT line_location_id,shipment_num
3759: FROM po_line_locations_all
3760: WHERE po_line_id = p_po_line_id;
3761: BEGIN
3762: l_err_count := 0;
3763: l_po_change_requests := p_po_change_requests;