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_MASS_TXN_ASGMT_SUCCESS_V

Line 6207: FROM pa_mass_txn_asgmt_success_v

6203: l_self_conflict_flag VARCHAR2(1) := 'N';
6204:
6205: CURSOR c1 IS
6206: SELECT assignment_id
6207: FROM pa_mass_txn_asgmt_success_v
6208: WHERE item_type = p_item_type
6209: AND item_key = p_item_key;
6210:
6211: BEGIN

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 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' )

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
6245: and a.wf_success_status_code = b.project_status_code

Line 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))

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,
6258: (select resource_id,
6259: capacity_quantity,

Line 6282: and (fi.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 fi.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF')

6278: and fi.forecast_item_type = fi_assigned.forecast_item_type
6279: and fi.assignment_id = mass.assignment_id(+)
6280: and mass.item_type(+) = p_item_type
6281: and mass.item_key(+) = p_item_key
6282: and (fi.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 fi.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF')
6283: and fi.assignment_id = sch.assignment_id
6284: and fi.item_date between sch.start_date and sch.end_date
6285: and sch.status_code = a.project_status_code
6286: and a.wf_success_status_code = b.project_status_code

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 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' )

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
6324: and sch.status_code = a.project_status_code

Line 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))

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
6338: )FI_ASSIGNED,
6339: (select resource_id,
6340: sum(capacity_quantity) capacity_quantity,

Line 6364: and (fi.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 fi.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF')

6360: and fi.forecast_item_type = fi_assigned.forecast_item_type
6361: and fi.assignment_id = mass.assignment_id(+)
6362: and mass.item_type(+) = p_item_type
6363: and mass.item_key(+) = p_item_key
6364: and (fi.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 fi.asgmt_sys_status_code = 'STAFFED_ASGMT_CONF')
6365: and fi.assignment_id = sch.assignment_id
6366: and fi.item_date between sch.start_date and sch.end_date
6367: and sch.status_code = a.project_status_code
6368: and a.wf_success_status_code = b.project_status_code