DBA Data[Home] [Help]

APPS.OE_CUSTACCEPTREP_PVT dependencies on OE_LOOKUPS

Line 169: from oe_lookups

165: --myerrams, Bug: 5480694
166: IF g_sorted_by IS NOT NULL
167: THEN
168: select meaning into l_sorted_by
169: from oe_lookups
170: where lookup_type='OECARR_ORDER_BY'
171: and lookup_code=g_sorted_by;
172: END IF;
173: --myerrams, end

Line 179: from oe_lookups

175: --myerrams, Bug: 5480694
176: IF g_acceptance_status IS NOT NULL
177: THEN
178: select meaning into l_acceptance_status
179: from oe_lookups
180: where lookup_type='OECARR_ACC_STATUS'
181: and lookup_code = g_acceptance_status;
182: END IF;
183:

Line 184: --myerrams, Selecting the appropriate Item Display Name from OE Lookups

180: where lookup_type='OECARR_ACC_STATUS'
181: and lookup_code = g_acceptance_status;
182: END IF;
183:
184: --myerrams, Selecting the appropriate Item Display Name from OE Lookups
185: IF g_item_display IS NOT NULL
186: THEN
187: select meaning into l_item_display
188: from OE_LOOKUPS

Line 188: from OE_LOOKUPS

184: --myerrams, Selecting the appropriate Item Display Name from OE Lookups
185: IF g_item_display IS NOT NULL
186: THEN
187: select meaning into l_item_display
188: from OE_LOOKUPS
189: where lookup_type = 'ITEM_DISPLAY_CODE'
190: and LOOKUP_CODE=g_item_display;
191: END IF;
192: --myerrams, end