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 949: FROM rcv_transactions rt, mtl_units_of_measure muom

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

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

1500: x_msg_count OUT NOCOPY NUMBER,
1501: x_msg_data OUT NOCOPY VARCHAR2,
1502: p_event_rec IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1503: x_transaction_qty OUT NOCOPY NUMBER,
1504: x_primary_uom OUT NOCOPY mtl_units_of_measure.unit_of_measure%TYPE,
1505: x_primary_qty OUT NOCOPY NUMBER,
1506: x_trx_uom_code OUT NOCOPY VARCHAR2
1507: )
1508: IS

Line 1518: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;

1514: -- local data variables
1515: l_item_id NUMBER;
1516: l_primary_uom_rate NUMBER;
1517: l_trx_uom_rate NUMBER;
1518: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1519: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1520: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1521: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1522: BEGIN

Line 1519: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;

1515: l_item_id NUMBER;
1516: l_primary_uom_rate NUMBER;
1517: l_trx_uom_rate NUMBER;
1518: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1519: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1520: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1521: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1522: BEGIN
1523: SAVEPOINT convert_uom_pvt;

Line 1520: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;

1516: l_primary_uom_rate NUMBER;
1517: l_trx_uom_rate NUMBER;
1518: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1519: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1520: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1521: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1522: BEGIN
1523: SAVEPOINT convert_uom_pvt;
1524:

Line 1521: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

1517: l_trx_uom_rate NUMBER;
1518: l_primary_uom_code mtl_units_of_measure.uom_code%TYPE;
1519: l_source_doc_uom_code mtl_units_of_measure.uom_code%TYPE;
1520: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
1521: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1522: BEGIN
1523: SAVEPOINT convert_uom_pvt;
1524:
1525: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1561: FROM mtl_units_of_measure

1557:
1558: -- Get UOM code for the source document's UOM
1559: SELECT uom_code
1560: INTO l_source_doc_uom_code
1561: FROM mtl_units_of_measure
1562: WHERE unit_of_measure = p_event_rec.source_doc_uom;
1563:
1564: -- Get UOM code for the transaction UOM
1565: SELECT uom_code

Line 1567: FROM mtl_units_of_measure

1563:
1564: -- Get UOM code for the transaction UOM
1565: SELECT uom_code
1566: INTO l_trx_uom_code
1567: FROM mtl_units_of_measure
1568: WHERE unit_of_measure = p_event_rec.transaction_uom;
1569:
1570: -- Get UOM for this item/org from MSI and populate primary_uom with it
1571: IF (l_item_id IS NULL)

Line 1579: FROM mtl_units_of_measure tuom, mtl_units_of_measure puom

1575: l_stmt_num := 20;
1576:
1577: SELECT puom.uom_code, puom.unit_of_measure
1578: INTO l_primary_uom_code, l_primary_uom
1579: FROM mtl_units_of_measure tuom, mtl_units_of_measure puom
1580: WHERE tuom.unit_of_measure = p_event_rec.source_doc_uom
1581: AND tuom.uom_class = puom.uom_class
1582: AND puom.base_uom_flag = 'Y';
1583:

Line 1598: FROM mtl_units_of_measure

1594: l_stmt_num := 40;
1595:
1596: SELECT unit_of_measure
1597: INTO l_primary_uom
1598: FROM mtl_units_of_measure
1599: WHERE uom_code = l_primary_uom_code;
1600: END IF;
1601:
1602: -- Get the UOM rate from source_doc_uom to primary_uom

Line 4252: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;

4248: l_currency_conversion_type VARCHAR2 (30);
4249: l_incr_transfer_price NUMBER := 0;
4250: l_incr_currency_code VARCHAR2 (15) := NULL;
4251: l_dest_org_id NUMBER;
4252: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
4253: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
4254: l_primary_qty NUMBER;
4255: l_credit_acct_id NUMBER;
4256: l_debit_acct_id NUMBER;

Line 4253: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;

4249: l_incr_transfer_price NUMBER := 0;
4250: l_incr_currency_code VARCHAR2 (15) := NULL;
4251: l_dest_org_id NUMBER;
4252: l_trx_uom_code mtl_units_of_measure.uom_code%TYPE;
4253: l_primary_uom mtl_units_of_measure.unit_of_measure%TYPE;
4254: l_primary_qty NUMBER;
4255: l_credit_acct_id NUMBER;
4256: l_debit_acct_id NUMBER;
4257: l_ic_cogs_acct_id NUMBER;