APPS.PON_AUCTION_CREATE_PO_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 1968: mtl_units_of_measure mtluom,

1964: ,pbip.CLM_PROMISE_POP_DURATION_UOM
1965: FROM
1966: pon_auction_item_prices_all paip,
1967: pon_bid_item_prices pbip,
1968: mtl_units_of_measure mtluom,
1969: pon_bid_headers pbh,
1970: fnd_currencies fc
1971: WHERE pbip.bid_number = p_bid_number and
1972: pbip.auction_header_id = p_auction_header_id and

Line 3013: mtl_units_of_measure mtluom,

3009:
3010: FROM
3011: pon_auction_item_prices_all paip,
3012: pon_bid_item_prices pbip,
3013: mtl_units_of_measure mtluom,
3014: pon_bid_headers pbh,
3015: fnd_currencies fc,
3016: pon_bid_shipments pbs
3017: WHERE

Line 3109: mtl_units_of_measure where uom_code=

3105:
3106: nvl2(bpys.uom_code, mtluom.unit_of_measure,
3107: decode(paip.order_type_lookup_code, 'QUANTITY',
3108: (select unit_of_measure from
3109: mtl_units_of_measure where uom_code=
3110: paip.uom_code),
3111: null
3112: )
3113: ) , -- unit_of_measure.Populate this for RATE and Qty Milestone

Line 3162: mtl_units_of_measure mtluom

3158: pon_bid_item_prices pbip,
3159: pon_bid_payments_shipments bpys,
3160: pon_auc_payments_shipments apys,
3161: po_lines_interface pli,
3162: mtl_units_of_measure mtluom
3163: WHERE pbip.bid_number = p_bid_number and
3164: pbip.auction_header_id = p_auction_header_id and
3165: nvl(pbip.award_status, 'NO') = 'AWARDED' and
3166: paip.auction_header_id = pbip.auction_header_id and

Line 3407: mtl_units_of_measure mtluom,

3403: , pbip.idv_line_id
3404: , paip.exhibit_number --ELINs project
3405: FROM pon_auction_item_prices_all paip,
3406: pon_bid_item_prices pbip,
3407: mtl_units_of_measure mtluom,
3408: pon_bid_headers pbh,
3409: fnd_currencies fc,
3410: pon_bid_shipments pbs
3411: WHERE pbip.bid_number = p_bid_number and