APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_LOT_NUMBERS

Line 10614: FROM MTL_LOT_NUMBERS MLN

10610: mln.d_attribute1, mln.d_attribute2, mln.d_attribute3, mln.d_attribute4, mln.d_attribute5,
10611: mln.d_attribute6, mln.d_attribute7, mln.d_attribute8, mln.d_attribute9, mln.d_attribute10,
10612: mln.n_attribute1, mln.n_attribute2, mln.n_attribute3, mln.n_attribute4, mln.n_attribute5,
10613: mln.n_attribute6, mln.n_attribute7, mln.n_attribute8, mln.n_attribute9, mln.n_attribute10
10614: FROM MTL_LOT_NUMBERS MLN
10615: WHERE mln.lot_number = Ltrim(Rtrim(p_lot_number))
10616: AND mln.organization_id = p_org_id
10617: AND mln.inventory_item_id = p_item_id
10618: ;

Line 19103: l_mln_rec mtl_lot_numbers%ROWTYPE ;

19099: l_rti_PRIMARY_UNIT_OF_MEASURE VARCHAR2(25);
19100: l_rti_UNIT_OF_MEASURE VARCHAR2(25);
19101: l_rti_UOM_CODE VARCHAR2(3) ;
19102: l_rti_SECONDARY_UOM_CODE VARCHAR2(3) ;
19103: l_mln_rec mtl_lot_numbers%ROWTYPE ;
19104: l_sourcedoc_unit_of_measure VARCHAR2(25);
19105: l_rti_SEC_UNIT_OF_MEASURE VARCHAR2(25);
19106: /* end INVCONV */
19107:

Line 19625: FROM MTL_LOT_NUMBERS

19621: /* IF (l_discrete_transaction) THEN */
19622:
19623: SELECT 1,parent_lot_number
19624: INTO L_LOT_EXISTS ,l_parent_lot_number
19625: FROM MTL_LOT_NUMBERS
19626: WHERE ORGANIZATION_ID = L_ORG_ID
19627: AND INVENTORY_ITEM_ID = L_ITEM_ID
19628: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
19629:

Line 22669: MTL_LOT_NUMBERS as is done for discrete items.

22665:
22666: BEGIN
22667: /* INVCONV, Remove OPM specific ic_lots_mst logic
22668: Validation of Lot existence for OPM items shall be done from
22669: MTL_LOT_NUMBERS as is done for discrete items.
22670: If it exists then we shall validate its parent lot also.
22671: Remove OPM fork.Add parent_lot_number in discrete query.Punit Kumar */
22672:
22673: /*IF (l_discrete_transaction) THEN */

Line 22676: FROM MTL_LOT_NUMBERS

22672:
22673: /*IF (l_discrete_transaction) THEN */
22674: SELECT 1,parent_lot_number
22675: INTO L_LOT_EXISTS ,l_parent_lot_number
22676: FROM MTL_LOT_NUMBERS
22677: WHERE ORGANIZATION_ID = L_ORG_ID
22678: AND INVENTORY_ITEM_ID = L_ITEM_ID
22679: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
22680:

Line 24159: FROM MTL_LOT_NUMBERS

24155: BEGIN
24156: ----IF (l_discrete_transaction) THEN
24157: SELECT 1,parent_lot_number
24158: INTO L_LOT_EXISTS ,l_parent_lot_number
24159: FROM MTL_LOT_NUMBERS
24160: WHERE ORGANIZATION_ID = L_ORG_ID
24161: AND INVENTORY_ITEM_ID = L_ITEM_ID
24162: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
24163:

Line 26775: FROM MTL_LOT_NUMBERS

26771: ----- IF (l_discrete_transaction) THEN
26772:
26773: SELECT 1,parent_lot_number
26774: INTO L_LOT_EXISTS ,l_parent_lot_number
26775: FROM MTL_LOT_NUMBERS
26776: WHERE ORGANIZATION_ID = L_ORG_ID
26777: AND INVENTORY_ITEM_ID = L_ITEM_ID
26778: AND LOT_NUMBER = Ltrim(Rtrim(L_MTLT_REC.lot_number));
26779: