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 281: mtl_system_items msi,

277: cst_cost_group_assignments ccga1,
278: mtl_parameters mp,
279: rcv_transactions rt,
280: rcv_parameters rp,
281: mtl_system_items msi,
282: po_line_locations_all poll,
283: mtl_units_of_measure muom
284: WHERE rt.transaction_date < l_start_date
285: 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 819: mtl_system_items msi

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

Line 1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

1207: l_lcm_acq_cost NUMBER;
1208: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;
1209: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1210: l_nr_tax_rate NUMBER;
1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1214: l_po_price po_lines_all.unit_price%TYPE;
1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

Line 1217: l_item_id mtl_system_items.inventory_item_id%TYPE;

1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
1214: l_po_price po_lines_all.unit_price%TYPE;
1215: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
1216: l_po_line_loc po_line_locations_all.line_location_id%TYPE;
1217: l_item_id mtl_system_items.inventory_item_id%TYPE;
1218: l_org_id rcv_transactions.organization_id%TYPE;
1219: BEGIN
1220: l_stmt_num := 1000;
1221: SELECT count(rcv_transaction_id)

Line 1323: FROM mtl_system_items msi

1319: ELSE
1320: l_stmt_num := 1070;
1321: SELECT msi.primary_uom_code
1322: INTO l_primary_uom
1323: FROM mtl_system_items msi
1324: WHERE msi.inventory_item_id = l_item_id
1325: AND msi.organization_id = l_org_id;
1326: END IF;
1327:

Line 1451: l_master_uom_code mtl_system_items.Primary_UOM_CODE%TYPE;

1447: l_uom_control NUMBER;
1448: l_master_org_id NUMBER;
1449: l_avcu_txn_date DATE;
1450: l_um_rate NUMBER;
1451: l_master_uom_code mtl_system_items.Primary_UOM_CODE%TYPE;
1452: BEGIN
1453: l_stmt_num := 1095;
1454: SELECT nvl(max(LANDED_COST_VAR_ACCOUNT),-1),
1455: nvl(max(LANDED_COST_ABS_ACCOUNT),-1)

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

1466: ccg.organization_id
1467: INTO l_uom_control,l_master_org_id
1468: FROM mtl_item_attributes mia,
1469: cst_cost_groups ccg
1470: WHERE mia.attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE'
1471: AND ccg.cost_group_id = i_cost_group_id;
1472:
1473: l_avcu_txn_date := least(l_end_date,sysdate);
1474:

Line 2024: FROM mtl_system_items msi

2020: END IF;
2021: l_stmt_num := 1268;
2022: SELECT msi.primary_uom_code
2023: INTO l_master_uom_code
2024: FROM mtl_system_items msi
2025: WHERE msi.organization_id = l_master_org_id
2026: AND msi.inventory_item_id = c_rec.inventory_item_id;
2027: l_stmt_num := 1270;
2028: INSERT INTO MTL_MATERIAL_TRANSACTIONS

Line 2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

2344: l_rec_ct NUMBER := 0;
2345: l_nqr rcv_transactions.quantity%TYPE := 0;
2346: l_inv_count number;
2347: l_header cst_rcv_acq_costs.header_id%TYPE;
2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;

Line 2354: l_item_id mtl_system_items.inventory_item_id%TYPE;

2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;
2352: l_rate rcv_transactions.CURRENCY_CONVERSION_RATE%TYPE;
2353: l_po_line_loc po_lines_all.po_line_id%TYPE;
2354: l_item_id mtl_system_items.inventory_item_id%TYPE;
2355: l_org_id rcv_transactions.organization_id%TYPE;
2356: l_poll_quantity po_line_locations_all.quantity%TYPE;
2357: l_pri_poll_quantity po_line_locations_all.quantity%TYPE;
2358: l_po_count NUMBER; -- remove this later

Line 2657: mtl_system_items msi

2653: msi.primary_uom_code
2654: INTO
2655: l_primary_uom
2656: FROM
2657: mtl_system_items msi
2658: WHERE
2659: msi.inventory_item_id = l_item_id AND
2660: msi.organization_id = l_org_id;
2661: END IF;

Line 4091: l_master_uom_code mtl_system_items.Primary_UOM_CODE%TYPE;

4087: /*Bug 12659949*/
4088: l_uom_control NUMBER;
4089: l_master_org_id NUMBER;
4090: l_um_rate NUMBER;
4091: l_master_uom_code mtl_system_items.Primary_UOM_CODE%TYPE;
4092: l_err_num NUMBER;
4093: l_err_code VARCHAR2(240);
4094: l_err_msg VARCHAR2(240);
4095: PROCESS_ERROR EXCEPTION;

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

4465: ccg.organization_id
4466: INTO l_uom_control,l_master_org_id
4467: FROM mtl_item_attributes mia,
4468: cst_cost_groups ccg
4469: WHERE mia.attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE'
4470: AND ccg.cost_group_id = i_cost_group_id;
4471:
4472: l_stmt_num := 120;
4473: SELECT msi.primary_uom_code

Line 4475: FROM mtl_system_items msi

4471:
4472: l_stmt_num := 120;
4473: SELECT msi.primary_uom_code
4474: INTO l_master_uom_code
4475: FROM mtl_system_items msi
4476: WHERE msi.organization_id = l_master_org_id
4477: AND msi.inventory_item_id = l_item;
4478:
4479: l_stmt_num := 130;