DBA Data[Home] [Help]

APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 1201: ahl_prd_dispositions_b dis

1197: into l_prob_attrib_c_tmp
1198: from (Select chg.removed_instance_id
1199: from ahl_part_changes chg,
1200: csi_item_instances cii,
1201: ahl_prd_dispositions_b dis
1202: where chg.part_change_type IN ('R','S')
1203: and chg.part_change_id = dis.part_change_id
1204: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')
1205: and dis.condition_id in (Select Status_Id from AHL_RA_SETUPS where setup_code = 'ITEM_STATUS')

Line 1240: ahl_prd_dispositions_b dis

1236: and cb1.CREATED_FROM_COUNTER_TMPL_ID = cb2.CREATED_FROM_COUNTER_TMPL_ID
1237: and cv.counter_id = cb2.counter_id
1238: AND cv.disabled_flag = 'N') ctr,
1239: csi_item_instances cii,
1240: ahl_prd_dispositions_b dis
1241: where chg.part_change_type IN ('R','S')
1242: and chg.part_change_id = dis.part_change_id
1243: AND chg.removed_instance_id = ctr.source_object_id
1244: and chg.removal_code in (Select Removal_Code from AHL_RA_SETUPS where setup_code = 'REMOVAL_CODE')