APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_LOT_NUMBERS

Line 10137: FROM MTL_LOT_NUMBERS MLN

10133: mln.d_attribute1, mln.d_attribute2, mln.d_attribute3, mln.d_attribute4, mln.d_attribute5,
10134: mln.d_attribute6, mln.d_attribute7, mln.d_attribute8, mln.d_attribute9, mln.d_attribute10,
10135: mln.n_attribute1, mln.n_attribute2, mln.n_attribute3, mln.n_attribute4, mln.n_attribute5,
10136: mln.n_attribute6, mln.n_attribute7, mln.n_attribute8, mln.n_attribute9, mln.n_attribute10
10137: FROM MTL_LOT_NUMBERS MLN
10138: WHERE mln.lot_number = Ltrim(Rtrim(p_lot_number))
10139: AND mln.organization_id = p_org_id
10140: AND mln.inventory_item_id = p_item_id
10141: ;

Line 18094: l_mln_rec mtl_lot_numbers%ROWTYPE ;

18090: l_rti_PRIMARY_UNIT_OF_MEASURE VARCHAR2(25);
18091: l_rti_UNIT_OF_MEASURE VARCHAR2(25);
18092: l_rti_UOM_CODE VARCHAR2(3) ;
18093: l_rti_SECONDARY_UOM_CODE VARCHAR2(3) ;
18094: l_mln_rec mtl_lot_numbers%ROWTYPE ;
18095: l_sourcedoc_unit_of_measure VARCHAR2(25);
18096: l_rti_SEC_UNIT_OF_MEASURE VARCHAR2(25);
18097: /* end INVCONV */
18098:

Line 18549: FROM MTL_LOT_NUMBERS

18545: /* IF (l_discrete_transaction) THEN */
18546:
18547: SELECT 1,parent_lot_number
18548: INTO L_LOT_EXISTS ,l_parent_lot_number
18549: FROM MTL_LOT_NUMBERS
18550: WHERE ORGANIZATION_ID = L_ORG_ID
18551: AND INVENTORY_ITEM_ID = L_ITEM_ID
18552: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
18553:

Line 21474: MTL_LOT_NUMBERS as is done for discrete items.

21470:
21471: BEGIN
21472: /* INVCONV, Remove OPM specific ic_lots_mst logic
21473: Validation of Lot existence for OPM items shall be done from
21474: MTL_LOT_NUMBERS as is done for discrete items.
21475: If it exists then we shall validate its parent lot also.
21476: Remove OPM fork.Add parent_lot_number in discrete query.Punit Kumar */
21477:
21478: /*IF (l_discrete_transaction) THEN */

Line 21481: FROM MTL_LOT_NUMBERS

21477:
21478: /*IF (l_discrete_transaction) THEN */
21479: SELECT 1,parent_lot_number
21480: INTO L_LOT_EXISTS ,l_parent_lot_number
21481: FROM MTL_LOT_NUMBERS
21482: WHERE ORGANIZATION_ID = L_ORG_ID
21483: AND INVENTORY_ITEM_ID = L_ITEM_ID
21484: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
21485:

Line 22912: FROM MTL_LOT_NUMBERS

22908: BEGIN
22909: ----IF (l_discrete_transaction) THEN
22910: SELECT 1,parent_lot_number
22911: INTO L_LOT_EXISTS ,l_parent_lot_number
22912: FROM MTL_LOT_NUMBERS
22913: WHERE ORGANIZATION_ID = L_ORG_ID
22914: AND INVENTORY_ITEM_ID = L_ITEM_ID
22915: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
22916:

Line 25945: FROM MTL_LOT_NUMBERS

25941: ----- IF (l_discrete_transaction) THEN
25942:
25943: SELECT 1,parent_lot_number
25944: INTO L_LOT_EXISTS ,l_parent_lot_number
25945: FROM MTL_LOT_NUMBERS
25946: WHERE ORGANIZATION_ID = L_ORG_ID
25947: AND INVENTORY_ITEM_ID = L_ITEM_ID
25948: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
25949: