APPS.MSC_CL_GMP_UTILITY dependencies on GMD_OPERATIONS

Line 765: TYPE oprn_no_typ IS TABLE OF gmd_operations.oprn_no%TYPE INDEX BY

761: BINARY_INTEGER;
762: gt_seq_dep_class seq_dep_class_typ ;
763: empty_seq_dep_class seq_dep_class_typ ;
764: --
765: TYPE oprn_no_typ IS TABLE OF gmd_operations.oprn_no%TYPE INDEX BY
766: BINARY_INTEGER;
767: gt_oprn_no oprn_no_typ ;
768: empty_oprn_no oprn_no_typ ;
769:

Line 2304: ||' gmd_operations'||at_apps_link||' fom, '

2300: ||' FROM sy_uoms_mst'||at_apps_link||' sou, '
2301: ||' sy_uoms_mst'||at_apps_link||' sou2, '
2302: ||' cr_rsrc_dtl'||at_apps_link||' crd, '
2303: ||' fm_rout_dtl'||at_apps_link||' frd, '
2304: ||' gmd_operations'||at_apps_link||' fom, '
2305: ||' gmd_operation_activities'||at_apps_link||' goa, '
2306: ||' gmd_operation_resources'||at_apps_link||' gor '
2307: ||' WHERE frd.routing_id IN ( select /*+ DRIVING_SITE(grb) DRIVING_SITE(ffe) DRIVING_SITE(gs) */ unique grb.routing_id ' -- Bug:6156957 Vpedarla added this where condition
2308: ||' FROM gmd_recipes_b '||at_apps_link||' grb, '

Line 2446: ||' gmd_operations'||at_apps_link||' fom, '

2442: ||' goa.offset_interval, '
2443: /* NAMIT_RD */
2444: ||' sou.uom_code '
2445: ||' FROM fm_rout_dtl'||at_apps_link||' frd, '
2446: ||' gmd_operations'||at_apps_link||' fom, '
2447: ||' gmd_operation_activities'||at_apps_link||' goa, '
2448: ||' gmd_operation_resources'||at_apps_link||' gor, '
2449: /* NAMIT_RD */
2450: ||' sy_uoms_mst'||at_apps_link||' sou '

Line 7657: ||' gmd_operations'||at_apps_link||' o '

7653: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
7654: ||' gmp_sequence_types'||at_apps_link||' s, '
7655: ||' gmd_operation_resources'||at_apps_link||' r, '
7656: ||' gmd_operation_activities'||at_apps_link||' a, '
7657: ||' gmd_operations'||at_apps_link||' o '
7658: ||' WHERE o.oprn_id = a.oprn_id '
7659: ||' AND a.oprn_line_id = r.oprn_line_id '
7660: ||' AND rd.orgn_code = sy.orgn_code '
7661: ||' AND sy.resource_whse_code = iwm.whse_code '

Line 7684: ||' gmd_operations'||at_apps_link||' o, '

7680: ||' FROM '
7681: ||' gmp_sequence_types'||at_apps_link||' s, '
7682: ||' gmd_operation_resources'||at_apps_link||' r, '
7683: ||' gmd_operation_activities'||at_apps_link||' a, '
7684: ||' gmd_operations'||at_apps_link||' o, '
7685: ||' (SELECT pcrd.resource_id prim_resource_id, '
7686: ||' pcrd.resources prim_resources, '
7687: ||' acrd.resource_id alt_resource_id, '
7688: ||' acrd.resources alt_resources, '

Line 7730: ||' gmd_operations'||at_apps_link||' o '

7726: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
7727: ||' gmp_sequence_types'||at_apps_link||' s, '
7728: ||' gmd_operation_resources'||at_apps_link||' r, '
7729: ||' gmd_operation_activities'||at_apps_link||' a, '
7730: ||' gmd_operations'||at_apps_link||' o '
7731: ||' WHERE o.oprn_id = a.oprn_id '
7732: ||' AND a.oprn_line_id = r.oprn_line_id '
7733: ||' AND rd.orgn_code = sy.orgn_code '
7734: ||' AND sy.resource_whse_code = iwm.whse_code '

Line 7757: ||' gmd_operations'||at_apps_link||' o, '

7753: ||' FROM '
7754: ||' gmp_sequence_types'||at_apps_link||' s, '
7755: ||' gmd_operation_resources'||at_apps_link||' r, '
7756: ||' gmd_operation_activities'||at_apps_link||' a, '
7757: ||' gmd_operations'||at_apps_link||' o, '
7758: ||' (SELECT pcrd.resource_id prim_resource_id, '
7759: ||' pcrd.resources prim_resources, '
7760: ||' acrd.resource_id alt_resource_id, '
7761: ||' acrd.resources alt_resources, '