APPS.AZW_REPORT dependencies on AZ_PRODUCT_PHASES_V

Line 2396: FROM az_product_phases_v

2392: PROCEDURE implementation_param_page IS
2393:
2394: CURSOR valid_phases_cursor IS
2395: SELECT DISTINCT phase
2396: FROM az_product_phases_v
2397: ORDER BY phase;
2398:
2399: BEGIN
2400: IF (g_web_agent IS NULL) THEN

Line 2464: FROM az_product_phases_v

2460: v_phase NUMBER;
2461:
2462: CURSOR valid_phases_cursor IS
2463: SELECT DISTINCT phase
2464: FROM az_product_phases_v
2465: ORDER BY phase;
2466:
2467: CURSOR hierarchies_cursor(x_phase NUMBER) IS
2468: SELECT phase,

Line 2950: FROM az_product_phases_v appv

2946: CURSOR all_phases IS
2947: SELECT DISTINCT appv.phase,
2948: appv.application_short_name short_name,
2949: appv.application_name name
2950: FROM az_product_phases_v appv
2951: ORDER BY 1, 3;
2952:
2953: CURSOR per_phase(x_phase NUMBER) IS
2954: SELECT DISTINCT appv.phase,

Line 2957: FROM az_product_phases_v appv

2953: CURSOR per_phase(x_phase NUMBER) IS
2954: SELECT DISTINCT appv.phase,
2955: appv.application_short_name short_name,
2956: appv.application_name name
2957: FROM az_product_phases_v appv
2958: WHERE appv.phase = x_phase
2959: ORDER BY 1, 3;
2960:
2961: product_rec all_phases%ROWTYPE;

Line 2962: v_prev_phase az_product_phases_v.phase%TYPE;

2958: WHERE appv.phase = x_phase
2959: ORDER BY 1, 3;
2960:
2961: product_rec all_phases%ROWTYPE;
2962: v_prev_phase az_product_phases_v.phase%TYPE;
2963: v_count PLS_INTEGER;
2964: v_locator PLS_INTEGER := 0;
2965: BEGIN
2966: -- Print the Table header

Line 3057: v_prev_phase az_product_phases_v.phase%TYPE;

3053: PROCEDURE print_planning_reports_summary (p_phase IN VARCHAR2) IS
3054:
3055: process_groups PlanProcessGroups;
3056:
3057: v_prev_phase az_product_phases_v.phase%TYPE;
3058: v_count PLS_INTEGER;
3059: v_display_data VARCHAR2(500);
3060: v_locator PLS_INTEGER := 0;
3061: BEGIN

Line 3788: FROM az_product_phases_v appv

3784:
3785: CURSOR installed_products IS
3786: SELECT distinct application_short_name short_name,
3787: application_name name
3788: FROM az_product_phases_v appv
3789: ORDER BY 1;
3790:
3791: product_rec installed_products%ROWTYPE;
3792: v_count PLS_INTEGER;