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 6021: from pa_forecast_items fi,

6017: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
6018:
6019: select distinct fi.assignment_id
6020: BULK COLLECT INTO l_assignment_id_tbl
6021: from pa_forecast_items fi,
6022: (select resource_id,
6023: sum(item_quantity) total_assigned_quantity,
6024: item_date,
6025: delete_flag,

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

6023: sum(item_quantity) total_assigned_quantity,
6024: item_date,
6025: delete_flag,
6026: forecast_item_type
6027: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6028: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6029: and fi1.assignment_id = sch.assignment_id
6030: and fi1.item_date between sch.start_date and sch.end_date
6031: and sch.status_code = a.project_status_code

Line 6045: from pa_forecast_items

6041: (select resource_id,
6042: capacity_quantity,
6043: item_date,
6044: delete_flag
6045: from pa_forecast_items
6046: where forecast_item_type = 'U'
6047: )fi_capacity
6048: where fi.assignment_id <> p_assignment_id
6049: and fi.resource_id = l_resource_id

Line 6080: from pa_forecast_items fi,

6076: ELSIF G_AVAILABILITY_CAL_PERIOD = 'WEEKLY' THEN
6077:
6078: select distinct fi.assignment_id
6079: BULK COLLECT INTO l_assignment_id_tbl
6080: from pa_forecast_items fi,
6081: (select resource_id,
6082: sum(item_quantity) total_assigned_quantity,
6083: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6084: delete_flag,

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

6082: sum(item_quantity) total_assigned_quantity,
6083: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6084: delete_flag,
6085: forecast_item_type
6086: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6087: where (fi1.assignment_id = p_assignment_id or asgmt_sys_status_code = 'STAFFED_ASGMT_CONF' )
6088: and fi1.item_date between l_start_date and l_end_date
6089: and fi1.assignment_id = sch.assignment_id
6090: and fi1.item_date between sch.start_date and sch.end_date

Line 6100: from pa_forecast_items

6096: (select resource_id,
6097: sum(capacity_quantity) capacity_quantity,
6098: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6099: delete_flag
6100: from pa_forecast_items
6101: where forecast_item_type = 'U'
6102: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6103: )fi_capacity
6104: where fi.assignment_id <> p_assignment_id

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

6224: IF G_AVAILABILITY_CAL_PERIOD = 'DAILY' THEN
6225: select distinct fi.assignment_id,
6226: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_conflict_flag
6227: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6228: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6229: (select resource_id,
6230: sum(item_quantity) total_assigned_quantity,
6231: item_date,
6232: delete_flag,

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

6236: item_quantity,
6237: item_date,
6238: delete_flag,
6239: forecast_item_type
6240: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6241: 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' )
6242: and fi1.assignment_id = sch.assignment_id
6243: and fi1.item_date between sch.start_date and sch.end_date
6244: and sch.status_code = a.project_status_code

Line 6253: from pa_forecast_items

6249: item_quantity,
6250: item_date,
6251: delete_flag,
6252: forecast_item_type
6253: from pa_forecast_items
6254: where asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
6255: 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))
6256: group by resource_id, item_date, delete_flag, forecast_item_type
6257: )FI_ASSIGNED,

Line 6262: from pa_forecast_items

6258: (select resource_id,
6259: capacity_quantity,
6260: item_date,
6261: delete_flag
6262: from pa_forecast_items
6263: where forecast_item_type = 'U'
6264: )fi_capacity
6265: where fi.assignment_id <> v_c1.assignment_id
6266: and fi.resource_id = l_resource_id

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

6303:
6304: select distinct fi.assignment_id,
6305: decode (mass.assignment_id, null, 'N', 'Y') intra_txn_flag
6306: BULK COLLECT INTO l_assignment_id_tbl, l_intra_txn_conflict_flag_tbl
6307: from pa_forecast_items fi, pa_mass_txn_asgmt_success_v mass, pa_schedules sch, pa_project_statuses a, pa_project_statuses b,
6308: (select resource_id,
6309: sum(item_quantity) total_assigned_quantity,
6310: GLOBAL_EXP_PERIOD_END_DATE,
6311: delete_flag,

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

6315: item_quantity,
6316: GLOBAL_EXP_PERIOD_END_DATE,
6317: delete_flag,
6318: forecast_item_type
6319: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6320: 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' )
6321: and fi1.item_date between l_start_date and l_end_date
6322: and fi1.assignment_id = sch.assignment_id
6323: and fi1.item_date between sch.start_date and sch.end_date

Line 6333: from pa_forecast_items

6329: item_quantity,
6330: GLOBAL_EXP_PERIOD_END_DATE,
6331: delete_flag,
6332: forecast_item_type
6333: from pa_forecast_items
6334: where asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
6335: and item_date between l_start_date and l_end_date
6336: 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))
6337: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag, forecast_item_type

Line 6343: from pa_forecast_items

6339: (select resource_id,
6340: sum(capacity_quantity) capacity_quantity,
6341: GLOBAL_EXP_PERIOD_END_DATE,
6342: delete_flag
6343: from pa_forecast_items
6344: where forecast_item_type = 'U'
6345: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6346: )fi_capacity
6347: where fi.assignment_id <> v_c1.assignment_id

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

6475: item_quantity,
6476: item_date,
6477: asgmt_sys_status_code,
6478: delete_flag
6479: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6480: where fi.assignment_id = p_assignment_id
6481: and fi.assignment_id = sch.assignment_id
6482: and fi.item_date between sch.start_date and sch.end_date
6483: and forecast_item_type = 'A'

Line 6492: from pa_forecast_items

6488: (select resource_id,
6489: capacity_quantity capacity_quantity,
6490: item_date,
6491: delete_flag
6492: from pa_forecast_items
6493: where forecast_item_type = 'U'
6494: )fi_capacity
6495: where fi_assigned.resource_id = p_resource_id
6496: and fi_assigned.resource_id = fi_capacity.resource_id

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

6508: (select resource_id,
6509: sum(item_quantity) weekly_quantity,
6510: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6511: delete_flag
6512: from pa_forecast_items fi, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
6513: where fi.assignment_id = p_assignment_id
6514: and fi.assignment_id = sch.assignment_id
6515: and item_date between l_week_start_date and l_week_end_date
6516: and item_date between sch.start_date and sch.end_date

Line 6527: from pa_forecast_items

6523: (select resource_id,
6524: sum(capacity_quantity) capacity_quantity,
6525: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6526: delete_flag
6527: from pa_forecast_items
6528: where forecast_item_type = 'U'
6529: and item_date between l_week_start_date and l_week_end_date
6530: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6531: )fi_capacity

Line 6718: FROM pa_forecast_items fi,

6714: fi.GLOBAL_EXP_PERIOD_END_DATE,
6715: fi.item_quantity,
6716: fi_overcom.overcommitment_quantity
6717: BULK COLLECT INTO l_assignment_id_tbl, l_item_date_tbl, l_week_end_date_tbl, l_item_quantity_tbl, l_overcom_quantity_tbl
6718: FROM pa_forecast_items fi,
6719: pa_assignment_conflict_hist conf,
6720: (SELECT
6721: resource_id,
6722: item_date,

Line 6725: FROM pa_forecast_items

6721: resource_id,
6722: item_date,
6723: DECODE(sign(capacity_quantity*G_OVERCOMMITMENT_PERCENTAGE-overcommitment_quantity), 1, 0, overcommitment_quantity) overcommitment_quantity,
6724: delete_flag
6725: FROM pa_forecast_items
6726: WHERE forecast_item_type = 'U'
6727: ) fi_overcom
6728: WHERE fi.resource_id = l_resource_id
6729: AND fi.resource_id = fi_overcom.resource_id

Line 6752: FROM pa_forecast_items fi, pa_assignment_conflict_hist conf,

6748: fi.GLOBAL_EXP_PERIOD_END_DATE,
6749: fi.item_quantity,
6750: fi_overcom.overcommitment_quantity
6751: BULK COLLECT INTO l_assignment_id_tbl, l_item_date_tbl, l_week_end_date_tbl, l_item_quantity_tbl, l_overcom_quantity_tbl
6752: FROM pa_forecast_items fi, pa_assignment_conflict_hist conf,
6753: (SELECT
6754: resource_id,
6755: overcommitment_quantity,
6756: item_date,

Line 6758: from pa_forecast_items

6754: resource_id,
6755: overcommitment_quantity,
6756: item_date,
6757: delete_flag
6758: from pa_forecast_items
6759: where forecast_item_type = 'U'
6760: )fi_overcom,
6761: (SELECT
6762: resource_id,

Line 6766: FROM pa_forecast_items

6762: resource_id,
6763: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
6764: decode(sign(sum(capacity_quantity)*G_OVERCOMMITMENT_PERCENTAGE-sum(overcommitment_quantity)), 1, 0, sum(overcommitment_quantity)) overcommitment_quantity,
6765: delete_flag
6766: FROM pa_forecast_items
6767: WHERE forecast_item_type = 'U'
6768: AND item_date BETWEEN l_conflict_start_date AND l_conflict_end_date
6769: GROUP BY resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
6770: ) fi_week

Line 8967: from pa_forecast_items fi,

8963: SELECT COUNT(*)
8964: INTO l_count
8965: FROM (
8966: select DISTINCT fi.item_date
8967: from pa_forecast_items fi,
8968: (select resource_id,
8969: sum(item_quantity) assigned_quantity,
8970: item_date,
8971: delete_flag

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

8973: (select fi1.resource_id,
8974: fi1.item_quantity,
8975: fi1.item_date,
8976: fi1.delete_flag
8977: from pa_forecast_items fi1, pa_project_assignments asgn, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
8978: where (fi1.assignment_id = p_assignment_id
8979: or fi1.assignment_id in
8980: (select conflict_assignment_id
8981: from pa_assignment_conflict_hist

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

8995: select fi2.resource_id,
8996: item_quantity,
8997: fi2.item_date,
8998: fi2.delete_flag
8999: from pa_forecast_items fi2, pa_project_assignments asgn, pa_assignment_conflict_hist hist
9000: where fi2.assignment_id = asgn.assignment_id
9001: and fi2.assignment_id = hist.conflict_assignment_id
9002: and hist.conflict_group_id = p_conflict_group_id
9003: and hist.assignment_id = p_assignment_id

Line 9014: from pa_forecast_items fi2, pa_project_assignments asgn

9010: select fi2.resource_id,
9011: item_quantity,
9012: fi2.item_date,
9013: fi2.delete_flag
9014: from pa_forecast_items fi2, pa_project_assignments asgn
9015: where fi2.assignment_id = p_assignment_id
9016: and fi2.assignment_id = asgn.assignment_id
9017: and fi2.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF'
9018: and asgn.apprvl_status_code in ('ASGMT_APPRVL_APPROVED', 'ASGMT_APPRVL_REJECTED')

Line 9027: from pa_forecast_items

9023: (select capacity_quantity,
9024: item_date,
9025: delete_flag,
9026: resource_id
9027: from pa_forecast_items
9028: where forecast_item_type = 'U'
9029: )fi_capacity
9030: where fi.resource_id = p_resource_id
9031: and fi.resource_id = fi_capacity.resource_id

Line 9053: from pa_forecast_items fi,

9049: INTO l_count
9050: FROM (
9051: select DISTINCT
9052: fi.item_date
9053: from pa_forecast_items fi,
9054: (select
9055: resource_id,
9056: sum(item_quantity) total_assigned_quantity,
9057: GLOBAL_EXP_PERIOD_END_DATE week_end_date,

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

9056: sum(item_quantity) total_assigned_quantity,
9057: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
9058: delete_flag,
9059: forecast_item_type
9060: from pa_forecast_items fi1, pa_schedules sch, pa_project_statuses a, pa_project_statuses b
9061: where (fi1.assignment_id = p_assignment_id
9062: or fi1.assignment_id in (select conflict_assignment_id
9063: from pa_assignment_conflict_hist
9064: where conflict_group_id = p_conflict_group_id

Line 9079: from pa_forecast_items

9075: (select resource_id,
9076: sum(capacity_quantity) capacity_quantity,
9077: GLOBAL_EXP_PERIOD_END_DATE week_end_date,
9078: delete_flag
9079: from pa_forecast_items
9080: where forecast_item_type = 'U'
9081: group by resource_id, GLOBAL_EXP_PERIOD_END_DATE, delete_flag
9082: )fi_capacity
9083: where fi.resource_id = p_resource_id