APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 200: FROM ahl_rt_oper_materials

196: CURSOR get_mtl_req_flags(c_rt_oper_material_id NUMBER) IS
197: SELECT --'N' include_flag, Once the column include_flag is added, then replace 'N' with it.
198: --Refer enhancement bug 3502592
199: exclude_flag
200: FROM ahl_rt_oper_materials
201: WHERE rt_oper_material_id = c_rt_oper_material_id;
202: l_mtl_req_flags get_mtl_req_flags%ROWTYPE;
203: CURSOR check_item_org(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
204: SELECT 'X'

Line 605: --We may need to get the item_revision from ahl_rt_oper_materials later

601: X_PRIMARY_SERVICE_REQUEST_ID => NULL,
602: X_NON_ROUTINE_WORKORDER_ID => NULL,
603: X_WO_OPERATION_ID => NULL,
604: X_ITEM_REVISION => NULL,
605: --We may need to get the item_revision from ahl_rt_oper_materials later
606: X_ATTRIBUTE_CATEGORY => NULL,
607: X_ATTRIBUTE1 => NULL,
608: X_ATTRIBUTE2 => NULL,
609: X_ATTRIBUTE3 => NULL,

Line 658: --We may need to get the item_revision from ahl_rt_oper_materials later

654: X_PRIMARY_SERVICE_REQUEST_ID => NULL,
655: X_NON_ROUTINE_WORKORDER_ID => NULL,
656: X_WO_OPERATION_ID => NULL,
657: X_ITEM_REVISION => NULL,
658: --We may need to get the item_revision from ahl_rt_oper_materials later
659: X_ATTRIBUTE_CATEGORY => NULL,
660: X_ATTRIBUTE1 => NULL,
661: X_ATTRIBUTE2 => NULL,
662: X_ATTRIBUTE3 => NULL,