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_CHANGEORDERWF_PVT dependencies on PO_LINE_LOCATIONS

Line 557: from po_line_locations_all

553: from po_headers_all
554: where po_header_id = p_can_hdr_id;
555: else
556: select cancel_flag into l_cancel_flag
557: from po_line_locations_all
558: where line_location_id = p_can_line_loc_id;
559: end if;
560: update po_headers_all
561: set authorization_status = 'IN PROCESS'

Line 570: from po_line_locations_all

566: from po_releases_all
567: where po_release_id = p_can_rel_id;
568: else
569: select cancel_flag into l_cancel_flag
570: from po_line_locations_all
571: where line_location_id = p_can_line_loc_id;
572: end if;
573:
574: update po_releases_all

Line 1620: po_line_locations_archive_all plla,

1616: null SPLIT
1617: from
1618: po_change_requests pcr,
1619: po_lines_archive_all pla,
1620: po_line_locations_archive_all plla,
1621: hr_locations_all hla, hz_locations hz,
1622: mtl_system_items_kfv msi,
1623: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1624: where pcr.change_request_group_id =grp_id

Line 1666: po_line_locations_archive_all plla,

1662: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
1663: from
1664: po_change_requests pcr,
1665: po_lines_archive_all pla,
1666: po_line_locations_archive_all plla,
1667: hr_locations_all hla, hz_locations hz,
1668: mtl_system_items_kfv msi,
1669: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1670: where pcr.change_request_group_id =grp_id

Line 2449: po_line_locations_archive_all plla,

2445: null SPLIT
2446: from
2447: po_change_requests pcr,
2448: po_lines_archive_all pla,
2449: po_line_locations_archive_all plla,
2450: hr_locations_all hla, hz_locations hz,
2451: mtl_system_items_kfv msi,
2452: mtl_planners mtp,
2453: financials_system_params_all fsp

Line 2498: po_line_locations_archive_all plla,

2494: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
2495: from
2496: po_change_requests pcr,
2497: po_lines_archive_all pla,
2498: po_line_locations_archive_all plla,
2499: hr_locations_all hla, hz_locations hz,
2500: mtl_system_items_kfv msi,
2501: mtl_planners mtp,
2502: financials_system_params_all fsp

Line 3267: po_line_locations_archive_all plla,

3263: null SPLIT
3264: from
3265: po_change_requests pcr,
3266: po_lines_archive_all pla,
3267: po_line_locations_archive_all plla,
3268: hr_locations_all hla, hz_locations hz,
3269: mtl_system_items_kfv msi,
3270: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3271: where pcr.change_request_group_id =grp_id

Line 3310: po_line_locations_archive_all plla,

3306: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
3307: from
3308: po_change_requests pcr,
3309: po_lines_archive_all pla,
3310: po_line_locations_archive_all plla,
3311: hr_locations_all hla, hz_locations hz,
3312: mtl_system_items_kfv msi,
3313: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3314: where pcr.change_request_group_id =grp_id

Line 3372: po_line_locations_archive_all plla,

3368: pa.note NOTE
3369: from
3370: po_acceptances pa,
3371: po_lines_archive_all pla,
3372: po_line_locations_archive_all plla,
3373: hr_locations_all hla, hz_locations hz,
3374: mtl_system_items_kfv msi,
3375: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3376: where plla.po_header_id = l_po_document_id

Line 3385: from po_line_locations_archive_all plla2

3381: --and plla.latest_external_flag = 'Y'
3382: and pla.latest_external_flag = 'Y'
3383: and pa.revision_num = l_rev
3384: and plla.revision_num = (select max(revision_num)
3385: from po_line_locations_archive_all plla2
3386: where plla2.line_location_id = plla.line_location_id and
3387: plla.revision_num <= l_rev)
3388: and msi.inventory_item_id(+) = pla.item_id
3389: --and msi.organization_id(+) = pla.org_id

Line 3415: po_line_locations_archive_all plla,

3411: pa.NOTE NOTE
3412: from
3413: po_acceptances pa,
3414: po_lines_archive_all pla,
3415: po_line_locations_archive_all plla,
3416: hr_locations_all hla, hz_locations hz,
3417: mtl_system_items_kfv msi,
3418: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3419: where plla.po_release_id = l_rel_document_id

Line 3428: from po_line_locations_archive_all plla2

3424: --and plla.latest_external_flag = 'Y'
3425: and pla.latest_external_flag = 'Y'
3426: and pa.revision_num = l_rev
3427: and plla.revision_num = (select max(revision_num)
3428: from po_line_locations_archive_all plla2
3429: where plla2.line_location_id = plla.line_location_id and
3430: plla.revision_num <= l_rev)
3431: and msi.inventory_item_id(+) = pla.item_id
3432: --and msi.organization_id(+) = pla.org_id

Line 4325: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,

4321: pcr.response_reason REASON,
4322: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4323: pcr.action_type ACTION_CODE
4324:
4325: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4326: hr_locations_all hla, hz_locations hz
4327: where change_request_group_id =grp_id
4328: and pla.po_line_id = pcr.document_line_id
4329: and pla.latest_external_flag = 'Y'

Line 4360: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,

4356: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
4357: pcr.response_reason REASON,
4358: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4359: pcr.action_type ACTION_CODE
4360: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4361: hr_locations_all hla, hz_locations hz
4362: where change_request_group_id =grp_id
4363: and pla.po_line_id = pcr.document_line_id
4364: and pla.latest_external_flag = 'Y'

Line 6445: from po_line_locations

6441:
6442: if (l_document_type in ('PO', 'PA')) then
6443: select max(need_by_date)+180
6444: into l_expiration_date
6445: from po_line_locations
6446: where po_header_id = to_number(l_document_id)
6447: and cancel_flag = 'N';
6448:
6449: if l_expiration_date <= sysdate then

Line 6455: from po_line_locations

6451: end if;
6452: elsif (l_document_type = 'RELEASE') then
6453: select max(need_by_date)+180
6454: into l_expiration_date
6455: from po_line_locations
6456: where po_release_id = to_number(l_document_id)
6457: and cancel_flag = 'N';
6458:
6459: if l_expiration_date <= sysdate then

Line 7339: update po_line_locations_all

7335: -- Bug 3771964
7336:
7337: if (l_rej_id is not null) then
7338: if (p_release_id is null) then
7339: update po_line_locations_all
7340: set approved_flag = 'Y'
7341: where po_header_id=p_header_id
7342: and po_release_id is null;
7343: else

Line 7344: update po_line_locations_all

7340: set approved_flag = 'Y'
7341: where po_header_id=p_header_id
7342: and po_release_id is null;
7343: else
7344: update po_line_locations_all
7345: set approved_flag = 'Y'
7346: where po_header_id=p_header_id
7347: and po_release_id = p_release_id;
7348: end if;

Line 7447: po_line_locations_all pll

7443: select pda.deliver_to_person_id
7444: from
7445: po_change_requests pcr,
7446: po_distributions_all pda,
7447: po_line_locations_all pll
7448: where pcr.change_request_group_id = grp_id
7449: and pcr.request_level = 'LINE'
7450: and pcr.document_line_id = pda.po_line_id
7451: and pda.line_location_id = pll.line_location_id

Line 7638: po_line_locations_all poll

7634: select distinct porh.requisition_header_id
7635: from po_requisition_headers_all porh,
7636: po_requisition_lines_all porl,
7637: po_headers_all poh,
7638: po_line_locations_all poll
7639: where porh.requisition_header_id = porl.requisition_header_id AND
7640: porl.line_location_id = poll.line_location_id AND
7641: poh.po_header_id = poll.po_header_id AND
7642: poh.po_header_id = p_po_header_id_csr;

Line 8097: po_line_locations_all polla

8093: IS
8094: CURSOR getReqHdrId(c_po_header_id in NUMBER) IS
8095: select distinct(porla.requisition_header_id)
8096: from po_requisition_lines_all porla,
8097: po_line_locations_all polla
8098: where polla.po_header_id = c_po_header_id
8099: and porla.line_location_id = polla.line_location_id;
8100:
8101: CURSOR getReqNum(c_req_header_id in NUMBER) IS

Line 8110: po_line_locations_all polla

8106: -- for releases
8107: CURSOR getReqHdrId_rel(c_po_header_id in NUMBER, c_po_release_id in NUMBER) IS
8108: select distinct(porla.requisition_header_id)
8109: from po_requisition_lines_all porla,
8110: po_line_locations_all polla
8111: where polla.po_header_id = c_po_header_id
8112: and polla.po_release_id = c_po_release_id
8113: and porla.line_location_id = polla.line_location_id;
8114:

Line 8216: FROM po_line_locations_all poll1,

8212: INTO l_ship_invalid_for_ctrl_actn
8213: FROM DUAL
8214: WHERE EXISTS(
8215: SELECT 1
8216: FROM po_line_locations_all poll1,
8217: po_line_locations_all poll2
8218: WHERE poll1.line_location_id = po_line_location_id
8219: AND poll1.po_line_id = poll2.po_line_id
8220: AND NVL(poll2.cancel_flag,'N') <> 'Y'

Line 8217: po_line_locations_all poll2

8213: FROM DUAL
8214: WHERE EXISTS(
8215: SELECT 1
8216: FROM po_line_locations_all poll1,
8217: po_line_locations_all poll2
8218: WHERE poll1.line_location_id = po_line_location_id
8219: AND poll1.po_line_id = poll2.po_line_id
8220: AND NVL(poll2.cancel_flag,'N') <> 'Y'
8221: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --