APPS.CSTPPACQ dependencies on MTL_UNITS_OF_MEASURE

Line 289: mtl_units_of_measure muom

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
292: AND clat.rcv_transaction_id = rt.transaction_id
293: AND ccga1.cost_group_id = i_cost_group_id

Line 556: l_po_uom mtl_units_of_measure.uom_code%TYPE;

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;
560: l_po_line_loc po_lines_all.po_line_id%TYPE;

Line 569: l_rec_uom mtl_units_of_measure.uom_code%TYPE;

565: l_po_count NUMBER; -- remove this later
566: l_nr_tax_rate NUMBER;
567: l_match_option po_line_locations_all.match_option%TYPE;
568: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
569: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
570:
571: BEGIN
572: If G_DEBUG ='Y' then
573: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(c_rec.transaction_id));

Line 784: mtl_units_of_measure mum1

780: mum1.uom_code
781: INTO
782: l_po_uom
783: FROM
784: mtl_units_of_measure mum1
785: WHERE
786: MUM1.UNIT_OF_measure = l_po_uom_code;
787:
788: l_stmt_num := 70;

Line 795: mtl_units_of_measure mum1

791: mum1.uom_code
792: INTO
793: l_rec_uom
794: FROM
795: mtl_units_of_measure mum1
796: WHERE
797: mum1.unit_of_measure = l_rec_uom_code;
798:
799: l_stmt_num := 30;

Line 1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;

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;
1211: l_po_line_loc po_line_locations_all.line_location_id%TYPE;

Line 1309: FROM mtl_units_of_measure mum1

1305: l_stmt_num := 1060;
1306:
1307: SELECT mum1.uom_code
1308: INTO l_po_uom
1309: FROM mtl_units_of_measure mum1
1310: WHERE MUM1.UNIT_OF_measure = l_po_uom_code;
1311:
1312: IF l_item_id = -1 THEN
1313: l_primary_uom := l_po_uom;

Line 2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;

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;
2305: l_po_line_loc po_lines_all.po_line_id%TYPE;

Line 2314: l_rec_uom mtl_units_of_measure.uom_code%TYPE;

2310: l_po_count NUMBER; -- remove this later
2311: l_nr_tax_rate NUMBER;
2312: l_match_option po_line_locations_all.match_option%TYPE;
2313: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
2314: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2315:
2316: BEGIN
2317: If G_DEBUG ='Y' then
2318: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(c_rec.transaction_id));

Line 2577: mtl_units_of_measure mum1

2573: mum1.uom_code
2574: INTO
2575: l_po_uom
2576: FROM
2577: mtl_units_of_measure mum1
2578: WHERE
2579: MUM1.UNIT_OF_measure = l_po_uom_code;
2580:
2581: l_stmt_num := 71;

Line 2588: mtl_units_of_measure mum1

2584: mum1.uom_code
2585: INTO
2586: l_rec_uom
2587: FROM
2588: mtl_units_of_measure mum1
2589: WHERE
2590: mum1.unit_of_measure = l_rec_uom_code;
2591:
2592: l_stmt_num := 31;