37: l_attribute_display_value := NULL;
38: END;
39: elsif l_attribute_code = 'SALES_CREDIT_TYPE_ID' then
40: l_attribute_display_value :=
41: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);
42: elsif l_attribute_code = 'ACCOUNTING_RULE_ID' then
43: l_attribute_display_value :=
44: OE_ID_TO_VALUE.accounting_rule(attribute_value);
45: elsif l_attribute_code = 'AGREEMENT_ID' then
40: l_attribute_display_value :=
41: OE_ID_TO_VALUE.Sales_credit_type(attribute_value);
42: elsif l_attribute_code = 'ACCOUNTING_RULE_ID' then
43: l_attribute_display_value :=
44: OE_ID_TO_VALUE.accounting_rule(attribute_value);
45: elsif l_attribute_code = 'AGREEMENT_ID' then
46: l_attribute_display_value :=
47: OE_ID_TO_VALUE.agreement(attribute_value);
48: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
43: l_attribute_display_value :=
44: OE_ID_TO_VALUE.accounting_rule(attribute_value);
45: elsif l_attribute_code = 'AGREEMENT_ID' then
46: l_attribute_display_value :=
47: OE_ID_TO_VALUE.agreement(attribute_value);
48: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
49: l_attribute_display_value :=
50: OE_ID_TO_VALUE.conversion_type(attribute_value);
51: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
46: l_attribute_display_value :=
47: OE_ID_TO_VALUE.agreement(attribute_value);
48: elsif l_attribute_code = 'CONVERSION_TYPE_CODE' then
49: l_attribute_display_value :=
50: OE_ID_TO_VALUE.conversion_type(attribute_value);
51: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
52: l_attribute_display_value :=
53: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);
54: elsif l_attribute_code = 'DELIVER_TO_ORG_ID' then
49: l_attribute_display_value :=
50: OE_ID_TO_VALUE.conversion_type(attribute_value);
51: elsif l_attribute_code = 'DELIVER_TO_CONTACT_ID' then
52: l_attribute_display_value :=
53: OE_ID_TO_VALUE.Deliver_to_contact(attribute_value);
54: elsif l_attribute_code = 'DELIVER_TO_ORG_ID' then
55: IF attribute_value is not null then
56: BEGIN
57: SELECT LOCATION
63: END;
64: END IF;
65: elsif l_attribute_code = 'FOB_POINT_CODE' then
66: l_attribute_display_value :=
67: OE_ID_TO_VALUE.fob_point(attribute_value);
68: elsif l_attribute_code = 'FREIGHT_TERMS_CODE' then
69: l_attribute_display_value :=
70: OE_ID_TO_VALUE.freight_terms(attribute_value);
71: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
66: l_attribute_display_value :=
67: OE_ID_TO_VALUE.fob_point(attribute_value);
68: elsif l_attribute_code = 'FREIGHT_TERMS_CODE' then
69: l_attribute_display_value :=
70: OE_ID_TO_VALUE.freight_terms(attribute_value);
71: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
72: l_attribute_display_value :=
73: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);
74: elsif l_attribute_code = 'INVOICE_TO_ORG_ID' then
69: l_attribute_display_value :=
70: OE_ID_TO_VALUE.freight_terms(attribute_value);
71: elsif l_attribute_code = 'INVOICE_TO_CONTACT_ID' then
72: l_attribute_display_value :=
73: OE_ID_TO_VALUE.Invoice_to_contact(attribute_value);
74: elsif l_attribute_code = 'INVOICE_TO_ORG_ID' then
75: IF attribute_value is not null then
76: BEGIN
77: SELECT LOCATION
83: END;
84: END IF;
85: elsif l_attribute_code = 'INVOICING_RULE_ID' then
86: l_attribute_display_value :=
87: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);
88: elsif l_attribute_code = 'ORDER_TYPE_ID' then
89: l_attribute_display_value :=
90: OE_ID_TO_VALUE.Order_type(attribute_value);
91: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
86: l_attribute_display_value :=
87: OE_ID_TO_VALUE.Invoicing_rule(attribute_value);
88: elsif l_attribute_code = 'ORDER_TYPE_ID' then
89: l_attribute_display_value :=
90: OE_ID_TO_VALUE.Order_type(attribute_value);
91: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
92: l_attribute_display_value :=
93: OE_ID_TO_VALUE.Payment_Term(attribute_value);
94: elsif l_attribute_code = 'PRICE_LIST_ID' then
89: l_attribute_display_value :=
90: OE_ID_TO_VALUE.Order_type(attribute_value);
91: elsif l_attribute_code = 'PAYMENT_TERM_ID' then
92: l_attribute_display_value :=
93: OE_ID_TO_VALUE.Payment_Term(attribute_value);
94: elsif l_attribute_code = 'PRICE_LIST_ID' then
95: l_attribute_display_value :=
96: OE_ID_TO_VALUE.Price_List(attribute_value);
97: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
92: l_attribute_display_value :=
93: OE_ID_TO_VALUE.Payment_Term(attribute_value);
94: elsif l_attribute_code = 'PRICE_LIST_ID' then
95: l_attribute_display_value :=
96: OE_ID_TO_VALUE.Price_List(attribute_value);
97: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
98: l_attribute_display_value :=
99: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);
100: elsif l_attribute_code = 'SHIP_FROM_ORG_ID' then
95: l_attribute_display_value :=
96: OE_ID_TO_VALUE.Price_List(attribute_value);
97: elsif l_attribute_code = 'SHIPMENT_PRIORITY_CODE' then
98: l_attribute_display_value :=
99: OE_ID_TO_VALUE.Shipment_Priority(attribute_value);
100: elsif l_attribute_code = 'SHIP_FROM_ORG_ID' then
101: IF attribute_value is not null then
102: BEGIN
103: SELECT name
108: END;
109: END IF;
110: elsif l_attribute_code = 'SHIP_TO_CONTACT_ID' then
111: l_attribute_display_value :=
112: OE_ID_TO_VALUE.Ship_to_contact(attribute_value);
113: elsif l_attribute_code = 'SHIP_TO_ORG_ID' then
114: IF attribute_value is not null then
115: BEGIN
116: SELECT LOCATION
122: END;
123: END IF;
124: elsif l_attribute_code = 'SOLD_TO_CONTACT_ID' then
125: l_attribute_display_value :=
126: OE_ID_TO_VALUE.Sold_to_contact(attribute_value);
127: elsif l_attribute_code = 'SOLD_TO_ORG_ID' then
128: IF attribute_value is not null then
129: BEGIN
130: SELECT SUBSTR(HZP.PARTY_NAME,1,50) name
135: END;
136: END IF;
137: elsif l_attribute_code = 'TAX_EXEMPT_FLAG' then
138: l_attribute_display_value :=
139: OE_ID_TO_VALUE.tax_exempt(attribute_value);
140: elsif l_attribute_code = 'TAX_EXEMPT_REASON_CODE' then
141: l_attribute_display_value :=
142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
143: elsif l_attribute_code = 'RETURN_REASON_CODE' then
138: l_attribute_display_value :=
139: OE_ID_TO_VALUE.tax_exempt(attribute_value);
140: elsif l_attribute_code = 'TAX_EXEMPT_REASON_CODE' then
141: l_attribute_display_value :=
142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
143: elsif l_attribute_code = 'RETURN_REASON_CODE' then
144: l_attribute_display_value :=
145: OE_ID_TO_VALUE.Return_Reason(attribute_value);
146: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
141: l_attribute_display_value :=
142: OE_ID_TO_VALUE.tax_exempt_reason(attribute_value);
143: elsif l_attribute_code = 'RETURN_REASON_CODE' then
144: l_attribute_display_value :=
145: OE_ID_TO_VALUE.Return_Reason(attribute_value);
146: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
147: l_attribute_display_value :=
148: OE_ID_TO_VALUE.Ship_method(attribute_value);
149: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
144: l_attribute_display_value :=
145: OE_ID_TO_VALUE.Return_Reason(attribute_value);
146: elsif l_attribute_code = 'SHIPPING_METHOD_CODE' then
147: l_attribute_display_value :=
148: OE_ID_TO_VALUE.Ship_method(attribute_value);
149: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
150: l_attribute_display_value :=
151: OE_ID_TO_VALUE.source_type(attribute_value);
152: elsif l_attribute_code = 'CALCULATE_PRICE_FLAG' then
147: l_attribute_display_value :=
148: OE_ID_TO_VALUE.Ship_method(attribute_value);
149: elsif l_attribute_code = 'SOURCE_TYPE_CODE' then
150: l_attribute_display_value :=
151: OE_ID_TO_VALUE.source_type(attribute_value);
152: elsif l_attribute_code = 'CALCULATE_PRICE_FLAG' then
153: IF attribute_value in ('Y','N','P') THEN
154: BEGIN
155: SELECT meaning
162: l_attribute_display_value := NULL;
163: END IF;
164: elsif l_attribute_code = 'OVER_SHIP_REASON_CODE' then
165: l_attribute_display_value :=
166: OE_ID_TO_VALUE.over_ship_reason(attribute_value);
167: elsif l_attribute_code = 'INVENTORY_ITEM_ID' then
168: l_attribute_display_value :=
169: OE_ID_TO_VALUE.Inventory_Item(attribute_value);
170: elsif l_attribute_code = 'DISCOUNT_ID' then
165: l_attribute_display_value :=
166: OE_ID_TO_VALUE.over_ship_reason(attribute_value);
167: elsif l_attribute_code = 'INVENTORY_ITEM_ID' then
168: l_attribute_display_value :=
169: OE_ID_TO_VALUE.Inventory_Item(attribute_value);
170: elsif l_attribute_code = 'DISCOUNT_ID' then
171: if attribute_value is not null then
172: BEGIN
173: SELECT name