DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 1723: po_lines_archive_all pla,

1719: pcr.request_reason REASON,
1720: null SPLIT
1721: from
1722: po_change_requests pcr,
1723: po_lines_archive_all pla,
1724: mtl_system_items_kfv msi,
1725: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1726: where pla.po_line_id = pcr.document_line_id
1727: and pcr.change_request_group_id =grp_id

Line 1763: po_lines_archive_all pla,

1759: pcr.REQUEST_REASON REASON,
1760: null SPLIT
1761: from
1762: po_change_requests pcr,
1763: po_lines_archive_all pla,
1764: po_line_locations_archive_all plla,
1765: hr_locations_all hla, hz_locations hz,
1766: mtl_system_items_kfv msi,
1767: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 1809: po_lines_archive_all pla,

1805: pcr.REQUEST_REASON REASON,
1806: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
1807: from
1808: po_change_requests pcr,
1809: po_lines_archive_all pla,
1810: po_line_locations_archive_all plla,
1811: hr_locations_all hla, hz_locations hz,
1812: mtl_system_items_kfv msi,
1813: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 2556: po_lines_archive_all pla,

2552: pcr.request_reason REASON,
2553: null SPLIT
2554: from
2555: po_change_requests pcr,
2556: po_lines_archive_all pla,
2557: mtl_system_items_kfv msi,
2558: mtl_planners mtp,
2559: financials_system_params_all fsp
2560: where pla.po_line_id = pcr.document_line_id

Line 2598: po_lines_archive_all pla,

2594: pcr.REQUEST_REASON REASON,
2595: null SPLIT
2596: from
2597: po_change_requests pcr,
2598: po_lines_archive_all pla,
2599: po_line_locations_archive_all plla,
2600: hr_locations_all hla, hz_locations hz,
2601: mtl_system_items_kfv msi,
2602: mtl_planners mtp,

Line 2647: po_lines_archive_all pla,

2643: pcr.REQUEST_REASON REASON,
2644: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
2645: from
2646: po_change_requests pcr,
2647: po_lines_archive_all pla,
2648: po_line_locations_archive_all plla,
2649: hr_locations_all hla, hz_locations hz,
2650: mtl_system_items_kfv msi,
2651: mtl_planners mtp,

Line 3381: po_lines_archive_all pla,

3377: pcr.request_reason REASON,
3378: null SPLIT
3379: from
3380: po_change_requests pcr,
3381: po_lines_archive_all pla,
3382: mtl_system_items_kfv msi,
3383: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3384: where pla.po_line_id = pcr.document_line_id
3385: and pcr.change_request_group_id =grp_id

Line 3418: po_lines_archive_all pla,

3414: pcr.REQUEST_REASON REASON,
3415: null SPLIT
3416: from
3417: po_change_requests pcr,
3418: po_lines_archive_all pla,
3419: po_line_locations_archive_all plla,
3420: hr_locations_all hla, hz_locations hz,
3421: mtl_system_items_kfv msi,
3422: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 3461: po_lines_archive_all pla,

3457: pcr.REQUEST_REASON REASON,
3458: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
3459: from
3460: po_change_requests pcr,
3461: po_lines_archive_all pla,
3462: po_line_locations_archive_all plla,
3463: hr_locations_all hla, hz_locations hz,
3464: mtl_system_items_kfv msi,
3465: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 3523: po_lines_archive_all pla,

3519: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
3520: pa.note NOTE
3521: from
3522: po_acceptances pa,
3523: po_lines_archive_all pla,
3524: po_line_locations_archive_all plla,
3525: hr_locations_all hla, hz_locations hz,
3526: mtl_system_items_kfv msi,
3527: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 3566: po_lines_archive_all pla,

3562: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
3563: pa.NOTE NOTE
3564: from
3565: po_acceptances pa,
3566: po_lines_archive_all pla,
3567: po_line_locations_archive_all plla,
3568: hr_locations_all hla, hz_locations hz,
3569: mtl_system_items_kfv msi,
3570: FINANCIALS_SYSTEM_PARAMS_ALL FSP

Line 4449: from po_change_requests pcr, po_lines_archive_all pla

4445: null SHIP_TO_LOCATION,
4446: pcr.response_reason REASON,
4447: null SPLIT,
4448: pcr.action_type ACTION_CODE
4449: from po_change_requests pcr, po_lines_archive_all pla
4450: where pla.po_line_id = pcr.document_line_id
4451: and pcr.change_request_group_id =grp_id
4452: --and pcr.document_revision_num = pla.revision_num
4453: and pcr.request_level = 'LINE'

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

4473: pcr.response_reason REASON,
4474: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4475: pcr.action_type ACTION_CODE
4476:
4477: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4478: hr_locations_all hla, hz_locations hz
4479: where change_request_group_id =grp_id
4480: and pla.po_line_id = pcr.document_line_id
4481: and pla.latest_external_flag = 'Y'

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

4508: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
4509: pcr.response_reason REASON,
4510: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT,
4511: pcr.action_type ACTION_CODE
4512: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla,
4513: hr_locations_all hla, hz_locations hz
4514: where change_request_group_id =grp_id
4515: and pla.po_line_id = pcr.document_line_id
4516: and pla.latest_external_flag = 'Y'