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.GMF_RCV_ACCOUNTING_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 955: FROM rcv_transactions rt, mtl_units_of_measure muom

951: -- The l_ic_pricing_option can only be 2 for a source type of 'RECEIVING'.
952: -- Get the UOM of the source_doc since unit price is desired in Document's UOM
953: SELECT muom.uom_code
954: INTO l_transaction_uom
955: FROM rcv_transactions rt, mtl_units_of_measure muom
956: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
957: AND muom.unit_of_measure = rt.source_doc_unit_of_measure;
958:
959: -- While calling the transfer pricing API, the from organization id should be

Line 1510: x_primary_uom OUT NOCOPY mtl_units_of_measure.unit_of_measure%TYPE,

1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2,
1508: p_event_rec IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1509: x_transaction_qty OUT NOCOPY NUMBER,
1510: x_primary_uom OUT NOCOPY mtl_units_of_measure.unit_of_measure%TYPE,
1511: x_primary_qty OUT NOCOPY NUMBER,
1512: x_trx_uom_code OUT NOCOPY VARCHAR2
1513: )
1514: IS

Line 1524: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;

1520: -- local data variables
1521: l_item_id NUMBER;
1522: l_primary_uom_rate NUMBER;
1523: l_trx_uom_rate NUMBER;
1524: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1525: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1526: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1527: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1528: BEGIN

Line 1525: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;

1521: l_item_id NUMBER;
1522: l_primary_uom_rate NUMBER;
1523: l_trx_uom_rate NUMBER;
1524: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1525: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1526: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1527: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1528: BEGIN
1529: SAVEPOINT convert_uom_pvt;

Line 1526: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;

1522: l_primary_uom_rate NUMBER;
1523: l_trx_uom_rate NUMBER;
1524: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1525: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1526: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1527: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1528: BEGIN
1529: SAVEPOINT convert_uom_pvt;
1530:

Line 1527: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1523: l_trx_uom_rate NUMBER;
1524: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1525: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1526: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1527: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1528: BEGIN
1529: SAVEPOINT convert_uom_pvt;
1530:
1531: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1567: FROM mtl_units_of_measure

1563:
1564: -- Get UOM code for the source document's UOM
1565: SELECT uom_code
1566: INTO l_source_doc_uom_code
1567: FROM mtl_units_of_measure
1568: WHERE unit_of_measure = p_event_rec.source_doc_uom;
1569:
1570: -- Get UOM code for the transaction UOM
1571: SELECT uom_code

Line 1573: FROM mtl_units_of_measure

1569:
1570: -- Get UOM code for the transaction UOM
1571: SELECT uom_code
1572: INTO l_trx_uom_code
1573: FROM mtl_units_of_measure
1574: WHERE unit_of_measure = p_event_rec.transaction_uom;
1575:
1576: -- Get UOM for this item/org from MSI and populate primary_uom with it
1577: IF (l_item_id IS NULL)

Line 1585: FROM mtl_units_of_measure tuom, mtl_units_of_measure puom

1581: l_stmt_num := 20;
1582:
1583: SELECT puom.uom_code, puom.unit_of_measure
1584: INTO l_primary_uom_code, l_primary_uom
1585: FROM mtl_units_of_measure tuom, mtl_units_of_measure puom
1586: WHERE tuom.unit_of_measure = p_event_rec.source_doc_uom
1587: AND tuom.uom_class = puom.uom_class
1588: AND puom.base_uom_flag = 'Y';
1589:

Line 1604: FROM mtl_units_of_measure

1600: l_stmt_num := 40;
1601:
1602: SELECT unit_of_measure
1603: INTO l_primary_uom
1604: FROM mtl_units_of_measure
1605: WHERE uom_code = l_primary_uom_code;
1606: END IF;
1607:
1608: -- Get the UOM rate from source_doc_uom to primary_uom

Line 4258: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;

4254: l_currency_conversion_type VARCHAR2 (30);
4255: l_incr_transfer_price NUMBER := 0;
4256: l_incr_currency_code VARCHAR2 (15) := NULL;
4257: l_dest_org_id NUMBER;
4258: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
4259: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
4260: l_primary_qty NUMBER;
4261: l_credit_acct_id NUMBER;
4262: l_debit_acct_id NUMBER;

Line 4259: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

4255: l_incr_transfer_price NUMBER := 0;
4256: l_incr_currency_code VARCHAR2 (15) := NULL;
4257: l_dest_org_id NUMBER;
4258: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
4259: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
4260: l_primary_qty NUMBER;
4261: l_credit_acct_id NUMBER;
4262: l_debit_acct_id NUMBER;
4263: l_ic_cogs_acct_id NUMBER;