eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SCHEDULE_PVT dependencies on PA_FORECAST_ITEMS

Line 5733: from pa_forecast_items fi,

5729: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
5730:
5731: select distinct fi.assignment_id
5732: BULK COLLECT INTO l_assignment_id_tbl
5733: from pa_forecast_items fi,
5734: (select resource_id,
5735: sum(item_quantity) total_assigned_quantity,
5736: item_date,
5737: delete_flag,

Line 5739: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

5735: sum(item_quantity) total_assigned_quantity,
5736: item_date,
5737: delete_flag,
5738: forecast_item_type
5739: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
5740: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
5741: and fi1.assignment_id = sch.assignment_id
5742: and fi1.item_date between sch.start_date and sch.end_date
5743: and sch.status_code = a.project_status_code

Line 5752: from pa_forecast_items

5748: (select resource_id,
5749: capacity_quantity,
5750: item_date,
5751: delete_flag
5752: from pa_forecast_items
5753: where forecast_item_type = 'U'
5754: )fi_capacity
5755: where fi.assignment_id <> p_assignment_id
5756: and fi.resource_id = l_resource_id

Line 5787: from pa_forecast_items fi,

5783: ELSIF G_AVAILABILITY_CAL_PERIOD = 'WEEKLY' THEN
5784:
5785: select distinct fi.assignment_id
5786: BULK COLLECT INTO l_assignment_id_tbl
5787: from pa_forecast_items fi,
5788: (select resource_id,
5789: sum(item_quantity) total_assigned_quantity,
5790: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
5791: delete_flag,

Line 5793: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

5789: sum(item_quantity) total_assigned_quantity,
5790: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
5791: delete_flag,
5792: forecast_item_type
5793: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
5794: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
5795: and fi1.item_date between l_start_date and l_end_date
5796: and fi1.assignment_id = sch.assignment_id
5797: and fi1.item_date between sch.start_date and sch.end_date

Line 5807: from pa_forecast_items

5803: (select resource_id,
5804: sum(capacity_quantity) capacity_quantity,
5805: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
5806: delete_flag
5807: from pa_forecast_items
5808: where forecast_item_type = 'U'
5809: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
5810: )fi_capacity
5811: where fi.assignment_id <> p_assignment_id

Line 5935: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,

5931: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
5932: select distinct fi.assignment_id,
5933: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_conflict_flag
5934: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
5935: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
5936: (select resource_id,
5937: sum(item_quantity) total_assigned_quantity,
5938: item_date,
5939: delete_flag,

Line 5947: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

5943: item_quantity,
5944: item_date,
5945: delete_flag,
5946: forecast_item_type
5947: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
5948: where (fi1.assignment_id in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key) or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
5949: and fi1.assignment_id = sch.assignment_id
5950: and fi1.item_date between sch.start_date and sch.end_date
5951: and sch.status_code = a.project_status_code

Line 5960: from pa_forecast_items

5956: item_quantity,
5957: item_date,
5958: delete_flag,
5959: forecast_item_type
5960: from pa_forecast_items
5961: where asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
5962: and assignment_id not in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key))
5963: group by resource_id, item_date, delete_flag, forecast_item_type
5964: )FI_ASSIGNED,

Line 5969: from pa_forecast_items

5965: (select resource_id,
5966: capacity_quantity,
5967: item_date,
5968: delete_flag
5969: from pa_forecast_items
5970: where forecast_item_type = 'U'
5971: )fi_capacity
5972: where fi.assignment_id <> v_c1.assignment_id
5973: and fi.resource_id = l_resource_id

Line 6014: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,

6010:
6011: select distinct fi.assignment_id,
6012: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_flag
6013: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6014: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6015: (select resource_id,
6016: sum(item_quantity) total_assigned_quantity,
6017: GLOBAL_EXP_PERIOD_END_DATE,
6018: delete_flag,

Line 6026: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6022: item_quantity,
6023: GLOBAL_EXP_PERIOD_END_DATE,
6024: delete_flag,
6025: forecast_item_type
6026: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6027: where (fi1.assignment_id in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key) or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6028: and fi1.item_date between l_start_date and l_end_date
6029: and fi1.assignment_id = sch.assignment_id
6030: and fi1.item_date between sch.start_date and sch.end_date

Line 6040: from pa_forecast_items

6036: item_quantity,
6037: GLOBAL_EXP_PERIOD_END_DATE,
6038: delete_flag,
6039: forecast_item_type
6040: from pa_forecast_items
6041: where asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
6042: and item_date between l_start_date and l_end_date
6043: and assignment_id not in (select assignment_id from pa_mass_txn_asgmt_success_v where item_type = p_item_type and item_key = p_item_key))
6044: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag, forecast_item_type

Line 6050: from pa_forecast_items

6046: (select resource_id,
6047: sum(capacity_quantity) capacity_quantity,
6048: GLOBAL_EXP_PERIOD_END_DATE,
6049: delete_flag
6050: from pa_forecast_items
6051: where forecast_item_type = 'U'
6052: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6053: )fi_capacity
6054: where fi.assignment_id <> v_c1.assignment_id

Line 6186: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6182: item_quantity,
6183: item_date,
6184: asgmt_sys_status_code,
6185: delete_flag
6186: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6187: where fi.assignment_id = p_assignment_id
6188: and fi.assignment_id = sch.assignment_id
6189: and fi.item_date between sch.start_date and sch.end_date
6190: and forecast_item_type = 'A'

Line 6199: from pa_forecast_items

6195: (select resource_id,
6196: capacity_quantity capacity_quantity,
6197: item_date,
6198: delete_flag
6199: from pa_forecast_items
6200: where forecast_item_type = 'U'
6201: )fi_capacity
6202: where fi_assigned.resource_id = p_resource_id
6203: and fi_assigned.resource_id = fi_capacity.resource_id

Line 6219: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

6215: (select resource_id,
6216: sum(item_quantity) weekly_quantity,
6217: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6218: delete_flag
6219: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6220: where fi.assignment_id = p_assignment_id
6221: and fi.assignment_id = sch.assignment_id
6222: and item_date between l_week_start_date and l_week_end_date
6223: and item_date between sch.start_date and sch.end_date

Line 6234: from pa_forecast_items

6230: (select resource_id,
6231: sum(capacity_quantity) capacity_quantity,
6232: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6233: delete_flag
6234: from pa_forecast_items
6235: where forecast_item_type = 'U'
6236: and item_date between l_week_start_date and l_week_end_date
6237: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6238: )fi_capacity

Line 6425: FROM pa_forecast_items fi,

6421: fi.GLOBAL_EXP_PERIOD_END_DATE,
6422: fi.item_quantity,
6423: fi_overcom.overcommitment_quantity
6424: BULK COLLECT INTO l_assignment_id_tbl, l_item_date_tbl, l_week_end_date_tbl, l_item_quantity_tbl, l_overcom_quantity_tbl
6425: FROM pa_forecast_items fi,
6426: pa_assignment_conflict_hist conf,
6427: (SELECT
6428: resource_id,
6429: item_date,

Line 6432: FROM pa_forecast_items

6428: resource_id,
6429: item_date,
6430: DECODE(sign(capacity_quantity*G_OVERCOMMITMENT_PERCENTAGE-overcommitment_quantity), 1, 0, overcommitment_quantity) overcommitment_quantity,
6431: delete_flag
6432: FROM pa_forecast_items
6433: WHERE forecast_item_type = 'U'
6434: ) fi_overcom
6435: WHERE fi.resource_id = l_resource_id
6436: AND fi.resource_id = fi_overcom.resource_id

Line 6459: FROM pa_forecast_items fi, pa_assignment_conflict_hist conf,

6455: fi.GLOBAL_EXP_PERIOD_END_DATE,
6456: fi.item_quantity,
6457: fi_overcom.overcommitment_quantity
6458: BULK COLLECT INTO l_assignment_id_tbl, l_item_date_tbl, l_week_end_date_tbl, l_item_quantity_tbl, l_overcom_quantity_tbl
6459: FROM pa_forecast_items fi, pa_assignment_conflict_hist conf,
6460: (SELECT
6461: resource_id,
6462: overcommitment_quantity,
6463: item_date,

Line 6465: from pa_forecast_items

6461: resource_id,
6462: overcommitment_quantity,
6463: item_date,
6464: delete_flag
6465: from pa_forecast_items
6466: where forecast_item_type = 'U'
6467: )fi_overcom,
6468: (SELECT
6469: resource_id,

Line 6473: FROM pa_forecast_items

6469: resource_id,
6470: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6471: decode(sign(sum(capacity_quantity)*G_OVERCOMMITMENT_PERCENTAGE-sum(overcommitment_quantity)), 1, 0, sum(overcommitment_quantity)) overcommitment_quantity,
6472: delete_flag
6473: FROM pa_forecast_items
6474: WHERE forecast_item_type = 'U'
6475: AND item_date BETWEEN l_conflict_start_date AND l_conflict_end_date
6476: GROUP BY resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6477: ) fi_week

Line 8674: from pa_forecast_items fi,

8670: SELECT COUNT(*)
8671: INTO l_count
8672: FROM (
8673: select DISTINCT fi.item_date
8674: from pa_forecast_items fi,
8675: (select resource_id,
8676: sum(item_quantity) assigned_quantity,
8677: item_date,
8678: delete_flag

Line 8684: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

8680: (select fi1.resource_id,
8681: fi1.item_quantity,
8682: fi1.item_date,
8683: fi1.delete_flag
8684: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8685: where (fi1.assignment_id = p_assignment_id
8686: or fi1.assignment_id in
8687: (select conflict_assignment_id
8688: from pa_assignment_conflict_hist

Line 8706: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist

8702: select fi2.resource_id,
8703: item_quantity,
8704: fi2.item_date,
8705: fi2.delete_flag
8706: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
8707: where fi2.assignment_id = asgn.assignment_id
8708: and fi2.assignment_id = hist.conflict_assignment_id
8709: and hist.conflict_group_id = p_conflict_group_id
8710: and hist.assignment_id = p_assignment_id

Line 8721: from pa_forecast_items fi2, pa_project_assignments asgn

8717: select fi2.resource_id,
8718: item_quantity,
8719: fi2.item_date,
8720: fi2.delete_flag
8721: from pa_forecast_items fi2, pa_project_assignments asgn
8722: where fi2.assignment_id = p_assignment_id
8723: and fi2.assignment_id = asgn.assignment_id
8724: and fi2.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
8725: and asgn.apprvl_status_code in ('ASGMT_APPRVL_APPROVED', 'ASGMT_APPRVL_REJECTED')

Line 8734: from pa_forecast_items

8730: (select capacity_quantity,
8731: item_date,
8732: delete_flag,
8733: resource_id
8734: from pa_forecast_items
8735: where forecast_item_type = 'U'
8736: )fi_capacity
8737: where fi.resource_id = p_resource_id
8738: and fi.resource_id = fi_capacity.resource_id

Line 8760: from pa_forecast_items fi,

8756: INTO l_count
8757: FROM (
8758: select DISTINCT
8759: fi.item_date
8760: from pa_forecast_items fi,
8761: (select
8762: resource_id,
8763: sum(item_quantity) total_assigned_quantity,
8764: GLOBAL_EXP_PERIOD_END_DATE week_end_date,

Line 8767: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b

8763: sum(item_quantity) total_assigned_quantity,
8764: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
8765: delete_flag,
8766: forecast_item_type
8767: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8768: where (fi1.assignment_id = p_assignment_id
8769: or fi1.assignment_id in (select conflict_assignment_id
8770: from pa_assignment_conflict_hist
8771: where conflict_group_id = p_conflict_group_id

Line 8786: from pa_forecast_items

8782: (select resource_id,
8783: sum(capacity_quantity) capacity_quantity,
8784: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
8785: delete_flag
8786: from pa_forecast_items
8787: where forecast_item_type = 'U'
8788: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
8789: )fi_capacity
8790: where fi.resource_id = p_resource_id