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.CSTPPACQ dependencies on MTL_SYSTEM_ITEMS

Line 287: mtl_system_items msi,

283: cst_cost_group_assignments ccga1,
284: mtl_parameters mp,
285: rcv_transactions rt,
286: rcv_parameters rp,
287: mtl_system_items msi,
288: po_line_locations_all poll,
289: mtl_units_of_measure muom
290: WHERE rt.transaction_date < l_start_date
291: AND clat.transaction_date BETWEEN l_start_date and l_end_date

Line 555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

551: l_rec_ct NUMBER := 0;
552: l_nqr rcv_transactions.quantity%TYPE := 0;
553: l_inv_count number;
554: l_header cst_rcv_acq_costs.header_id%TYPE;
555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
556: l_po_uom mtl_units_of_measure.uom_code%TYPE;
557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

Line 561: l_item_id mtl_system_items.inventory_item_id%TYPE;

557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;
559: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;
561: l_item_id mtl_system_items.inventory_item_id%TYPE;
562: l_org_id rcv_transactions.organization_id%TYPE;
563: l_poll_quantity po_line_locations_all.quantity%TYPE;
564: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
565: l_po_count NUMBER; -- remove this later

Line 816: mtl_system_items msi

812: msi.primary_uom_code
813: INTO
814: l_primary_uom
815: FROM
816: mtl_system_items msi
817: WHERE
818: msi.inventory_item_id = l_item_id AND
819: msi.organization_id = l_org_id;
820: END IF;

Line 1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

1202: l_lcm_acq_cost NUMBER;
1203: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;
1204: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1205: l_nr_tax_rate NUMBER;
1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1209: l_po_price po_lines_all.unit_price%TYPE;
1210: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

Line 1212: l_item_id mtl_system_items.inventory_item_id%TYPE;

1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1209: l_po_price po_lines_all.unit_price%TYPE;
1210: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1211: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1212: l_item_id mtl_system_items.inventory_item_id%TYPE;
1213: l_org_id rcv_transactions.organization_id%TYPE;
1214: BEGIN
1215: l_stmt_num := 1000;
1216: SELECT count(rcv_transaction_id)

Line 1318: FROM mtl_system_items msi

1314: ELSE
1315: l_stmt_num := 1070;
1316: SELECT msi.primary_uom_code
1317: INTO l_primary_uom
1318: FROM mtl_system_items msi
1319: WHERE msi.inventory_item_id = l_item_id
1320: AND msi.organization_id = l_org_id;
1321: END IF;
1322:

Line 1444: l_master_uom_code mtl_system_items.Primary_UOM_CODE%TYPE;

1440: l_uom_control NUMBER;
1441: l_master_org_id NUMBER;
1442: l_avcu_txn_date DATE;
1443: l_um_rate NUMBER;
1444: l_master_uom_code mtl_system_items.Primary_UOM_CODE%TYPE;
1445: BEGIN
1446: l_stmt_num := 1095;
1447: SELECT nvl(max(LANDED_COST_VAR_ACCOUNT),-1),
1448: nvl(max(LANDED_COST_ABS_ACCOUNT),-1)

Line 1463: WHERE mia.attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE'

1459: ccg.organization_id
1460: INTO l_uom_control,l_master_org_id
1461: FROM mtl_item_attributes mia,
1462: cst_cost_groups ccg
1463: WHERE mia.attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE'
1464: AND ccg.cost_group_id = i_cost_group_id;
1465:
1466: l_avcu_txn_date := least(l_end_date,sysdate);
1467:

Line 2017: FROM mtl_system_items msi

2013: END IF;
2014: l_stmt_num := 1268;
2015: SELECT msi.primary_uom_code
2016: INTO l_master_uom_code
2017: FROM mtl_system_items msi
2018: WHERE msi.organization_id = l_master_org_id
2019: AND msi.inventory_item_id = c_rec.inventory_item_id;
2020: l_stmt_num := 1270;
2021: INSERT INTO MTL_MATERIAL_TRANSACTIONS

Line 2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

2296: l_rec_ct NUMBER := 0;
2297: l_nqr rcv_transactions.quantity%TYPE := 0;
2298: l_inv_count number;
2299: l_header cst_rcv_acq_costs.header_id%TYPE;
2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

Line 2306: l_item_id mtl_system_items.inventory_item_id%TYPE;

2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;
2304: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;
2306: l_item_id mtl_system_items.inventory_item_id%TYPE;
2307: l_org_id rcv_transactions.organization_id%TYPE;
2308: l_poll_quantity po_line_locations_all.quantity%TYPE;
2309: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2310: l_po_count NUMBER; -- remove this later

Line 2609: mtl_system_items msi

2605: msi.primary_uom_code
2606: INTO
2607: l_primary_uom
2608: FROM
2609: mtl_system_items msi
2610: WHERE
2611: msi.inventory_item_id = l_item_id AND
2612: msi.organization_id = l_org_id;
2613: END IF;