DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 1579: po_lines_archive_all pla,

1575: pcr.request_reason REASON,
1576: null SPLIT
1577: from
1578: po_change_requests pcr,
1579: po_lines_archive_all pla,
1580: mtl_system_items_kfv msi,
1581: FINANCIALS_SYSTEM_PARAMS_ALL FSP
1582: where pla.po_line_id = pcr.document_line_id
1583: and pcr.change_request_group_id =grp_id

Line 1619: po_lines_archive_all pla,

1615: pcr.REQUEST_REASON REASON,
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

Line 1665: po_lines_archive_all pla,

1661: pcr.REQUEST_REASON REASON,
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

Line 2406: po_lines_archive_all pla,

2402: pcr.request_reason REASON,
2403: null SPLIT
2404: from
2405: po_change_requests pcr,
2406: po_lines_archive_all pla,
2407: mtl_system_items_kfv msi,
2408: mtl_planners mtp,
2409: financials_system_params_all fsp
2410: where pla.po_line_id = pcr.document_line_id

Line 2448: po_lines_archive_all pla,

2444: pcr.REQUEST_REASON REASON,
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,

Line 2497: po_lines_archive_all pla,

2493: pcr.REQUEST_REASON REASON,
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,

Line 3229: po_lines_archive_all pla,

3225: pcr.request_reason REASON,
3226: null SPLIT
3227: from
3228: po_change_requests pcr,
3229: po_lines_archive_all pla,
3230: mtl_system_items_kfv msi,
3231: FINANCIALS_SYSTEM_PARAMS_ALL FSP
3232: where pla.po_line_id = pcr.document_line_id
3233: and pcr.change_request_group_id =grp_id

Line 3266: po_lines_archive_all pla,

3262: pcr.REQUEST_REASON REASON,
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

Line 3309: po_lines_archive_all pla,

3305: pcr.REQUEST_REASON REASON,
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

Line 3371: po_lines_archive_all pla,

3367: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
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

Line 3414: po_lines_archive_all pla,

3410: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
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

Line 4297: from po_change_requests pcr, po_lines_archive_all pla

4293: null SHIP_TO_LOCATION,
4294: pcr.response_reason REASON,
4295: null SPLIT,
4296: pcr.action_type ACTION_CODE
4297: from po_change_requests pcr, po_lines_archive_all pla
4298: where pla.po_line_id = pcr.document_line_id
4299: and pcr.change_request_group_id =grp_id
4300: --and pcr.document_revision_num = pla.revision_num
4301: and pcr.request_level = 'LINE'

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'