Order Management - EBS (MOSC)

MOSC Banner

Not able to add country of origon column in ordered_item LOV in sales order line level screen in R12

R12.2.9

Not able to add country of origon column in ordered_item LOV in sales order line level screen in R12. I tried by using form personalization. But country of origin column is not getting added into ordered_item lov. Any suggestions.

select items.cross_reference, to_number(null) item_id, nvl(items.description,
sitems.description) item_description, sitems.inventory_item_id,
sitems.attribute15 country_of_origin,
items.cross_reference_type item_identifier_type_meaning,
null item_definition_level ,
null Address,
null cust_address ,
sitems.concatenated_segments inventory_item ,
items.cross_reference_type item_identifier_type,
to_number(NULL) RANK

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center