DBA Data[Home] [Help]

APPS.AHL_PRD_OPERATIONS_PVT dependencies on BOM_DEPARTMENTS

Line 756: FROM BOM_DEPARTMENTS A

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

Line 989: FROM BOM_DEPARTMENTS A,

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