APPS.PA_FORECASTITEM_PVT dependencies on PA_FORECAST_ITEM_DETAILS

Line 2571: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

2567: org_util_category_id_tab, resource_util_weighted_tab,
2568: org_util_weighted_tab, provisional_flag_tab,
2569: reversed_flag_tab, net_zero_flag_tab,
2570: reduce_capacity_flag_tab, line_num_reversed_tab
2571: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
2572: WHERE hdr.assignment_id = p_assignment_id
2573: AND hdr.delete_flag = 'N'
2574: AND dtl.forecast_item_id = hdr.forecast_item_id
2575: AND (dtl.item_date < trunc(p_start_date)

Line 2579: FROM pa_forecast_item_details dtl1

2575: AND (dtl.item_date < trunc(p_start_date)
2576: OR dtl.item_date > trunc(p_end_date) + 1 - (1/86400))
2577: AND dtl.line_num =
2578: (SELECT max(line_num)
2579: FROM pa_forecast_item_details dtl1
2580: WHERE dtl1.forecast_item_id = hdr.forecast_item_id)
2581: order by dtl.item_date, dtl.forecast_item_id ;
2582:
2583: IF nvl(forecast_item_id_tab.count,0) = 0 THEN

Line 3324: FROM pa_forecast_item_details dtl , pa_forecast_items hdr

3320: org_util_category_id_tab, resource_util_weighted_tab,
3321: org_util_weighted_tab, provisional_flag_tab,
3322: reversed_flag_tab, net_zero_flag_tab,
3323: reduce_capacity_flag_tab, line_num_reversed_tab
3324: FROM pa_forecast_item_details dtl , pa_forecast_items hdr
3325: WHERE hdr.assignment_id = p_assignment_id
3326: AND hdr.delete_flag = 'N'
3327: AND dtl.forecast_item_id = hdr.forecast_item_id
3328: AND dtl.item_date BETWEEN trunc(p_start_date) AND

Line 3332: FROM pa_forecast_item_details dtl1

3328: AND dtl.item_date BETWEEN trunc(p_start_date) AND
3329: trunc(p_end_date) + 1 - (1/86400)
3330: AND dtl.line_num =
3331: (SELECT max(line_num)
3332: FROM pa_forecast_item_details dtl1
3333: WHERE dtl1.forecast_item_id = hdr.forecast_item_id)
3334: order by dtl.item_date, dtl.forecast_item_id ;
3335:
3336: IF nvl(forecast_item_id_tab.COUNT,0) = 0 THEN

Line 6381: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

6377: org_util_category_id_tab, resource_util_weighted_tab,
6378: org_util_weighted_tab, provisional_flag_tab,
6379: reversed_flag_tab, net_zero_flag_tab,
6380: reduce_capacity_flag_tab, line_num_reversed_tab
6381: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
6382: WHERE hdr.assignment_id = p_assignment_id
6383: AND hdr.delete_flag = 'N'
6384: AND dtl.forecast_item_id = hdr.forecast_item_id
6385: AND dtl.line_num =

Line 6387: FROM pa_forecast_item_details dtl1

6383: AND hdr.delete_flag = 'N'
6384: AND dtl.forecast_item_id = hdr.forecast_item_id
6385: AND dtl.line_num =
6386: (SELECT max(line_num)
6387: FROM pa_forecast_item_details dtl1
6388: WHERE dtl1.forecast_item_id = hdr.forecast_item_id AND trunc(dtl1.item_date) = trunc(hdr.item_date) ) -- 4918687 SQL ID 14905526
6389: AND trunc(dtl.item_date) = trunc(hdr.item_date) -- 4918687 SQL ID 14905526
6390: order by dtl.item_date, dtl.forecast_item_id ;
6391:

Line 7133: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

7129: org_util_category_id_tab, resource_util_weighted_tab,
7130: org_util_weighted_tab, provisional_flag_tab,
7131: reversed_flag_tab, net_zero_flag_tab,
7132: reduce_capacity_flag_tab, line_num_reversed_tab
7133: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
7134: WHERE hdr.resource_id = p_resource_id
7135: AND hdr.delete_flag = 'N'
7136: AND hdr.forecast_item_type = 'U'
7137: AND dtl.forecast_item_id = hdr.forecast_item_id

Line 7140: FROM pa_forecast_item_details dtl1

7136: AND hdr.forecast_item_type = 'U'
7137: AND dtl.forecast_item_id = hdr.forecast_item_id
7138: AND dtl.line_num =
7139: (SELECT max(line_num)
7140: FROM pa_forecast_item_details dtl1
7141: WHERE dtl1.forecast_item_id = hdr.forecast_item_id AND trunc(dtl1.item_date) = trunc(hdr.item_date) ) -- 4918687 SQL ID 14905571
7142: AND trunc(dtl.item_date) = trunc(hdr.item_date) -- 4918687 SQL ID 14905571
7143: order by dtl.item_date, dtl.forecast_item_id ;
7144:

Line 11019: FROM pa_forecast_item_details dtl, pa_forecast_items hdr

11015: org_util_category_id_tab, resource_util_weighted_tab,
11016: org_util_weighted_tab, provisional_flag_tab,
11017: reversed_flag_tab, net_zero_flag_tab,
11018: reduce_capacity_flag_tab, line_num_reversed_tab
11019: FROM pa_forecast_item_details dtl, pa_forecast_items hdr
11020: WHERE hdr.resource_id = p_resource_id
11021: AND hdr.delete_flag = 'N'
11022: AND hdr.forecast_item_type = 'U'
11023: /***Addeded the following condition to fix the bug : 1913377

Line 11038: FROM pa_forecast_item_details dtl1

11034: trunc(p_end_date) -- bug 9032134
11035: AND dtl.forecast_item_id = hdr.forecast_item_id
11036: AND dtl.line_num = (
11037: SELECT max(line_num)
11038: FROM pa_forecast_item_details dtl1
11039: WHERE dtl1.forecast_item_id = hdr.forecast_item_id)
11040: order by hdr.resource_id,dtl.item_date, dtl.forecast_item_id ;
11041:
11042: IF forecast_item_id_tab.COUNT = 0 THEN