APPS.INV_LABEL_PVT7 dependencies on FND_COMMON_LOOKUPS

Line 329: FROM FND_COMMON_LOOKUPS

325: ,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
326: ,loc.loc_information13 address_line_4,loc.town_or_city city
327: ,loc.postal_code postal_code,loc.region_2 state,loc.region_1 county
328: ,loc.country country, DECODE(LOC.STYLE,'CA',(SELECT MEANING
329: FROM FND_COMMON_LOOKUPS
330: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
331: AND LOOKUP_CODE = LOC.REGION_1
332: AND ROWNUM < 2),
333: 'CA_GLB',(SELECT MEANING

Line 334: FROM FND_COMMON_LOOKUPS

330: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
331: AND LOOKUP_CODE = LOC.REGION_1
332: AND ROWNUM < 2),
333: 'CA_GLB',(SELECT MEANING
334: FROM FND_COMMON_LOOKUPS
335: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
336: AND LOOKUP_CODE = LOC.REGION_1
337: AND ROWNUM < 2),
338: LOC.REGION_3) PROVINCE -- Modified for bug 7281160

Line 354: FROM FND_COMMON_LOOKUPS

350: ,loc.address_line_2 address_line_2,loc.address_line_3 address_line_3
351: ,loc.loc_information13 address_line_4,loc.town_or_city city
352: ,loc.postal_code postal_code,loc.region_2 state,loc.region_1 county
353: ,loc.country country, DECODE(LOC.STYLE,'CA',(SELECT MEANING
354: FROM FND_COMMON_LOOKUPS
355: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
356: AND LOOKUP_CODE = LOC.REGION_1
357: AND ROWNUM < 2),
358: 'CA_GLB',(SELECT MEANING

Line 359: FROM FND_COMMON_LOOKUPS

355: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
356: AND LOOKUP_CODE = LOC.REGION_1
357: AND ROWNUM < 2),
358: 'CA_GLB',(SELECT MEANING
359: FROM FND_COMMON_LOOKUPS
360: WHERE LOOKUP_TYPE = 'CA_PROVINCE'
361: AND LOOKUP_CODE = LOC.REGION_1
362: AND ROWNUM < 2),
363: LOC.REGION_3) PROVINCE -- Modified for bug 7281160

Line 375: , fnd_common_lookups fcl

371: wsh_new_deliveries wnd,
372: wsh_delivery_legs wdl,
373: wsh_document_instances wdi
374: -- Bug 2878652, get carrier name and ship method name
375: , fnd_common_lookups fcl
376: -- Bug 5121507 Getting Carrier in the order of Trip->Delivery
377: --, wsh_carriers_v wcv
378: , wsh_trip_stops wts
379: , wsh_trips wt