DBA Data[Home] [Help]

APPS.AHL_PRD_OPERATIONS_PVT dependencies on BOM_DEPARTMENTS

Line 754: FROM BOM_DEPARTMENTS A

750: IS
751: SELECT A.Department_id,
752: A.department_code,
753: A.description
754: FROM BOM_DEPARTMENTS A
755: WHERE UPPER(A.description) LIKE UPPER(c_department_name)
756: AND A.organization_id=c_org_id;
757:
758: l_dept_rec get_department%ROWTYPE;

Line 987: FROM BOM_DEPARTMENTS A,

983:
984: CURSOR validate_department(c_dept_id NUMBER,c_org_id NUMBER)
985: IS
986: SELECT B.eam_enabled_flag
987: FROM BOM_DEPARTMENTS A,
988: MTL_PARAMETERS B
989: WHERE A.department_id=c_dept_id
990: AND A.organization_id=B.organization_id
991: AND A.organization_id=c_org_id;