DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on AR_LOOKUPS

Line 5172: get description from ar_lookups */

5168: o line_type = 'FREIGHT'
5169: if vat = 'Y' and freight_as_line = 'Y' and freight_item not null
5170: get description from mtl_system_items
5171: else
5172: get description from ar_lookups */
5173:
5174: -- per bug 2382340, take out the dependency on AR_ALLOW_TAX_CODE_OVERRIDE.
5175: -- IF l_vat_flag = 'Y' AND l_freight_as_line = 'Y'AND l_freight_item IS NOT NULL THEN
5176: BEGIN

Line 5190: FROM ar_lookups

5186: SELECT meaning
5187: ,NULL
5188: INTO p_x_charges_rec.Description
5189: ,p_x_charges_rec.Uom_Code
5190: FROM ar_lookups
5191: WHERE lookup_type = 'STD_LINE_TYPE'
5192: AND lookup_code = 'FREIGHT';
5193: END IF;
5194: