DBA Data[Home] [Help]

APPS.MRP_MRPRPLOR_XMLP_PKG dependencies on MTL_ABC_CLASSES

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

103: DECLARE
104: ABC_FROM VARCHAR2(80);
105: BEGIN
106: IF (P_ABC_ASSGN IS NOT NULL) OR ((P_ABC_CLASS IS NOT NULL) OR (P_SORT = 6)) THEN
107: ABC_FROM := ',mtl_abc_assignments abc' || ',mtl_abc_classes abc_cls';
108: ELSE
109: ABC_FROM := ' ';
110: END IF;
111: RETURN (ABC_FROM);

Line 268: MTL_ABC_CLASSES

264: SELECT
265: ABC_CLASS_NAME
266: INTO ABC_CLASS
267: FROM
268: MTL_ABC_CLASSES
269: WHERE ABC_CLASS_ID = P_ABC_CLASS
270: AND ORGANIZATION_ID = P_ORG_ID;
271: END IF;
272: RETURN (ABC_CLASS);