APPS.MSC_M2A_PUSH dependencies on MSC_DESIGNATORS

Line 485: FROM MSC_DESIGNATORS

481: and compile_designator = pDESIGNATOR;
482: CURSOR c2(c_org_id in number) is
483: SELECT PRODUCTION , ORGANIZATION_ID, DESIGNATOR_TYPE,
484: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
485: FROM MSC_DESIGNATORS
486: WHERE designator = pDESIGNATOR
487: AND sr_instance_id = pINSTANCE_ID
488: AND organization_id = c_org_id
489: AND designator_type <> G_MPS_IND;

Line 493: FROM MSC_DESIGNATORS

489: AND designator_type <> G_MPS_IND;
490: CURSOR c3(c_org_id in number) is
491: SELECT PRODUCTION , ORGANIZATION_ID, DESIGNATOR_TYPE,
492: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN
493: FROM MSC_DESIGNATORS
494: WHERE designator = pDESIGNATOR
495: AND sr_instance_id = pINSTANCE_ID
496: AND organization_id = c_org_id
497: AND designator_type = G_MPS_IND;

Line 591: ||' FROM MSC_DESIGNATORS '

587: ||' ATTRIBUTE15 , '
588: ||' ORGANIZATION_SELECTION , '
589: ||' DECODE(DESIGNATOR_TYPE,4,1,2) ,'
590: ||' PRODUCTION '
591: ||' FROM MSC_DESIGNATORS '
592: ||' WHERE designator = :pDESIGNATOR '
593: ||' AND sr_instance_id = :pINSTANCE_ID '
594: ||' AND organization_id = :organization_id '
595: ||' AND designator_type <> '|| G_MPS_IND;

Line 730: ||' FROM MSC_DESIGNATORS '

726: || G_MPS_IND ||' , '
727: ||' INVENTORY_ATP_FLAG , '
728: ||' DEMAND_CLASS , '
729: ||' PRODUCTION '
730: ||' FROM MSC_DESIGNATORS '
731: ||' WHERE designator = :pDESIGNATOR '
732: ||' AND sr_instance_id = :pINSTANCE_ID '
733: ||' AND organization_id = :organization_id '
734: ||' AND designator_type = ' || G_MPS_IND;