DBA Data[Home] [Help]

APPS.OE_QUERY dependencies on SO_ORDER_TYPES

Line 715: FROM SO_ORDER_TYPES

711: ORDER_TYPE VARCHAR2(80);
712: BEGIN
713: SELECT NAME
714: INTO ORDER_TYPE
715: FROM SO_ORDER_TYPES
716: WHERE ORDER_TYPE_ID = ID;
717:
718: RETURN(ORDER_TYPE);
719:

Line 843: so_order_types typ

839: begin
840: select typ.name
841: into rtn_value
842: from so_headers ord,
843: so_order_types typ
844: where typ.order_type_id = ord.order_type_id
845: and ord.header_id = decode(rtrim(p_original_system_reference,
846: '0123456789'),
847: null,to_number(p_original_system_reference),