DBA Data[Home] [Help]

APPS.MRP_MRPRPRSC_XMLP_PKG dependencies on MTL_ABC_CLASSES

Line 135: ABC_FROM := ', mtl_abc_assignments abc' || ',mtl_abc_classes abc_cls';

131: DECLARE
132: ABC_FROM VARCHAR2(80);
133: BEGIN
134: IF (P_ABC_ASSGN IS NOT NULL) OR ((P_ABC_CLASS IS NOT NULL) OR (P_SORT = 7)) THEN
135: ABC_FROM := ', mtl_abc_assignments abc' || ',mtl_abc_classes abc_cls';
136: ELSE
137: ABC_FROM := ' ';
138: END IF;
139: RETURN (ABC_FROM);

Line 505: MTL_ABC_CLASSES

501: SELECT
502: ABC_CLASS_NAME
503: INTO ABC_CLASS
504: FROM
505: MTL_ABC_CLASSES
506: WHERE ABC_CLASS_ID = P_ABC_CLASS
507: AND ORGANIZATION_ID = P_ORG_ID;
508: END IF;
509: RETURN (ABC_CLASS);