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 5914: FROM pa_mass_txn_asgmt_success_v

5910: l_self_conflict_flag VARCHAR2(1) := 'N';
5911:
5912: CURSOR c1 IS
5913: SELECT assignment_id
5914: FROM pa_mass_txn_asgmt_success_v
5915: WHERE item_type = p_item_type
5916: AND item_key = p_item_key;
5917:
5918: BEGIN

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

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

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

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,
5965: (select resource_id,
5966: capacity_quantity,

Line 5989: 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')

5985: and fi.forecast_item_type = fi_assigned.forecast_item_type
5986: and fi.assignment_id = mass.assignment_id(+)
5987: and mass.item_type(+) = p_item_type
5988: and mass.item_key(+) = p_item_key
5989: 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')
5990: and fi.assignment_id = sch.assignment_id
5991: and fi.item_date between sch.start_date and sch.end_date
5992: and sch.status_code = a.project_status_code
5993: and a.wf_success_status_code = b.project_status_code

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

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

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

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
6045: )FI_ASSIGNED,
6046: (select resource_id,
6047: sum(capacity_quantity) capacity_quantity,

Line 6071: 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')

6067: and fi.forecast_item_type = fi_assigned.forecast_item_type
6068: and fi.assignment_id = mass.assignment_id(+)
6069: and mass.item_type(+) = p_item_type
6070: and mass.item_key(+) = p_item_key
6071: 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')
6072: and fi.assignment_id = sch.assignment_id
6073: and fi.item_date between sch.start_date and sch.end_date
6074: and sch.status_code = a.project_status_code
6075: and a.wf_success_status_code = b.project_status_code