DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 198: FROM ahl_rt_oper_materials

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

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

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

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

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