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.WSMPLBJI dependencies on WSM_STARTING_LOTS_INTERFACE

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

236: v_wlji_date_released t_wlji_date_released := t_wlji_date_released(); --bugfix 2697295
237:
238:
239: --=======================================================================================================
240: --corresponding table type and table declarations for wsm_starting_lots_interface
241: --=======================================================================================================
242:
243: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;

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

239: --=======================================================================================================
240: --corresponding table type and table declarations for wsm_starting_lots_interface
241: --=======================================================================================================
242:
243: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;

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

240: --corresponding table type and table declarations for wsm_starting_lots_interface
241: --=======================================================================================================
242:
243: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;

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

241: --=======================================================================================================
242:
243: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;

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

242:
243: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;

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

243: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;

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

244: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;

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

245: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;

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

246: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
254: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;

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

247: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
254: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
255:

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

248: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
254: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
255:
256: v_wsli_header_id t_wsli_header_id := t_wsli_header_id();

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

250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
254: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
255:
256: v_wsli_header_id t_wsli_header_id := t_wsli_header_id();
257: v_wsli_lot_number t_wsli_lot_number := t_wsli_lot_number();
258: v_wsli_inventory_item_id t_wsli_inventory_item_id := t_wsli_inventory_item_id();

Line 274: lot_number wsm_starting_lots_interface.lot_number%type,

270: -- creating an index by table that'll store the wsli values with header_id as the index for easy validation
271: -- ========================================================================================================
272:
273: type rec_wsli IS record(
274: lot_number wsm_starting_lots_interface.lot_number%type,
275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,

Line 275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,

271: -- ========================================================================================================
272:
273: type rec_wsli IS record(
274: lot_number wsm_starting_lots_interface.lot_number%type,
275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,

Line 276: organization_id wsm_starting_lots_interface.organization_id%type,

272:
273: type rec_wsli IS record(
274: lot_number wsm_starting_lots_interface.lot_number%type,
275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,

Line 277: quantity wsm_starting_lots_interface.quantity%type,

273: type rec_wsli IS record(
274: lot_number wsm_starting_lots_interface.lot_number%type,
275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,

Line 278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,

274: lot_number wsm_starting_lots_interface.lot_number%type,
275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,

Line 279: locator_id wsm_starting_lots_interface.locator_id%type,

275: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,
283: primary_uom_code mtl_system_items.primary_uom_code%type,

Line 280: revision wsm_starting_lots_interface.revision%type,

276: organization_id wsm_starting_lots_interface.organization_id%type,
277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,
283: primary_uom_code mtl_system_items.primary_uom_code%type,
284: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type);

Line 281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,

277: quantity wsm_starting_lots_interface.quantity%type,
278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,
283: primary_uom_code mtl_system_items.primary_uom_code%type,
284: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type);
285:

Line 282: created_by wsm_starting_lots_interface.created_by%type,

278: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,
283: primary_uom_code mtl_system_items.primary_uom_code%type,
284: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type);
285:
286: v_rec_wsli rec_wsli;

Line 284: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type);

280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,
283: primary_uom_code mtl_system_items.primary_uom_code%type,
284: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type);
285:
286: v_rec_wsli rec_wsli;
287:
288: type t_wsli IS table of rec_wsli index by binary_integer;

Line 1508: from wsm_starting_lots_interface wsli,

1504: wsli.last_updated_by,
1505: wsli.created_by,
1506: msi.primary_uom_code,
1507: wsli.component_issue_quantity
1508: from wsm_starting_lots_interface wsli,
1509: wsm_lot_job_interface wlji,
1510: mtl_system_items msi
1511: where wsli.header_id = wlji.source_line_id
1512: and wlji.group_id = l_group_id

Line 1592: wsm_starting_lots_interface wsli,

1588: mmtt.error_explanation,
1589: wsli.header_id,
1590: wlji.header_id
1591: from mtl_material_transactions_temp mmtt,
1592: wsm_starting_lots_interface wsli,
1593: wsm_lot_job_interface wlji
1594: where mmtt.transaction_header_id = p_header_id
1595: and mmtt.source_line_id = wsli.header_id
1596: and wsli.header_id = wlji.source_line_id ;

Line 3046: l_src_lot_number wsm_starting_lots_interface.lot_number%type;

3042: l_end_seq_id NUMBER;
3043: l_txnexist NUMBER;
3044: l_qntydiff NUMBER;
3045: mtl_locator_type NUMBER;
3046: l_src_lot_number wsm_starting_lots_interface.lot_number%type;
3047: l_src_inv_item_id NUMBER;
3048: l_comp_basis_type NUMBER ; --LBM enh: - basis type null=Item, 2=Lot based. defaults to null=Item.
3049:
3050: -- abb H

Line 3527: from wsm_starting_lots_interface wsli,

3523:
3524: begin
3525: select 1
3526: into l_no_of_records
3527: from wsm_starting_lots_interface wsli,
3528: wsm_lot_split_merges_interface wlsmi
3529: where wsli.lot_number = v_wlji_job_name(v_index)
3530: and wsli.header_id = wlsmi.header_id
3531: and wlsmi.process_status in (1,2);

Line 4734: process_invalid_field( 'Last Updated By in WSM_STARTING_LOTS_INTERFACE',

4730: when too_many_rows then l_no_of_records := 1;
4731: when no_data_found then
4732: l_error_code := -1;
4733: l_aux_mesg := '';
4734: process_invalid_field( 'Last Updated By in WSM_STARTING_LOTS_INTERFACE',
4735: l_aux_mesg,
4736: l_stmt_num);
4737: end;
4738: end if;

Line 4768: process_invalid_field( 'CREATED BY in WSM_STARTING_LOTS_INTERFACE',

4764: when too_many_rows then l_no_of_records := 1;
4765: when no_data_found then
4766: l_error_code := -1;
4767: l_aux_mesg := '';
4768: process_invalid_field( 'CREATED BY in WSM_STARTING_LOTS_INTERFACE',
4769: l_aux_mesg,
4770: l_stmt_num);
4771: end;
4772: end if;

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

5044: l_quantity_tobe_issued := v_wsli(v_wlji_source_line_id(v_index)).comp_issue_quantity;
5045: end if;
5046: end if;
5047: l_stmt_num := 648;
5048: -- if the user does not provide a revision in wsm_starting_lots_interface
5049: -- then get the current revision and use that to issue components. if user
5050: -- provides one, validate it
5051:
5052: l_source_item_rev := v_wsli(v_wlji_source_line_id(v_index)).revision;

Line 7713: delete from wsm_starting_lots_interface

7709: -- bug 3126758
7710: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
7711:
7712: if l_atleast_one_row_in_mmtt <> 0 then
7713: delete from wsm_starting_lots_interface
7714: where header_id IN
7715: (select wlji.source_line_id
7716: from wsm_lot_job_interface wlji
7717: where wlji.process_status = 5