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_RETROACTIVE_PRICING_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 243: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

239: poll.price_override, nvl(poll.need_by_date,sysdate),
240: poh.po_header_id,
241: poh.authorization_status, poh.revision_num,
242: poha.revision_num
243: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
244: po_headers_archive_all poha,financials_system_params_all fsp
245: where pol.from_line_id = l_po_line_id
246: and poh.po_header_id = pol.po_header_id
247: and poh.org_id = fsp.org_id -- -- Bug 3573266

Line 254: from po_line_locations_all polt

250: --to rule out unneccesary spo linelocations
251: and ( p_qp_license_on = 'Y' OR
252: ( p_qp_license_on = 'N' and nvl(poll.retroactive_date,sysdate) <> l_retroactive_date)) --
253: and poll.shipment_num = (select min(poll.shipment_num)
254: from po_line_locations_all polt
255: where polt.po_line_id=pol.po_line_id)
256: and nvl(poh.frozen_flag, 'N') = 'N'
257: and nvl(poh.authorization_status, 'INCOMPLETE') IN
258: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 270: from po_line_locations_all poll1

266: and nvl(poh.cancel_flag,'N') <> 'Y'
267: and nvl(poh.consigned_consumption_flag,'N') ='N'
268: and pol.po_line_id = poll.po_line_id
269: and not exists (Select 'billed received shipments'
270: from po_line_locations_all poll1
271: where poll1.po_line_id = pol.po_line_id
272: and ((poll1.accrue_on_receipt_flag = 'Y' and
273: poll1.quantity_received <> 0)
274: or

Line 340: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

336: poll.price_override, nvl(poll.need_by_date,sysdate),
337: poh.po_header_id,
338: poh.authorization_status, poh.revision_num,
339: poha.revision_num
340: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
341: po_headers_archive_all poha, po_document_types_all_b pdt,
342: financials_system_params_all fsp
343: where pol.from_line_id = l_po_line_id
344: and poh.po_header_id = pol.po_header_id

Line 352: from po_line_locations_all poll1

348: and pdt.document_type_code = 'PO' -- Bug 3573266
349: and pdt.document_subtype = 'STANDARD' -- Bug 3573266
350: and (nvl(pdt.archive_external_revision_code,'PRINT') = 'APPROVE' -- Bug 3573266
351: or (not exists (Select 'billed received shipments' -- Bug 3565522
352: from po_line_locations_all poll1
353: where poll1.po_line_id = pol.po_line_id
354: and ((poll1.accrue_on_receipt_flag = 'Y' and
355: poll1.quantity_received <> 0)
356: or

Line 363: from po_line_locations_all polt

359: --to rule out unneccesary spo linelocations
360: and ( p_qp_license_on = 'Y' OR
361: ( p_qp_license_on = 'N' and nvl(poll.retroactive_date,sysdate) <> l_retroactive_date)) --
362: and poll.shipment_num = (select min(poll.shipment_num)
363: from po_line_locations_all polt
364: where polt.po_line_id=pol.po_line_id)
365: and nvl(poh.frozen_flag, 'N') = 'N'
366: and nvl(poh.authorization_status, 'INCOMPLETE') IN
367: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 408: po_line_locations_all poll,

404: poh.revision_num,
405: poha.revision_num
406: FROM po_headers_all poh,
407: po_lines_all pol,
408: po_line_locations_all poll,
409: po_headers_archive_all poha,
410: financials_system_params_all fsp
411: WHERE pol.Contract_id = l_po_header_id
412: AND pol.from_header_id IS NULL

Line 420: FROM po_line_locations_all polt

416: AND poll.shipment_num =
417: (
418: SELECT
419: min(poll.shipment_num)
420: FROM po_line_locations_all polt
421: WHERE polt.po_line_id=pol.po_line_id
422: )
423: AND nvl(poh.frozen_flag, 'N') = 'N'
424: AND nvl(poh.authorization_status, 'INCOMPLETE') IN ('APPROVED', 'INCOMPLETE', 'REJECTED', 'REQUIRES REAPPROVAL')

Line 433: FROM po_line_locations_all poll1

429: AND not exists
430: (
431: SELECT
432: 'billed received shipments'
433: FROM po_line_locations_all poll1
434: WHERE poll1.po_line_id = pol.po_line_id
435: AND
436: (
437: (

Line 472: po_line_locations_all poll,

468: poh.revision_num,
469: poha.revision_num
470: FROM po_headers_all poh,
471: po_lines_all pol,
472: po_line_locations_all poll,
473: po_headers_archive_all poha,
474: po_document_types_all_b pdt,
475: financials_system_params_all fsp
476: WHERE pol.Contract_id = l_po_header_id

Line 493: FROM po_line_locations_all poll1

489: not exists
490: (
491: SELECT
492: 'billed received shipments'
493: FROM po_line_locations_all poll1
494: WHERE poll1.po_line_id = pol.po_line_id
495: AND
496: (
497: (

Line 510: FROM po_line_locations_all polt

506: AND poll.shipment_num =
507: (
508: SELECT
509: min(poll.shipment_num)
510: FROM po_line_locations_all polt
511: WHERE polt.po_line_id=pol.po_line_id
512: )
513: AND nvl(poh.frozen_flag, 'N') = 'N'
514: AND nvl(poh.authorization_status, 'INCOMPLETE') IN ('APPROVED', 'INCOMPLETE', 'REJECTED', 'REQUIRES REAPPROVAL')

Line 1120: * We need to update po_line_locations_all with

1116: -- Bulk Update
1117: l_module := g_log_head||l_api_name||'.'||
1118: '060'||'.';
1119: /* Bug 2718565.
1120: * We need to update po_line_locations_all with
1121: * time stamp since we process the Std POs
1122: * against GA in other operating units.
1123: */
1124: FORALL processed_index in

Line 1126: UPDATE po_line_locations_all

1122: * against GA in other operating units.
1123: */
1124: FORALL processed_index in
1125: 1..l_po_line_loc_table.COUNT
1126: UPDATE po_line_locations_all
1127: SET retroactive_date= l_retroactive_date_table(i),
1128: last_update_date = g_sysdate,
1129: last_updated_by = g_user_id
1130: WHERE line_location_id =

Line 1550: UPDATE po_line_locations_all

1546: '088'||'.';
1547:
1548: FORALL processed_index in
1549: 1..l_po_line_loc_table.COUNT
1550: UPDATE po_line_locations_all
1551: SET retroactive_date= l_retroactive_date_table(i),
1552: last_update_date = g_sysdate,
1553: last_updated_by = g_user_id
1554: WHERE line_location_id =

Line 1627: UPDATE po_line_locations_all

1623:
1624: l_module := g_log_head||l_api_name||'.'||'110'||'.';
1625: if l_temp_row_id_table.COUNT <> 0 then
1626: FORALL price_update_index in 1..l_temp_row_id_table.COUNT
1627: UPDATE po_line_locations_all
1628: SET price_override =
1629: l_temp_new_price_table(price_update_index),
1630: calculate_tax_flag = 'Y',
1631: manual_price_change_flag = 'N', --

Line 1672: UPDATE po_line_locations_all poll

1668: WHERE rowid =
1669: l_temp_row_id_table(price_update_index);
1670:
1671: FORALL price_update_index in 1..l_temp_row_id_table.COUNT
1672: UPDATE po_line_locations_all poll
1673: SET poll.price_override =
1674: l_temp_new_price_table(price_update_index),
1675: poll.calculate_tax_flag = 'Y',
1676: poll.last_update_date = g_sysdate,

Line 2171: UPDATE po_line_locations_all poll

2167: and nvl(authorization_status,'INCOMPLETE') = 'APPROVED';
2168:
2169: l_module := g_log_head||l_api_name||'.'||'030'||'.';
2170: FORALL ship_update_index in 1..l_row_id_table.COUNT
2171: UPDATE po_line_locations_all poll
2172: SET poll.approved_flag = 'R',
2173: poll.last_update_date = g_sysdate,
2174: poll.last_updated_by = g_user_id
2175: WHERE poll.po_line_id =

Line 2291: from po_line_locations_all

2287: IF p_global_agreement_flag = 'Y' THEN
2288:
2289: select po_line_id
2290: into l_po_line_id
2291: from po_line_locations_all
2292: where line_location_id = p_po_line_location_id ;
2293:
2294: l_std_po_price_change := 'Y';
2295:

Line 2305: from po_line_locations_all

2301:
2302: l_std_po_price_change := 'Y';
2303: select po_line_id
2304: into l_po_line_id
2305: from po_line_locations_all
2306: where line_location_id = p_po_line_location_id ;
2307:
2308:
2309: END IF;

Line 2435: FROM po_line_locations_all PLL, po_lines_all POL,

2431: l_vendor_site_id,
2432: l_uom,
2433: l_in_unit_price,
2434: l_currency_code
2435: FROM po_line_locations_all PLL, po_lines_all POL,
2436: po_headers_all POH
2437: WHERE PLL.line_location_id = p_po_line_location_id
2438: AND POL.po_line_id = PLL.po_line_id
2439: AND POH.po_header_id = POL.po_header_id;

Line 3286: UPDATE po_line_locations_all pll

3282: -- SQL Why : For Release, column po_line_locations.retroactive_date will
3283: -- be updated if any retroactive pricing changes, Reset it
3284: -- to the corresponding blanket line retroactive_date after
3285: -- processing retroactive pricing.
3286: UPDATE po_line_locations_all pll
3287: SET retroactive_date = (SELECT pl.retroactive_date
3288: FROM po_lines_all pl
3289: WHERE pl.po_line_id = pll.po_line_id),
3290: last_update_date = SYSDATE,

Line 3471: po_line_locations_all poll, --

3467: FROM po_headers poh,
3468: po_lines_all pol, --
3469: -- Bug 3393219, Consumption transaction owning org
3470: -- financials_system_parameters fsp,
3471: po_line_locations_all poll, --
3472: po_line_locations_archive_all polla, --
3473: po_distributions_all pod, --
3474: -- Bug 3314204, 3303148
3475: po_distributions_archive_all poda --

Line 3539: po_line_locations_all poll, --

3535: po_headers_all poh, --
3536: po_lines pol,
3537: -- Bug 3393219, Consumption transaction owning org
3538: -- financials_system_parameters fsp,
3539: po_line_locations_all poll, --
3540: po_line_locations_archive_all polla, --
3541: po_distributions_all pod, --
3542: -- Bug 3314204, 3303148
3543: po_distributions_archive poda

Line 4340: FROM PO_LINE_LOCATIONS_ALL pll,

4336: SELECT 'N'
4337: INTO l_retro_proj_allowed
4338: FROM DUAL
4339: WHERE EXISTS (SELECT 'has project information'
4340: FROM PO_LINE_LOCATIONS_ALL pll,
4341: PO_DISTRIBUTIONS_ALL pod
4342: WHERE pll.po_line_id = p_po_line_id
4343: AND pod.line_location_id = pll.line_location_id
4344: AND ((NVL(pll.quantity_received,0) > 0 AND

Line 4361: FROM PO_LINE_LOCATIONS_ALL pll,

4357: SELECT 'N'
4358: INTO l_retro_proj_allowed
4359: FROM DUAL
4360: WHERE EXISTS (SELECT 'has project information'
4361: FROM PO_LINE_LOCATIONS_ALL pll,
4362: PO_DISTRIBUTIONS_ALL pod
4363: WHERE pll.line_location_id = p_po_line_loc_id
4364: AND pod.line_location_id = pll.line_location_id
4365: AND ((NVL(pll.quantity_received,0) > 0 AND

Line 4448: from po_line_locations_all pll,

4444: NVL(poh.consigned_consumption_flag,'N'),
4445: pll.ship_to_organization_id,
4446: poh.org_id,
4447: pll.transaction_flow_header_id -- Bug 3880758
4448: from po_line_locations_all pll,
4449: -- Bug 3541961
4450: po_headers_all poh
4451: where pll.po_line_id = p_po_line_id
4452: -- Bug 3541961

Line 4463: from po_line_locations_all pll,

4459: NVL(por.consigned_consumption_flag,'N'),
4460: pll.ship_to_organization_id,
4461: por.org_id,
4462: null -- Bug 3880758
4463: from po_line_locations_all pll,
4464: -- Bug 3541961
4465: po_releases_all por
4466: where pll.line_location_id = p_po_line_loc_id
4467: -- Bug 3541961

Line 4691: FROM po_line_locations_all pll,

4687: CURSOR STD_PO_SHIPMENTS_CSR IS
4688: SELECT NVL(poh.consigned_consumption_flag, 'N'),
4689: pll.ship_to_organization_id,
4690: pll.transaction_flow_header_id
4691: FROM po_line_locations_all pll,
4692: po_headers_all poh
4693: WHERE pll.po_line_id = p_po_line_id
4694: AND pll.po_header_id = poh.po_header_id;
4695:

Line 4700: FROM po_line_locations_all pll,

4696: CURSOR REL_SHIPMENTS_CSR IS
4697: SELECT NVL(por.consigned_consumption_flag, 'N'),
4698: pll.ship_to_organization_id,
4699: NULL
4700: FROM po_line_locations_all pll,
4701: po_releases_all por
4702: WHERE pll.line_location_id = p_po_line_loc_id
4703: AND pll.po_release_id = por.po_release_id;
4704: