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_STARTING_LOTS_INTERFACE

Line 274: -- corresponding table type and table declarations for wsm_starting_lots_interface

270: v_phantom_exists NUMBER := NULL; --OPTII-PERF: 1-Phantom req exits,2-Phantom requirement does not exists
271: v_insert_wip NUMBER := NULL; --OPTII-PERF 1-Insert wip data in create_jobcopies procedure
272: -- 2-Phantom requirement does not exists
273: -- ==============================================================================================
274: -- corresponding table type and table declarations for wsm_starting_lots_interface
275: -- ==============================================================================================
276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;

Line 276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;

272: -- 2-Phantom requirement does not exists
273: -- ==============================================================================================
274: -- corresponding table type and table declarations for wsm_starting_lots_interface
275: -- ==============================================================================================
276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;

Line 277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;

273: -- ==============================================================================================
274: -- corresponding table type and table declarations for wsm_starting_lots_interface
275: -- ==============================================================================================
276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;

Line 278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;

274: -- corresponding table type and table declarations for wsm_starting_lots_interface
275: -- ==============================================================================================
276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;

Line 279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;

275: -- ==============================================================================================
276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;

Line 280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;

276: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;

Line 281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;

277: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;

Line 282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;

278: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
286: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;

Line 283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;

279: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
286: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
287: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;

Line 284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;

280: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
286: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
287: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
288:

Line 285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;

281: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
282: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
286: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
287: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
288:
289: v_wsli_hdr_id t_wsli_header_id := t_wsli_header_id();

Line 287: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;

283: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
284: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
285: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
286: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
287: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
288:
289: v_wsli_hdr_id t_wsli_header_id := t_wsli_header_id();
290: v_wsli_lot_number t_wsli_lot_number := t_wsli_lot_number();
291: v_wsli_inventory_item_id t_wsli_inventory_item_id := t_wsli_inventory_item_id();

Line 307: lot_number wsm_starting_lots_interface.lot_number%type,

303: -- creating an index by table that'll store the wsli values with header_id as the index for easy
304: -- validation
305: -- ==============================================================================================
306: type rec_wsli IS record (
307: lot_number wsm_starting_lots_interface.lot_number%type,
308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,

Line 308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,

304: -- validation
305: -- ==============================================================================================
306: type rec_wsli IS record (
307: lot_number wsm_starting_lots_interface.lot_number%type,
308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,

Line 309: organization_id wsm_starting_lots_interface.organization_id%type,

305: -- ==============================================================================================
306: type rec_wsli IS record (
307: lot_number wsm_starting_lots_interface.lot_number%type,
308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,

Line 310: quantity wsm_starting_lots_interface.quantity%type,

306: type rec_wsli IS record (
307: lot_number wsm_starting_lots_interface.lot_number%type,
308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,

Line 311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,

307: lot_number wsm_starting_lots_interface.lot_number%type,
308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
315: created_by wsm_starting_lots_interface.created_by%type,

Line 312: locator_id wsm_starting_lots_interface.locator_id%type,

308: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
315: created_by wsm_starting_lots_interface.created_by%type,
316: primary_uom_code mtl_system_items.primary_uom_code%type,

Line 313: revision wsm_starting_lots_interface.revision%type,

309: organization_id wsm_starting_lots_interface.organization_id%type,
310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
315: created_by wsm_starting_lots_interface.created_by%type,
316: primary_uom_code mtl_system_items.primary_uom_code%type,
317: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type

Line 314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,

310: quantity wsm_starting_lots_interface.quantity%type,
311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
315: created_by wsm_starting_lots_interface.created_by%type,
316: primary_uom_code mtl_system_items.primary_uom_code%type,
317: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type
318: );

Line 315: created_by wsm_starting_lots_interface.created_by%type,

311: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
312: locator_id wsm_starting_lots_interface.locator_id%type,
313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
315: created_by wsm_starting_lots_interface.created_by%type,
316: primary_uom_code mtl_system_items.primary_uom_code%type,
317: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type
318: );
319:

Line 317: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type

313: revision wsm_starting_lots_interface.revision%type,
314: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
315: created_by wsm_starting_lots_interface.created_by%type,
316: primary_uom_code mtl_system_items.primary_uom_code%type,
317: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type
318: );
319:
320: v_rec_wsli rec_wsli; -- Not used
321:

Line 7055: l_src_lot_number wsm_starting_lots_interface.lot_number%type;

7051: l_mtl_locator_type number;
7052: l_osp_op_seq_num number;
7053: l_est_scrap_account number;
7054: l_est_scrap_var_account number;
7055: l_src_lot_number wsm_starting_lots_interface.lot_number%type;
7056: l_src_inv_item_id NUMBER;
7057: l_scheduling_mode NUMBER; -- ADD BUG 3479666
7058:
7059: l_job_type_code varchar2(30);

Line 7973: from wsm_starting_lots_interface wsli,

7969: l_num_records := 0;
7970: begin
7971: select 1
7972: into l_num_records
7973: from wsm_starting_lots_interface wsli,
7974: wsm_lot_split_merges_interface wlsmi
7975: where wsli.lot_number = v_wlji_job_name(v_idx)
7976: and wsli.header_id = wlsmi.header_id
7977: and wlsmi.process_status in (1,2);

Line 8866: 'Last Updated By in WSM_STARTING_LOTS_INTERFACE',

8862: when no_data_found then
8863: l_error_code := -1;
8864: l_aux_mesg := '';
8865: handle_invalid_field(
8866: 'Last Updated By in WSM_STARTING_LOTS_INTERFACE',
8867: l_aux_mesg,
8868: l_stmt_num);
8869: l_error_count := l_error_count + 1;
8870: GOTO abort_this_job;

Line 8895: 'Created By in WSM_STARTING_LOTS_INTERFACE',

8891: when no_data_found then
8892: l_error_code := -1;
8893: l_aux_mesg := '';
8894: handle_invalid_field(
8895: 'Created By in WSM_STARTING_LOTS_INTERFACE',
8896: l_aux_mesg,
8897: l_stmt_num);
8898: l_error_count := l_error_count + 1;
8899: GOTO abort_this_job;

Line 10691: -- if the user does not provide a revision in wsm_starting_lots_interface

10687: end if;
10688: end if;
10689:
10690: l_stmt_num := 870;
10691: -- if the user does not provide a revision in wsm_starting_lots_interface
10692: -- then get the current revision and use that to issue components. if user
10693: -- provides one, validate it
10694: l_source_item_rev := v_wsli(v_wlji_src_line_id(v_idx)).revision;
10695: declare

Line 12078: delete from wsm_starting_lots_interface

12074: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
12075:
12076: if l_atleast_one_row_in_mmtt <> 0 then
12077: l_stmt_num := 1100;
12078: delete from wsm_starting_lots_interface
12079: where header_id IN (
12080: select wlji.source_line_id
12081: from wsm_lot_job_interface wlji
12082: where wlji.process_status = 5

Line 20109: from wsm_starting_lots_interface wsli,

20105: wsli.last_updated_by,
20106: wsli.created_by,
20107: msi.primary_uom_code,
20108: wsli.component_issue_quantity
20109: from wsm_starting_lots_interface wsli,
20110: wsm_lot_job_interface wlji,
20111: mtl_system_items msi
20112: where wsli.header_id = wlji.source_line_id
20113: and wlji.group_id = p_group_id

Line 20189: wsm_starting_lots_interface wsli,

20185: mmtt.error_explanation,
20186: wsli.header_id,
20187: wlji.header_id
20188: from mtl_material_transactions_temp mmtt,
20189: wsm_starting_lots_interface wsli,
20190: wsm_lot_job_interface wlji
20191: where mmtt.transaction_header_id = p_header_id
20192: and mmtt.source_line_id = wsli.header_id
20193: and wsli.header_id = wlji.source_line_id;