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_ROI_INTEGRATION_GRP dependencies on MTL_LOT_NUMBERS

Line 1449: P_MLN_REC IN mtl_lot_numbers%ROWTYPE ,

1445: p_secondary_unit_of_measure IN VARCHAR2 ,
1446: p_uom_code IN VARCHAR2 ,
1447: p_secondary_uom_code IN VARCHAR2 ,
1448: p_reason_id IN NUMBER ,
1449: P_MLN_REC IN mtl_lot_numbers%ROWTYPE ,
1450: p_mtlt_rowid IN ROWID
1451: )
1452:
1453: IS

Line 1454: /* copy all values from mtl_lot_numbers for inter org transfer */

1450: p_mtlt_rowid IN ROWID
1451: )
1452:
1453: IS
1454: /* copy all values from mtl_lot_numbers for inter org transfer */
1455: CURSOR C_MLN (l_lot_number VARCHAR2,
1456: l_item_id NUMBER,
1457: l_from_organization_id NUMBER
1458: ) IS

Line 1460: FROM mtl_lot_numbers

1456: l_item_id NUMBER,
1457: l_from_organization_id NUMBER
1458: ) IS
1459: SELECT *
1460: FROM mtl_lot_numbers
1461: WHERE lot_number = l_lot_number
1462: AND inventory_item_id=l_item_id
1463: AND organization_id = l_from_organization_id;
1464:

Line 1467: L_MLN_REC mtl_lot_numbers%ROWTYPE ;

1463: AND organization_id = l_from_organization_id;
1464:
1465: ---local variables declaration
1466: l_lot_rec C_MLN%ROWTYPE ;
1467: L_MLN_REC mtl_lot_numbers%ROWTYPE ;
1468: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
1469: p_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE ;
1470: l_source NUMBER ;
1471: l_permission_value NUMBER ;

Line 1468: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;

1464:
1465: ---local variables declaration
1466: l_lot_rec C_MLN%ROWTYPE ;
1467: L_MLN_REC mtl_lot_numbers%ROWTYPE ;
1468: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE ;
1469: p_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE ;
1470: l_source NUMBER ;
1471: l_permission_value NUMBER ;
1472: l_conv_info_exists NUMBER ;

Line 1558: ----Populate l_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) as follows:

1554: END IF;
1555: RAISE g_exc_unexpected_error;
1556: END IF;
1557:
1558: ----Populate l_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) as follows:
1559: BEGIN
1560:
1561: OPEN C_MLN(p_lot_number,
1562: p_item_id,

Line 1571: mtl_lot-numbers will not have any data.

1567:
1568: /* If the lot in destination org for receive/deliver trx is already existing in the
1569: shipping org then the code works works fine.
1570: However if the lot is also new in the shipping org then the above cursor will fail as
1571: mtl_lot-numbers will not have any data.
1572: In this case erroring out as we cannot do an Inter Org transfer from an org with a new lot.
1573: We can only transfer in an existing lot.
1574: Thsi lot can nevertheless be be new in the destination org.
1575: */

Line 1590: print_debug('inv_new_lot::fetched all records from mtl_lot_numbers(shipping org values)

1586:
1587: ELSE
1588: */
1589: IF g_debug = 1 THEN
1590: print_debug('inv_new_lot::fetched all records from mtl_lot_numbers(shipping org values)
1591: for an Inter Org Transfer:' || l_progress, 1);
1592: END IF;
1593: CLOSE C_MLN;
1594: --- END IF;

Line 1624: Populate p_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) with the lot record coming from validate_lot_serial_info.

1620: ELSE ---------IF p_source_document_code IN ( 'INVENTORY','REQ') THEN
1621:
1622: /*Not an Inter-Org Transfers.
1623: Default the lot attributes from destination item master.
1624: Populate p_lot_rec (MTL_LOT_NUMBERS%ROWTYPE ) with the lot record coming from validate_lot_serial_info.
1625: All these parameters are to be used in the serias of API calls starting Create_Inv_Lot */
1626:
1627: l_lot_rec := P_MLN_REC ;
1628: