DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MTL_ABC_CLASSES

Line 539: MTL_ABC_CLASSES

535: SELECT
536: ABC_CLASS_NAME
537: INTO ABC_CLASS
538: FROM
539: MTL_ABC_CLASSES
540: WHERE ABC_CLASS_ID = P_ABC_CLASS
541: AND ORGANIZATION_ID = P_ORG_ID;
542: END IF;
543: RETURN (ABC_CLASS);

Line 769: ABC_FROM := 'mtl_abc_assignments abc, mtl_abc_classes abc_cls, ';

765: DECLARE
766: ABC_FROM VARCHAR2(80):=' ';
767: BEGIN
768: IF ((P_ABC_CLASS IS NOT NULL) OR (P_FIRST_SORT = 6) OR (P_SECOND_SORT = 6) OR (P_THIRD_SORT = 6)) THEN
769: ABC_FROM := 'mtl_abc_assignments abc, mtl_abc_classes abc_cls, ';
770: ELSIF (P_ABC_ASSGN IS NOT NULL) THEN
771: ABC_FROM := 'mtl_abc_assignments abc,';
772: END IF;
773: RETURN (ABC_FROM);