APPS.GMP_BOM_ROUTING_PKG dependencies on GMD_OPERATIONS

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

677: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY
678: BINARY_INTEGER;
679: gt_seq_dep_class seq_dep_class_typ ;
680: --
681: TYPE oprn_no_typ IS TABLE OF gmd_operations.oprn_no%TYPE INDEX BY
682: BINARY_INTEGER;
683: gt_oprn_no oprn_no_typ ;
684:
685: /* End of changes SGIDUGU - Seq Dep */

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

2100: ||' DECODE(NVL(goa.sequence_dependent_ind,0),1,0,DECODE(gor.prim_rsrc_ind,1,1,0)) is_nonunique, '
2101: ||' NULL setup_id '
2102: ||' FROM cr_rsrc_dtl'||at_apps_link||' crd, '
2103: ||' fm_rout_dtl'||at_apps_link||' frd, '
2104: ||' gmd_operations'||at_apps_link||' fom, '
2105: ||' gmd_operation_activities'||at_apps_link||' goa, '
2106: ||' gmd_operation_resources'||at_apps_link||' gor, '
2107: ||' hr_organization_units'||at_apps_link||' hou1, '
2108: ||' mtl_units_of_measure'||at_apps_link||' mum, '

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

2258: ||' goa.offset_interval, '
2259: ||' gor.resource_usage_uom, ' -- akaruppa changed sou.uom_code to gor.resource_usage_uom
2260: ||' decode(crm.capacity_constraint,1,1,2) ' -- akaruppa added to check if resource is chargeable, used for invalidating the routing if chargeable resource is not defined at the org level
2261: ||' FROM fm_rout_dtl'||at_apps_link||' frd, '
2262: ||' gmd_operations'||at_apps_link||' fom, '
2263: ||' gmd_operation_activities'||at_apps_link||' goa, '
2264: ||' gmd_operation_resources'||at_apps_link||' gor, '
2265: ||' cr_rsrc_mst'||at_apps_link||' crm, '
2266: ||' mtl_units_of_measure'||at_apps_link||' mum '

Line 7416: ||' gmd_operations'||at_apps_link||' o '

7412: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
7413: ||' gmp_sequence_types'||at_apps_link||' s, '
7414: ||' gmd_operation_resources'||at_apps_link||' r, '
7415: ||' gmd_operation_activities'||at_apps_link||' a, '
7416: ||' gmd_operations'||at_apps_link||' o '
7417: ||' WHERE o.oprn_id = a.oprn_id '
7418: ||' AND a.oprn_line_id = r.oprn_line_id '
7419: ||' AND a.sequence_dependent_ind = 1 '
7420: ||' AND r.prim_rsrc_ind = 1 '

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

7438: ||' FROM '
7439: ||' gmp_sequence_types'||at_apps_link||' s, '
7440: ||' gmd_operation_resources'||at_apps_link||' r, '
7441: ||' gmd_operation_activities'||at_apps_link||' a, '
7442: ||' gmd_operations'||at_apps_link||' o, '
7443: ||' (SELECT pcrd.resource_id prim_resource_id, '
7444: ||' pcrd.resources prim_resources, '
7445: ||' acrd.resource_id alt_resource_id, '
7446: ||' acrd.resources alt_resources, '

Line 7483: ||' gmd_operations'||at_apps_link||' o '

7479: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
7480: ||' gmp_sequence_types'||at_apps_link||' s, '
7481: ||' gmd_operation_resources'||at_apps_link||' r, '
7482: ||' gmd_operation_activities'||at_apps_link||' a, '
7483: ||' gmd_operations'||at_apps_link||' o '
7484: ||' WHERE o.oprn_id = a.oprn_id '
7485: ||' AND a.oprn_line_id = r.oprn_line_id '
7486: ||' AND a.sequence_dependent_ind = 1 '
7487: ||' AND r.prim_rsrc_ind = 1 '

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

7505: ||' FROM '
7506: ||' gmp_sequence_types'||at_apps_link||' s, '
7507: ||' gmd_operation_resources'||at_apps_link||' r, '
7508: ||' gmd_operation_activities'||at_apps_link||' a, '
7509: ||' gmd_operations'||at_apps_link||' o, '
7510: ||' (SELECT pcrd.resource_id prim_resource_id, '
7511: ||' pcrd.resources prim_resources, '
7512: ||' acrd.resource_id alt_resource_id, '
7513: ||' acrd.resources alt_resources, '