APPS.OE_QUERY dependencies on SO_HEADERS

Line 703: -- Input a Order_Type_Id, search for so_headers to get the Order_Type

699: END ; -- ITEM
700:
701:
702: ------------------------------------------------------------------------
703: -- Input a Order_Type_Id, search for so_headers to get the Order_Type
704: -- of that line.
705: ------------------------------------------------------------------------
706: function ORDER_TYPE(
707: ID IN NUMBER DEFAULT NULL

Line 816: from so_headers ord

812: if P_ORIGINAL_SYSTEM_SOURCE_CODE = '2' then
813: begin
814: select to_char(ord.order_number)
815: into rtn_value
816: from so_headers ord
817: where ord.header_id = decode(rtrim(p_original_system_reference,
818: '0123456789'),
819: null,to_number(p_original_system_reference),
820: null);

Line 842: from so_headers ord,

838: if P_ORIGINAL_SYSTEM_SOURCE_CODE = '2' then
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'),

Line 1761: from so_headers

1757: org_id NUMBER := NULL;
1758: Begin
1759: SELECT org_id
1760: INTO org_id
1761: from so_headers
1762: where rownum = 1;
1763:
1764: if org_id IS NULL Then
1765: return(NULL);