APPS.CSTPPACQ dependencies on MTL_UNITS_OF_MEASURE

Line 283: mtl_units_of_measure muom

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
286: AND clat.rcv_transaction_id = rt.transaction_id
287: 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 787: mtl_units_of_measure mum1

783: mum1.uom_code
784: INTO
785: l_po_uom
786: FROM
787: mtl_units_of_measure mum1
788: WHERE
789: MUM1.UNIT_OF_measure = l_po_uom_code;
790:
791: l_stmt_num := 70;

Line 798: mtl_units_of_measure mum1

794: mum1.uom_code
795: INTO
796: l_rec_uom
797: FROM
798: mtl_units_of_measure mum1
799: WHERE
800: mum1.unit_of_measure = l_rec_uom_code;
801:
802: l_stmt_num := 30;

Line 1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;

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

Line 1314: FROM mtl_units_of_measure mum1

1310: l_stmt_num := 1060;
1311:
1312: SELECT mum1.uom_code
1313: INTO l_po_uom
1314: FROM mtl_units_of_measure mum1
1315: WHERE MUM1.UNIT_OF_measure = l_po_uom_code;
1316:
1317: IF l_item_id = -1 THEN
1318: l_primary_uom := l_po_uom;

Line 2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;

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

Line 2362: l_rec_uom mtl_units_of_measure.uom_code%TYPE;

2358: l_po_count NUMBER; -- remove this later
2359: l_nr_tax_rate NUMBER;
2360: l_match_option po_line_locations_all.match_option%TYPE;
2361: l_rec_uom_code rcv_transactions.unit_of_measure%TYPE;
2362: l_rec_uom mtl_units_of_measure.uom_code%TYPE;
2363:
2364: BEGIN
2365: If G_DEBUG ='Y' then
2366: fnd_file.put_line(fnd_file.log, 'Transaction: ' ||to_char(l_rec_transaction_id));

Line 2625: mtl_units_of_measure mum1

2621: mum1.uom_code
2622: INTO
2623: l_po_uom
2624: FROM
2625: mtl_units_of_measure mum1
2626: WHERE
2627: MUM1.UNIT_OF_measure = l_po_uom_code;
2628:
2629: l_stmt_num := 71;

Line 2636: mtl_units_of_measure mum1

2632: mum1.uom_code
2633: INTO
2634: l_rec_uom
2635: FROM
2636: mtl_units_of_measure mum1
2637: WHERE
2638: mum1.unit_of_measure = l_rec_uom_code;
2639:
2640: l_stmt_num := 31;