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 471: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL

467: , p_secondary_uom IN VARCHAR2 --Bug# 8204534,we shouldn't assign it to NULL
468:
469: --Bug No 3952081
470: --Add arguments to intake new OPM attributes of the lot
471: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
472: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
473: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
474: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
475: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL

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

468:
469: --Bug No 3952081
470: --Add arguments to intake new OPM attributes of the lot
471: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
472: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
473: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
474: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
475: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
476: )

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

469: --Bug No 3952081
470: --Add arguments to intake new OPM attributes of the lot
471: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
472: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
473: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
474: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
475: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
476: )
477: RETURN NUMBER IS

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

470: --Add arguments to intake new OPM attributes of the lot
471: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
472: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
473: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
474: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
475: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
476: )
477: RETURN NUMBER IS
478: -- Bug# 2032659 Beginning

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

471: , p_parent_lot_number IN MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL
472: , p_origination_type IN MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL
473: , p_expriration_action_date IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL
474: , p_expriration_action_code IN MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL
475: , p_hold_date IN MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL
476: )
477: RETURN NUMBER IS
478: -- Bug# 2032659 Beginning
479: l_description VARCHAR(250) := NULL;

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

547: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
548:
549: --Bug No 3952081
550: --Add variables to hold existent OPM attributes of the lot
551: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
552: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
553: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
554: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
555: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;

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

548:
549: --Bug No 3952081
550: --Add variables to hold existent OPM attributes of the lot
551: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
552: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
553: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
554: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
555: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
556: BEGIN

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

549: --Bug No 3952081
550: --Add variables to hold existent OPM attributes of the lot
551: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
552: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
553: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
554: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
555: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
556: BEGIN
557:

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

550: --Add variables to hold existent OPM attributes of the lot
551: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
552: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
553: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
554: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
555: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
556: BEGIN
557:
558:

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

551: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;
552: l_origination_type MTL_LOT_NUMBERS.ORIGINATION_TYPE%TYPE := NULL;
553: l_expriration_action_date MTL_LOT_NUMBERS.EXPIRATION_ACTION_DATE%TYPE := NULL;
554: l_expriration_action_code MTL_LOT_NUMBERS.EXPIRATION_ACTION_CODE%TYPE := NULL;
555: l_hold_date MTL_LOT_NUMBERS.HOLD_DATE%TYPE := NULL;
556: BEGIN
557:
558:
559: -- Bug# 2032659

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

556: BEGIN
557:
558:
559: -- Bug# 2032659
560: -- If Lot exists already, take the attributes from MTL_LOT_NUMBERS, else
561: -- take the input attribute values. This has to be done, because, in mobile
562: -- transactions, Lot Attribute page is not visited if the lot transaction
563: -- involves already exisiting lot and because of this MTLT will get populated without attribute
564: -- values. Later, MTL_TRANSACTION_LOT_NUMBERS will also get populated without attribute

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

565: -- values. Form 'Material Transactions' is built on a view with base table
566: -- MTL_TRANSACTION_LOT_NUMBERS. And for transactions that were done with existing
567: -- lot, lot attributes weren't visible in this form. This problem is solved
568: -- right in the beginning of transaction life, ie., by populating MTLT attribute values
569: -- from MTL_LOT_NUMBERS if Lot already exists.
570: BEGIN
571: SELECT description
572: , vendor_name
573: , supplier_lot_number

Line 705: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt

701: , l_n_attribute9
702: , l_n_attribute10
703: , l_vendor_id
704: , l_territory_code
705: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt
706: WHERE mln.lot_number = LTRIM(RTRIM(p_lot_number))
707: AND mmtt.transaction_temp_id = p_trx_tmp_id
708: AND mln.organization_id = mmtt.organization_id
709: AND mln.inventory_item_id = mmtt.inventory_item_id;