DBA Data[Home] [Help]

APPS.AHL_PRD_OPERATIONS_PVT dependencies on MTL_PARAMETERS

Line 775: MTL_PARAMETERS b

771: CURSOR get_completion_sub_inv(c_com_subinv VARCHAR2,c_inventory_item_id NUMBER)
772: IS
773: SELECT a.Secondary_inventory
774: FROM MTL_ITEM_SUB_INVENTORIES a,
775: MTL_PARAMETERS b
776: WHERE a.Secondary_inventory=c_com_subinv
777: AND a.organization_id=b.organization_id
778: AND a.inventory_item_id=c_inventory_item_id;
779:

Line 990: MTL_PARAMETERS B

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;
994: