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

Line 114: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

110: l_incr_transfer_price NUMBER := 0;
111: l_incr_currency_code VARCHAR2(15) := NULL;
112:
113: l_dest_org_id NUMBER;
114: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
115: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
116: l_primary_qty NUMBER;
117: l_credit_acct_id NUMBER;
118: l_debit_acct_id NUMBER;

Line 115: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

111: l_incr_currency_code VARCHAR2(15) := NULL;
112:
113: l_dest_org_id NUMBER;
114: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
115: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
116: l_primary_qty NUMBER;
117: l_credit_acct_id NUMBER;
118: l_debit_acct_id NUMBER;
119: l_ic_cogs_acct_id NUMBER;

Line 1395: FROM rcv_transactions RT, mtl_units_of_measure MUOM

1391: -- The l_ic_pricing_option can only be 2 for a source type of 'RECEIVING'.
1392: -- Get the UOM of the source_doc since unit price is desired in Document's UOM
1393: SELECT MUOM.uom_code
1394: INTO l_transaction_uom
1395: FROM rcv_transactions RT, mtl_units_of_measure MUOM
1396: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1397: AND MUOM.unit_of_measure = RT.source_doc_unit_of_measure;
1398:
1399: -- While calling the transfer pricing API, the from organization id should be

Line 1904: X_PRIMARY_UOM OUT NOCOPY MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE,

1900: X_MSG_COUNT OUT NOCOPY NUMBER,
1901: X_MSG_DATA OUT NOCOPY VARCHAR2,
1902: P_EVENT_REC IN RCV_SeedEvents_PVT.rcv_event_rec_type,
1903: X_TRANSACTION_QTY OUT NOCOPY NUMBER,
1904: X_PRIMARY_UOM OUT NOCOPY MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE,
1905: X_PRIMARY_QTY OUT NOCOPY NUMBER,
1906: X_TRX_UOM_CODE OUT NOCOPY VARCHAR2
1907: ) IS
1908:

Line 1919: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1915: -- local data variables
1916: l_item_id NUMBER;
1917: l_primary_uom_rate NUMBER;
1918: l_trx_uom_rate NUMBER;
1919: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1920: l_source_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1921: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1922: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
1923:

Line 1920: l_source_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1916: l_item_id NUMBER;
1917: l_primary_uom_rate NUMBER;
1918: l_trx_uom_rate NUMBER;
1919: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1920: l_source_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1921: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1922: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
1923:
1924: BEGIN

Line 1921: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1917: l_primary_uom_rate NUMBER;
1918: l_trx_uom_rate NUMBER;
1919: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1920: l_source_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1921: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1922: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
1923:
1924: BEGIN
1925:

Line 1922: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

1918: l_trx_uom_rate NUMBER;
1919: l_primary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1920: l_source_doc_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1921: l_trx_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1922: l_primary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
1923:
1924: BEGIN
1925:
1926: SAVEPOINT Convert_UOM_PVT;

Line 1959: FROM mtl_units_of_measure

1955:
1956: -- Get UOM code for the source document's UOM
1957: SELECT uom_code
1958: INTO l_source_doc_uom_code
1959: FROM mtl_units_of_measure
1960: WHERE unit_of_measure = p_event_rec.source_doc_uom;
1961:
1962: -- Get UOM code for the transaction UOM
1963: SELECT uom_code

Line 1965: FROM mtl_units_of_measure

1961:
1962: -- Get UOM code for the transaction UOM
1963: SELECT uom_code
1964: INTO l_trx_uom_code
1965: FROM mtl_units_of_measure
1966: WHERE unit_of_measure = p_event_rec.transaction_uom;
1967:
1968:
1969: -- Get UOM for this item/org from MSI and populate primary_uom with it

Line 1977: FROM mtl_units_of_measure TUOM,

1973: -- base uom for the item's current uom class
1974: l_stmt_num := 20;
1975: SELECT PUOM.uom_code, PUOM.unit_of_measure
1976: INTO l_primary_uom_code, l_primary_uom
1977: FROM mtl_units_of_measure TUOM,
1978: mtl_units_of_measure PUOM
1979: WHERE TUOM.unit_of_measure = p_event_rec.source_doc_uom
1980: AND TUOM.uom_class = PUOM.uom_class
1981: AND PUOM.base_uom_flag = 'Y';

Line 1978: mtl_units_of_measure PUOM

1974: l_stmt_num := 20;
1975: SELECT PUOM.uom_code, PUOM.unit_of_measure
1976: INTO l_primary_uom_code, l_primary_uom
1977: FROM mtl_units_of_measure TUOM,
1978: mtl_units_of_measure PUOM
1979: WHERE TUOM.unit_of_measure = p_event_rec.source_doc_uom
1980: AND TUOM.uom_class = PUOM.uom_class
1981: AND PUOM.base_uom_flag = 'Y';
1982:

Line 1995: FROM mtl_units_of_measure

1991:
1992: l_stmt_num := 40;
1993: SELECT unit_of_measure
1994: INTO l_primary_uom
1995: FROM mtl_units_of_measure
1996: WHERE uom_code = l_primary_uom_code;
1997: END IF;
1998:
1999: -- Get the UOM rate from source_doc_uom to primary_uom