APPS.MTL_MOVEMENT_RPT_PKG dependencies on FND_TERRITORIES_VL

Line 385: in (select territory_code from fnd_territories_vl)

381: 'D', mms.destination_territory_code,
382: 'DA', mms.destination_territory_code,
383: 'A', mms.dispatch_territory_code,
384: 'AA', mms.dispatch_territory_code)
385: in (select territory_code from fnd_territories_vl)
386: and decode(P_MOVEMENT_TYPE,
387: 'D',mms.dispatch_territory_code,
388: 'DA', mms.dispatch_territory_code,
389: 'A', mms.destination_territory_code,

Line 444: in (select territory_code from fnd_territories_vl)

440: 'D', mms.destination_territory_code,
441: 'DA', mms.destination_territory_code,
442: 'A', mms.dispatch_territory_code,
443: 'AA', mms.dispatch_territory_code)
444: in (select territory_code from fnd_territories_vl)
445: and decode(P_MOVEMENT_TYPE,
446: 'D',mms.dispatch_territory_code,
447: 'DA', mms.dispatch_territory_code,
448: 'A', mms.destination_territory_code,

Line 494: in (select territory_code from fnd_territories_vl)

490: 'D', mms.destination_territory_code,
491: 'DA', mms.destination_territory_code,
492: 'A', mms.dispatch_territory_code,
493: 'AA', mms.dispatch_territory_code)
494: in (select territory_code from fnd_territories_vl)
495: and decode(P_MOVEMENT_TYPE,
496: 'D',mms.dispatch_territory_code,
497: 'DA', mms.dispatch_territory_code,
498: 'A', mms.destination_territory_code,

Line 618: in (select territory_code from fnd_territories_vl)

614: 'D', mms.destination_territory_code,
615: 'DA', mms.destination_territory_code,
616: 'A', mms.dispatch_territory_code,
617: 'AA', mms.dispatch_territory_code)
618: in (select territory_code from fnd_territories_vl)
619: and decode(P_MOVEMENT_TYPE,
620: 'D',mms.dispatch_territory_code,
621: 'DA', mms.dispatch_territory_code,
622: 'A', mms.destination_territory_code,

Line 674: in (select territory_code from fnd_territories_vl)

670: 'D', mms.destination_territory_code,
671: 'DA', mms.destination_territory_code,
672: 'A', mms.dispatch_territory_code,
673: 'AA', mms.dispatch_territory_code)
674: in (select territory_code from fnd_territories_vl)
675: and decode(P_MOVEMENT_TYPE,
676: 'D',mms.dispatch_territory_code,
677: 'DA', mms.dispatch_territory_code,
678: 'A', mms.destination_territory_code,

Line 715: in (select territory_code from fnd_territories_vl)

711: 'D', mms.destination_territory_code,
712: 'DA', mms.destination_territory_code,
713: 'A', mms.dispatch_territory_code,
714: 'AA', mms.dispatch_territory_code)
715: in (select territory_code from fnd_territories_vl)
716: and decode(P_MOVEMENT_TYPE,
717: 'D',mms.dispatch_territory_code,
718: 'DA', mms.dispatch_territory_code,
719: 'A', mms.destination_territory_code,

Line 756: in (select territory_code from fnd_territories_vl)

752: 'D', mms.destination_territory_code,
753: 'DA', mms.destination_territory_code,
754: 'A', mms.dispatch_territory_code,
755: 'AA', mms.dispatch_territory_code)
756: in (select territory_code from fnd_territories_vl)
757: and decode(P_MOVEMENT_TYPE,
758: 'D',mms.dispatch_territory_code,
759: 'DA', mms.dispatch_territory_code,
760: 'A', mms.destination_territory_code,