APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_PRD_DISPOSITIONS_B

Line 903: FROM AHL_PRD_DISPOSITIONS_b disp,

899: SEV.NAME SEVERITY_NAME,
900: INC.PROBLEM_CODE,
901: PCODE.MEANING PROBLEM_MEANING,
902: INCL.SUMMARY
903: FROM AHL_PRD_DISPOSITIONS_b disp,
904: AHL_PRD_DISPOSITIONS_tl displ,
905: AHL_MC_PATH_POSITIONS pp,
906: MTL_SYSTEM_ITEMS_KFV MTL,
907: CSI_ITEM_INSTANCES CSI,

Line 1049: FROM AHL_PRD_DISPOSITIONS_b disp,

1045: SEV.NAME SEVERITY_NAME,
1046: INC.PROBLEM_CODE,
1047: PCODE.MEANING PROBLEM_MEANING,
1048: INCL.SUMMARY
1049: FROM AHL_PRD_DISPOSITIONS_b disp,
1050: AHL_PRD_DISPOSITIONS_tl displ,
1051: AHL_MC_PATH_POSITIONS pp,
1052: CS_INCIDENTS_ALL_B INC,
1053: CS_INCIDENTS_ALL_TL INCL,

Line 1197: FROM AHL_PRD_DISPOSITIONS_b disp,

1193: SEV.NAME SEVERITY_NAME,
1194: INC.PROBLEM_CODE,
1195: PCODE.MEANING PROBLEM_MEANING,
1196: INCL.SUMMARY
1197: FROM AHL_PRD_DISPOSITIONS_b disp,
1198: AHL_PRD_DISPOSITIONS_tl displ,
1199: AHL_MC_PATH_POSITIONS pp,
1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,

Line 1572: FROM AHL_PRD_DISPOSITIONS_B B, FND_LOOKUPS FND1, FND_LOOKUPS FND2

1568: B.secondary_disposition_code,
1569: FND2.MEANING SECONDARY_TYPE,
1570: B.part_change_id,
1571: decode(B.instance_id, null, decode(B.path_position_id, null, 'N', 'Y'), 'Y') TRACKABLE_FLAG
1572: FROM AHL_PRD_DISPOSITIONS_B B, FND_LOOKUPS FND1, FND_LOOKUPS FND2
1573: WHERE FND1.LOOKUP_TYPE (+) = 'AHL_IMMED_DISP_TYPE'
1574: AND B.immediate_disposition_code = FND1.LOOKUP_CODE (+)
1575: AND FND2.LOOKUP_TYPE (+) = 'AHL_SECND_DISP_TYPE'
1576: AND B.SECONDARY_DISPOSITION_CODE = FND2.LOOKUP_CODE (+)

Line 1793: FROM AHL_PRD_DISPOSITIONS_B

1789: RETURN VARCHAR2
1790: IS
1791: CURSOR get_primary_sr_csr IS
1792: SELECT PRIMARY_SERVICE_REQUEST_ID
1793: FROM AHL_PRD_DISPOSITIONS_B
1794: WHERE DISPOSITION_ID = p_disposition_id;
1795:
1796: l_primary_sr_id NUMBER;
1797: l_return_value VARCHAR2(1);

Line 2296: from ahl_prd_dispositions_b

2292:
2293: --validate the input parameters
2294: BEGIN
2295: select 1 INTO l_dummy_num
2296: from ahl_prd_dispositions_b
2297: where disposition_id = p_disposition_id
2298: and nvl(status_code, ' ') <> 'TERMINATED';
2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN

Line 2488: FROM ahl_prd_dispositions_b disp,

2484: pc.part_change_type,
2485: pc.removed_instance_id,
2486: pc.mc_relationship_id,
2487: pc.creation_date pc_creation_date
2488: FROM ahl_prd_dispositions_b disp,
2489: ahl_part_changes pc
2490: WHERE disp.part_change_id = pc.part_change_id;
2491: l_pc_dtls get_curr_pc_dtls%ROWTYPE;
2492: