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

Line 343: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL

339: , p_secondary_uom IN VARCHAR2 := NULL
340:
341: --Bug No 3952081
342: --Add arguments to intake new OPM attributes of the lot
343: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
344: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
345: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
346: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
347: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL

Line 344: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL

340:
341: --Bug No 3952081
342: --Add arguments to intake new OPM attributes of the lot
343: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
344: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
345: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
346: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
347: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
348: )

Line 345: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL

341: --Bug No 3952081
342: --Add arguments to intake new OPM attributes of the lot
343: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
344: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
345: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
346: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
347: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
348: )
349: RETURN NUMBER IS

Line 346: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL

342: --Add arguments to intake new OPM attributes of the lot
343: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
344: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
345: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
346: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
347: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
348: )
349: RETURN NUMBER IS
350: -- Bug# 2032659 Beginning

Line 347: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL

343: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
344: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
345: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
346: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
347: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
348: )
349: RETURN NUMBER IS
350: -- Bug# 2032659 Beginning
351: l_description VARCHAR(250) := NULL;

Line 423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;

419: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
420:
421: --Bug No 3952081
422: --Add variables to hold existent OPM attributes of the lot
423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
424: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
425: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
426: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
427: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;

Line 424: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;

420:
421: --Bug No 3952081
422: --Add variables to hold existent OPM attributes of the lot
423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
424: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
425: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
426: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
427: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
428: BEGIN

Line 425: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;

421: --Bug No 3952081
422: --Add variables to hold existent OPM attributes of the lot
423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
424: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
425: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
426: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
427: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
428: BEGIN
429:

Line 426: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;

422: --Add variables to hold existent OPM attributes of the lot
423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
424: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
425: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
426: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
427: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
428: BEGIN
429:
430:

Line 427: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;

423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
424: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
425: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
426: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
427: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
428: BEGIN
429:
430:
431: -- Bug# 2032659

Line 432: -- If Lot exists already, take the attributes from MTL_LOT_NUMBERS, else

428: BEGIN
429:
430:
431: -- Bug# 2032659
432: -- If Lot exists already, take the attributes from MTL_LOT_NUMBERS, else
433: -- take the input attribute values. This has to be done, because, in mobile
434: -- transactions, Lot Attribute page is not visited if the lot transaction
435: -- involves already exisiting lot and because of this MTLT will get populated without attribute
436: -- values. Later, MTL_TRANSACTION_LOT_NUMBERS will also get populated without attribute

Line 441: -- from MTL_LOT_NUMBERS if Lot already exists.

437: -- values. Form 'Material Transactions' is built on a view with base table
438: -- MTL_TRANSACTION_LOT_NUMBERS. And for transactions that were done with existing
439: -- lot, lot attributes weren't visible in this form. This problem is solved
440: -- right in the beginning of transaction life, ie., by populating MTLT attribute values
441: -- from MTL_LOT_NUMBERS if Lot already exists.
442: BEGIN
443: SELECT description
444: , vendor_name
445: , supplier_lot_number

Line 577: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt

573: , l_n_attribute9
574: , l_n_attribute10
575: , l_vendor_id
576: , l_territory_code
577: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt
578: WHERE mln.lot_number = LTRIM(RTRIM(p_lot_number))
579: AND mmtt.transaction_temp_id = p_trx_tmp_id
580: AND mln.organization_id = mmtt.organization_id
581: AND mln.inventory_item_id = mmtt.inventory_item_id;