DBA Data[Home] [Help]

APPS.PO_ASL_SV dependencies on MTL_SYSTEM_ITEMS_KFV

Line 876: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

872: l_item_id PO_APPROVED_SUPPLIER_LIST.item_id%TYPE;
873: l_vendor_name PO_VENDORS.vendor_name%TYPE;
874: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
875: l_category_name MTL_CATEGORIES_KFV.concatenated_segments%TYPE;
876: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
877:
878: BEGIN
879: l_progress := '000';
880:

Line 910: mtl_system_items_kfv MSI,

906: mtl_parameters MP,
907: mtl_manufacturers MM,
908: po_vendors PV,
909: po_vendor_sites_all PVS,
910: mtl_system_items_kfv MSI,
911: mtl_categories_kfv MC
912: WHERE PASL.asl_id = p_asl_id
913: AND PASL.using_organization_id = MP.organization_id (+)
914: AND PASL.manufacturer_id = MM.manufacturer_id (+)