DBA Data[Home] [Help]

APPS.PO_ASL_API_PUB dependencies on MTL_MANUFACTURERS

Line 1405: FROM mtl_manufacturers mm

1401:
1402: UPDATE po_approved_supplier_list_gt past
1403: SET past.manufacturer_id =
1404: (SELECT mm.manufacturer_id
1405: FROM mtl_manufacturers mm
1406: WHERE mm.manufacturer_name = past.manufacturer_dsp
1407: AND ROWNUM < 2)
1408: WHERE past.manufacturer_dsp IS NOT NULL;
1409: l_progress := 40;

Line 1454: mtl_manufacturers mm,

1450: UPDATE po_approved_supplier_list_gt asl1
1451: SET asl1.manufacturer_asl_id =
1452: (SELECT pasl.asl_id
1453: FROM po_approved_supplier_list pasl,
1454: mtl_manufacturers mm,
1455: po_asl_statuses past,
1456: po_asl_status_rules psr
1457: WHERE pasl.manufacturer_id = mm.manufacturer_id
1458: AND pasl.asl_status_id = past.status_id