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.WSM_LBJ_INTERFACE_PVT dependencies on WSM_LOT_JOB_INTERFACE_S

Line 77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;

73: type t_wlji_completion_locator_id is table of wsm_lot_job_interface.completion_locator_id%type;
74: type t_wlji_mode_flag is table of wsm_lot_job_interface.mode_flag%type;
75: type t_wlji_group_id is table of wsm_lot_job_interface.group_id%type;
76: type t_wlji_load_type is table of wsm_lot_job_interface.load_type%type;
77: type t_wlji_status_type is table of wsm_lot_job_interface.status_type%type;
78: type t_wlji_old_completion_date is table of wsm_lot_job_interface.old_completion_date%type;
79: type t_wlji_bom_reference_id is table of wsm_lot_job_interface.bom_reference_id%type;
80: type t_wlji_bom_revision_date is table of wsm_lot_job_interface.bom_revision_date%type;
81: type t_wlji_routing_revision_date is table of wsm_lot_job_interface.routing_revision_date%type;

Line 89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;

85: type t_wlji_firm_planned_flag is table of wsm_lot_job_interface.firm_planned_flag%type;
86: type t_wlji_alt_routing_designator is table of wsm_lot_job_interface.alternate_routing_designator%type;
87: type t_wlji_alt_bom_designator is table of wsm_lot_job_interface.alternate_bom_designator%type;
88: type t_wlji_demand_class is table of wsm_lot_job_interface.demand_class%type;
89: type t_wlji_start_quantity is table of wsm_lot_job_interface.start_quantity%type;
90: type t_wlji_old_start_quantity is table of wsm_lot_job_interface.old_start_quantity%type;
91: type t_wlji_error is table of wsm_lot_job_interface.error%type;
92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;

Line 96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;

92: type t_wlji_fusd is table of wsm_lot_job_interface.first_unit_start_date%type;
93: type t_wlji_fucd is table of wsm_lot_job_interface.first_unit_completion_date%type;
94: type t_wlji_lusd is table of wsm_lot_job_interface.last_unit_start_date%type;
95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;

Line 99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;

95: type t_wlji_lucd is table of wsm_lot_job_interface.last_unit_completion_date%type;
96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;

Line 100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;

96: type t_wlji_scheduling_method is table of wsm_lot_job_interface.scheduling_method%type;
97: type t_wlji_routing_revision is table of wsm_lot_job_interface.routing_revision%type;
98: type t_wlji_bom_revision is table of wsm_lot_job_interface.bom_revision%type;
99: type t_wlji_schedule_group_id is table of wsm_lot_job_interface.schedule_group_id%type;
100: type t_wlji_schedule_group_name is table of wsm_lot_job_interface.schedule_group_name%type;
101: type t_wlji_build_sequence is table of wsm_lot_job_interface.build_sequence%type;
102: type t_wlji_net_quantity is table of wsm_lot_job_interface.net_quantity%type;
103: type t_wlji_allow_explosion is table of wsm_lot_job_interface.allow_explosion%type;
104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;

Line 108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;

104: type t_wlji_old_status_type is table of wsm_lot_job_interface.old_status_type%type;
105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;

Line 109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;

105: type t_wlji_interface_id is table of wsm_lot_job_interface.interface_id%type;
106: type t_wlji_coproducts_supply is table of wsm_lot_job_interface.coproducts_supply%type;
107: type t_wlji_job_type is table of wsm_lot_job_interface.job_type%type;
108: type t_wlji_source_code is table of wsm_lot_job_interface.source_code%type;
109: type t_wlji_source_line_id is table of wsm_lot_job_interface.source_line_id%type;
110: type t_wlji_project_id is table of wsm_lot_job_interface.project_id%type;
111: type t_wlji_project_name is table of wsm_lot_job_interface.project_name%type;
112: type t_wlji_task_id is table of wsm_lot_job_interface.task_id%type;
113: type t_wlji_delivery_id is table of wsm_lot_job_interface.delivery_id%type;

Line 6660: select wsm_lot_job_interface_s.NEXTVAL

6656: if not l_v_job_gid.exists(l_job_name_hash) then -- one new job name
6657: if mod(l_job_cnt, l_num_jobs_per) = 0 then
6658: l_wrk_cnt := l_wrk_cnt + 1; -- one more worker
6659: -- get a new group id
6660: select wsm_lot_job_interface_s.NEXTVAL
6661: into l_group_id
6662: from dual;
6663: l_v_group_id(l_wrk_cnt) := l_group_id;
6664: l_v_group_no(l_wrk_cnt) := 0;

Line 6688: select wsm_lot_job_interface_s.NEXTVAL

6684: 37, 1073741824);
6685: if not l_v_job_gid.exists(l_job_name_hash) then -- a new job
6686: if mod(l_job_cnt, l_num_jobs_per) = 0 then
6687: l_wrk_cnt := l_wrk_cnt +1; -- one more worker
6688: select wsm_lot_job_interface_s.NEXTVAL
6689: into l_group_id
6690: from dual;
6691: l_v_group_id(l_wrk_cnt) := l_group_id;
6692: l_v_group_no(l_wrk_cnt) := 0;

Line 7326: select wsm_lot_job_interface_s.NEXTVAL

7322: l_stmt_num := 60;
7323: -- updating the group_id column of wlji with a number unique for this particular batch.
7324: -- This'll help when I select corresponding rows from wsli.
7325:
7326: select wsm_lot_job_interface_s.NEXTVAL
7327: into l_batch_grp_id
7328: from dual;
7329:
7330: l_stmt_num := 60.1;