APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_LINE_TYPES_VL

Line 1622: FROM po_line_types_vl po2 WHERE upper(p1.line_type) = upper(po2.line_type(+))

1618:
1619: update pon_item_prices_interface p1
1620: set (line_type_id,order_type_lookup_code,purchase_basis,outside_operation_flag) =
1621: (select nvl(po2.line_type_id,-9999), po2.order_type_lookup_code,po2.purchase_basis,po2.outside_operation_flag
1622: FROM po_line_types_vl po2 WHERE upper(p1.line_type) = upper(po2.line_type(+))
1623: and (po2.inactive_date is null or po2.inactive_date > sysdate))
1624: where batch_id = p_batch_id
1625: and line_type <> 'LINE_TYPE_NONE_ENTERED'
1626: and line_type is not null;