DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on MTL_PLANNERS

Line 2408: mtl_planners mtp,

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
2411: and pcr.change_request_group_id =grp_id
2412: and pcr.request_level = 'LINE'

Line 2452: mtl_planners mtp,

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
2454: where pcr.change_request_group_id =grp_id
2455: and pla.po_line_id = pcr.document_line_id
2456: and pla.latest_external_flag = 'Y'

Line 2501: mtl_planners mtp,

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
2503: where pcr.change_request_group_id =grp_id
2504: and pla.po_line_id = pcr.document_line_id
2505: and pla.latest_external_flag = 'Y'

Line 7468: mtl_planners mtp,

7464: select
7465: distinct mtp.employee_id
7466: from
7467: mtl_system_items msi,
7468: mtl_planners mtp,
7469: po_change_requests pcr,
7470: po_lines_all pla,
7471: financials_system_params_all fsp
7472: where pcr.change_request_group_id = grp_id