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 279: -- corresponding table type and table declarations for wsm_starting_lots_interface

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

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

277: -- 2-Phantom requirement does not exists
278: -- ==============================================================================================
279: -- corresponding table type and table declarations for wsm_starting_lots_interface
280: -- ==============================================================================================
281: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
282: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;

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

278: -- ==============================================================================================
279: -- corresponding table type and table declarations for wsm_starting_lots_interface
280: -- ==============================================================================================
281: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
282: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;

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

279: -- corresponding table type and table declarations for wsm_starting_lots_interface
280: -- ==============================================================================================
281: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
282: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;

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

280: -- ==============================================================================================
281: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
282: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;

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

281: type t_wsli_header_id is table of wsm_starting_lots_interface.header_id%type;
282: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;

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

282: type t_wsli_lot_number is table of wsm_starting_lots_interface.lot_number%type;
283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
290: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;

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

283: type t_wsli_inventory_item_id is table of wsm_starting_lots_interface.inventory_item_id%type;
284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
290: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
291: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;

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

284: type t_wsli_organization_id is table of wsm_starting_lots_interface.organization_id%type;
285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
290: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
291: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
292: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;

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

285: type t_wsli_quantity is table of wsm_starting_lots_interface.quantity%type;
286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
290: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
291: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
292: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
293:

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

286: type t_wsli_subinventory_code is table of wsm_starting_lots_interface.subinventory_code%type;
287: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
290: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
291: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
292: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
293:
294: v_wsli_hdr_id t_wsli_header_id := t_wsli_header_id();

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

288: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
289: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
290: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
291: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
292: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
293:
294: v_wsli_hdr_id t_wsli_header_id := t_wsli_header_id();
295: v_wsli_lot_number t_wsli_lot_number := t_wsli_lot_number();
296: v_wsli_inventory_item_id t_wsli_inventory_item_id := t_wsli_inventory_item_id();

Line 312: lot_number wsm_starting_lots_interface.lot_number%type,

308: -- creating an index by table that'll store the wsli values with header_id as the index for easy
309: -- validation
310: -- ==============================================================================================
311: type rec_wsli IS record (
312: lot_number wsm_starting_lots_interface.lot_number%type,
313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,

Line 313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,

309: -- validation
310: -- ==============================================================================================
311: type rec_wsli IS record (
312: lot_number wsm_starting_lots_interface.lot_number%type,
313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,

Line 314: organization_id wsm_starting_lots_interface.organization_id%type,

310: -- ==============================================================================================
311: type rec_wsli IS record (
312: lot_number wsm_starting_lots_interface.lot_number%type,
313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,

Line 315: quantity wsm_starting_lots_interface.quantity%type,

311: type rec_wsli IS record (
312: lot_number wsm_starting_lots_interface.lot_number%type,
313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,

Line 316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,

312: lot_number wsm_starting_lots_interface.lot_number%type,
313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
320: created_by wsm_starting_lots_interface.created_by%type,

Line 317: locator_id wsm_starting_lots_interface.locator_id%type,

313: inventory_item_id wsm_starting_lots_interface.inventory_item_id%type,
314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
320: created_by wsm_starting_lots_interface.created_by%type,
321: primary_uom_code mtl_system_items.primary_uom_code%type,

Line 318: revision wsm_starting_lots_interface.revision%type,

314: organization_id wsm_starting_lots_interface.organization_id%type,
315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
320: created_by wsm_starting_lots_interface.created_by%type,
321: primary_uom_code mtl_system_items.primary_uom_code%type,
322: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type

Line 319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,

315: quantity wsm_starting_lots_interface.quantity%type,
316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
320: created_by wsm_starting_lots_interface.created_by%type,
321: primary_uom_code mtl_system_items.primary_uom_code%type,
322: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type
323: );

Line 320: created_by wsm_starting_lots_interface.created_by%type,

316: subinventory_code wsm_starting_lots_interface.subinventory_code%type,
317: locator_id wsm_starting_lots_interface.locator_id%type,
318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
320: created_by wsm_starting_lots_interface.created_by%type,
321: primary_uom_code mtl_system_items.primary_uom_code%type,
322: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type
323: );
324:

Line 322: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type

318: revision wsm_starting_lots_interface.revision%type,
319: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
320: created_by wsm_starting_lots_interface.created_by%type,
321: primary_uom_code mtl_system_items.primary_uom_code%type,
322: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type
323: );
324:
325: v_rec_wsli rec_wsli; -- Not used
326:

Line 7071: l_src_lot_number wsm_starting_lots_interface.lot_number%type;

7067: l_mtl_locator_type number;
7068: l_osp_op_seq_num number;
7069: l_est_scrap_account number;
7070: l_est_scrap_var_account number;
7071: l_src_lot_number wsm_starting_lots_interface.lot_number%type;
7072: l_src_inv_item_id NUMBER;
7073: l_scheduling_mode NUMBER; -- ADD BUG 3479666
7074:
7075: l_job_type_code varchar2(30);

Line 8071: from wsm_starting_lots_interface wsli,

8067: l_num_records := 0;
8068: begin
8069: select 1
8070: into l_num_records
8071: from wsm_starting_lots_interface wsli,
8072: wsm_lot_split_merges_interface wlsmi
8073: where wsli.lot_number = v_wlji_job_name(v_idx)
8074: and wsli.header_id = wlsmi.header_id
8075: and wlsmi.process_status in (1,2);

Line 8964: 'Last Updated By in WSM_STARTING_LOTS_INTERFACE',

8960: when no_data_found then
8961: l_error_code := -1;
8962: l_aux_mesg := '';
8963: handle_invalid_field(
8964: 'Last Updated By in WSM_STARTING_LOTS_INTERFACE',
8965: l_aux_mesg,
8966: l_stmt_num);
8967: l_error_count := l_error_count + 1;
8968: GOTO abort_this_job;

Line 8993: 'Created By in WSM_STARTING_LOTS_INTERFACE',

8989: when no_data_found then
8990: l_error_code := -1;
8991: l_aux_mesg := '';
8992: handle_invalid_field(
8993: 'Created By in WSM_STARTING_LOTS_INTERFACE',
8994: l_aux_mesg,
8995: l_stmt_num);
8996: l_error_count := l_error_count + 1;
8997: GOTO abort_this_job;

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

10789: end if;
10790: end if;
10791:
10792: l_stmt_num := 870;
10793: -- if the user does not provide a revision in wsm_starting_lots_interface
10794: -- then get the current revision and use that to issue components. if user
10795: -- provides one, validate it
10796: l_source_item_rev := v_wsli(v_wlji_src_line_id(v_idx)).revision;
10797: declare

Line 12182: delete from wsm_starting_lots_interface

12178: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
12179:
12180: if l_atleast_one_row_in_mmtt <> 0 then
12181: l_stmt_num := 1100;
12182: delete from wsm_starting_lots_interface
12183: where header_id IN (
12184: select wlji.source_line_id
12185: from wsm_lot_job_interface wlji
12186: where wlji.process_status = 5

Line 20765: from wsm_starting_lots_interface wsli,

20761: wsli.last_updated_by,
20762: wsli.created_by,
20763: msi.primary_uom_code,
20764: wsli.component_issue_quantity
20765: from wsm_starting_lots_interface wsli,
20766: wsm_lot_job_interface wlji,
20767: mtl_system_items msi
20768: where wsli.header_id = wlji.source_line_id
20769: and wlji.group_id = p_group_id

Line 20845: wsm_starting_lots_interface wsli,

20841: mmtt.error_explanation,
20842: wsli.header_id,
20843: wlji.header_id
20844: from mtl_material_transactions_temp mmtt,
20845: wsm_starting_lots_interface wsli,
20846: wsm_lot_job_interface wlji
20847: where mmtt.transaction_header_id = p_header_id
20848: and mmtt.source_line_id = wsli.header_id
20849: and wsli.header_id = wlji.source_line_id;