DBA Data[Home] [Help]

APPS.PO_CHANGEORDERWF_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1517: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;

1513:
1514: /*varchar Variables for creating the notification*/
1515: lc_line_num varchar2(2000);
1516: lc_ship_num varchar2(2000);
1517: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
1518: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
1519: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
1520: lc_old_prom_date varchar2(2000);
1521: lc_new_prom_date varchar2(2000);

Line 1580: mtl_system_items_kfv msi,

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
1584: and pcr.request_level = 'LINE'

Line 1622: mtl_system_items_kfv msi,

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
1625: and pla.po_line_id = pcr.document_line_id
1626: and pla.latest_external_flag = 'Y'

Line 1668: mtl_system_items_kfv msi,

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
1671: and pla.po_line_id = pcr.document_line_id
1672: and pla.latest_external_flag = 'Y'

Line 2340: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;

2336: /*varchar Variables for creating the notification*/
2337: lc_change_id number;
2338: lc_line_num varchar2(2000);
2339: lc_ship_num varchar2(2000);
2340: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
2341: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
2342: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
2343: lc_old_prom_date varchar2(2000);
2344: lc_new_prom_date varchar2(2000);

Line 2407: mtl_system_items_kfv msi,

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

Line 2451: mtl_system_items_kfv msi,

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

Line 2500: mtl_system_items_kfv msi,

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

Line 3164: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;

3160:
3161: /*varchar Variables for creating the notification*/
3162: /* lc_line_num varchar2(2000);
3163: lc_ship_num varchar2(2000);
3164: lc_buyer_pt_num mtl_system_items_kfv.concatenated_segments%TYPE;
3165: lc_old_sup_pt_num po_lines_all.vendor_product_num%TYPE;
3166: lc_new_sup_pt_num po_change_requests.new_supplier_part_number%TYPE;
3167: lc_old_prom_date date;
3168: lc_new_prom_date date;

Line 3230: mtl_system_items_kfv msi,

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
3234: and pcr.request_level = 'LINE'

Line 3269: mtl_system_items_kfv msi,

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
3272: and pla.po_line_id = pcr.document_line_id
3273: and pla.latest_external_flag = 'Y'

Line 3312: mtl_system_items_kfv msi,

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
3315: and pla.po_line_id = pcr.document_line_id
3316: and pla.latest_external_flag = 'Y'

Line 3374: mtl_system_items_kfv msi,

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
3377: and plla.po_line_id = pla.po_line_id
3378: and pa.po_line_location_id = plla.line_location_id

Line 3417: mtl_system_items_kfv msi,

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
3420: and plla.po_line_id = pla.po_line_id
3421: and pa.po_line_location_id = plla.line_location_id