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.WSMPINVL dependencies on MTL_LOT_NUMBERS

Line 1906: -- existing in wip_entities, mtl_lot_numbers.

1902: -- end of modification by abedajna on 10/12/00 for performance tuning.
1903:
1904:
1905: -- check if the Resulting Lot will create a duplicate lot already
1906: -- existing in wip_entities, mtl_lot_numbers.
1907:
1908:
1909: /* BEGIN
1910: ** SELECT 1

Line 1921: ** FROM mtl_lot_numbers

1917: ** WHERE wip_entity_name = crec.lot_number
1918: ** AND organization_id = crec.organization_id
1919: ** UNION
1920: ** SELECT 1
1921: ** FROM mtl_lot_numbers
1922: ** WHERE lot_number = crec.lot_number
1923: ** );
1924: ** EXCEPTION when others THEN
1925: ** fnd_message.set_name('WSM', 'WSM_VALIDATE_LOT_DUP');

Line 1945: FROM mtl_lot_numbers

1941: WHERE wip_entity_name = crec.lot_number
1942: AND organization_id = crec.organization_id
1943: UNION ALL
1944: SELECT 1
1945: FROM mtl_lot_numbers
1946: WHERE lot_number = crec.lot_number
1947: AND inventory_item_id = crec.inventory_item_id --bugfix 2069033: added item_id condn.
1948: AND organization_id = crec.organization_id; -- 4401205: added org_id
1949: -- Should not be able to create a new lot for the SAME item.

Line 2424: ** exist in wip_entities or mtl_lot_numbers tables

2420:
2421: /*
2422: ** For a MERGE txn, ensure that the Resulting Lot
2423: ** is SAME as the STARTING LOT OR it does NOT exist already
2424: ** exist in wip_entities or mtl_lot_numbers tables
2425: */
2426:
2427: SELECT transaction_type_id
2428: INTO x_transaction_type_id

Line 2444: FROM mtl_lot_numbers

2440: WHERE wip_entity_name = crec.lot_number
2441: AND organization_id = crec.organization_id
2442: UNION ALL
2443: SELECT 1
2444: FROM mtl_lot_numbers
2445: WHERE lot_number = crec.lot_number
2446: AND inventory_item_id = crec.inventory_item_id -- bugfix 2069033: added item_id condn.
2447: AND organization_id = crec.organization_id --4401205 : added org_id
2448: ) -- Should not be able to create a new lot for the SAME item.

Line 3374: mtl_lot_numbers x,

3370: a.locator_id,
3371: a.quantity,
3372: a.representative_flag -- added by sisankar for bug 4920235
3373: FROM
3374: mtl_lot_numbers x,
3375: wsm_starting_lots_interface a
3376: WHERE header_id = p_header_id
3377: AND X.lot_number = a.lot_number
3378: -- bugfix 1995378: added the orgn id and inventory item id condition

Line 3410: l_slot MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;

3406: -- added by BBK for debugging
3407: lProcName VARCHAR2(32) := 'create_mtl_records';
3408:
3409: -- added by sisankar for bug 4920235
3410: l_slot MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
3411: l_sitem MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE;
3412: x_slot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3413: x_rlot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3414: x_rlot_context_entered MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;

Line 3411: l_sitem MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE;

3407: lProcName VARCHAR2(32) := 'create_mtl_records';
3408:
3409: -- added by sisankar for bug 4920235
3410: l_slot MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
3411: l_sitem MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE;
3412: x_slot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3413: x_rlot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3414: x_rlot_context_entered MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3415: l_wms_installed BOOLEAN:=FALSE;

Line 3412: x_slot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;

3408:
3409: -- added by sisankar for bug 4920235
3410: l_slot MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
3411: l_sitem MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE;
3412: x_slot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3413: x_rlot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3414: x_rlot_context_entered MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3415: l_wms_installed BOOLEAN:=FALSE;
3416: l_copy_from_src BOOLEAN:=FALSE;

Line 3413: x_rlot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;

3409: -- added by sisankar for bug 4920235
3410: l_slot MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
3411: l_sitem MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE;
3412: x_slot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3413: x_rlot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3414: x_rlot_context_entered MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3415: l_wms_installed BOOLEAN:=FALSE;
3416: l_copy_from_src BOOLEAN:=FALSE;
3417: l_intf_rec_found BOOLEAN:=FALSE;

Line 3414: x_rlot_context_entered MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;

3410: l_slot MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
3411: l_sitem MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE;
3412: x_slot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3413: x_rlot_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3414: x_rlot_context_entered MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=null;
3415: l_wms_installed BOOLEAN:=FALSE;
3416: l_copy_from_src BOOLEAN:=FALSE;
3417: l_intf_rec_found BOOLEAN:=FALSE;
3418: l_copy_inv_attr BOOLEAN:=FALSE;

Line 3608: -- (select 1 from mtl_lot_numbers mln where mln.lot_number=rlot.lot_number and

3604: x_rlot_context_entered:=null;
3605: end;
3606:
3607: -- select decode(count(1),0,'N','Y') into x_lot_exists from dual where exists
3608: -- (select 1 from mtl_lot_numbers mln where mln.lot_number=rlot.lot_number and
3609: -- mln.inventory_item_id=rlot.inventory_item_id and
3610: -- mln.organization_id=x_org_id);
3611:
3612: begin

Line 3615: from mtl_lot_numbers mln

3611:
3612: begin
3613: select 'Y'
3614: into x_lot_exists
3615: from mtl_lot_numbers mln
3616: where mln.lot_number=rlot.lot_number
3617: and mln.inventory_item_id=rlot.inventory_item_id
3618: and mln.organization_id=x_org_id;
3619: exception

Line 3767: FROM mtl_lot_numbers

3763: ,l_invattr_tbl(12)
3764: ,l_invattr_tbl(13)
3765: ,l_invattr_tbl(14)
3766: ,l_invattr_tbl(15)
3767: FROM mtl_lot_numbers
3768: WHERE lot_number=l_slot
3769: AND inventory_item_id=l_sitem
3770: AND organization_id= x_org_id;
3771:

Line 3953: FROM mtl_lot_numbers

3949: ,l_invattr_tbl(12)
3950: ,l_invattr_tbl(13)
3951: ,l_invattr_tbl(14)
3952: ,l_invattr_tbl(15)
3953: FROM mtl_lot_numbers
3954: WHERE lot_number=l_slot
3955: AND inventory_item_id=l_sitem
3956: AND organization_id= x_org_id;
3957:

Line 4648: from MTL_LOT_NUMBERS mln

4644: ,mln.attribute12
4645: ,mln.attribute13
4646: ,mln.attribute14
4647: ,mln.attribute15
4648: from MTL_LOT_NUMBERS mln
4649: where mln.LOT_NUMBER = X_lot_number
4650: and mln.ORGANIZATION_ID = X_Organization_Id
4651: and mln.INVENTORY_ITEM_ID = X_Inventory_Item_Id;
4652: