APPS.GMP_BOM_ROUTING_PKG dependencies on GMD_OPERATIONS

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

645: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY
646: BINARY_INTEGER;
647: gt_seq_dep_class seq_dep_class_typ ;
648: --
649: TYPE oprn_no_typ IS TABLE OF gmd_operations.oprn_no%TYPE INDEX BY
650: BINARY_INTEGER;
651: gt_oprn_no oprn_no_typ ;
652:
653: /* End of changes SGIDUGU - Seq Dep */

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

1907: ||' DECODE(NVL(goa.sequence_dependent_ind,0),1,0,DECODE(gor.prim_rsrc_ind,1,1,0)) is_nonunique, '
1908: ||' NULL setup_id '
1909: ||' FROM cr_rsrc_dtl'||at_apps_link||' crd, '
1910: ||' fm_rout_dtl'||at_apps_link||' frd, '
1911: ||' gmd_operations'||at_apps_link||' fom, '
1912: ||' gmd_operation_activities'||at_apps_link||' goa, '
1913: ||' gmd_operation_resources'||at_apps_link||' gor, '
1914: ||' hr_organization_units'||at_apps_link||' hou1, '
1915: ||' mtl_units_of_measure'||at_apps_link||' mum, '

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

2063: ||' goa.offset_interval, '
2064: ||' gor.resource_usage_uom, ' -- akaruppa changed sou.uom_code to gor.resource_usage_uom
2065: ||' 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
2066: ||' FROM fm_rout_dtl'||at_apps_link||' frd, '
2067: ||' gmd_operations'||at_apps_link||' fom, '
2068: ||' gmd_operation_activities'||at_apps_link||' goa, '
2069: ||' gmd_operation_resources'||at_apps_link||' gor, '
2070: ||' cr_rsrc_mst'||at_apps_link||' crm, '
2071: ||' mtl_units_of_measure'||at_apps_link||' mum '

Line 6695: ||' gmd_operations'||at_apps_link||' o '

6691: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
6692: ||' gmp_sequence_types'||at_apps_link||' s, '
6693: ||' gmd_operation_resources'||at_apps_link||' r, '
6694: ||' gmd_operation_activities'||at_apps_link||' a, '
6695: ||' gmd_operations'||at_apps_link||' o '
6696: ||' WHERE o.oprn_id = a.oprn_id '
6697: ||' AND a.oprn_line_id = r.oprn_line_id '
6698: ||' AND a.sequence_dependent_ind = 1 '
6699: ||' AND r.prim_rsrc_ind = 1 '

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

6717: ||' FROM '
6718: ||' gmp_sequence_types'||at_apps_link||' s, '
6719: ||' gmd_operation_resources'||at_apps_link||' r, '
6720: ||' gmd_operation_activities'||at_apps_link||' a, '
6721: ||' gmd_operations'||at_apps_link||' o, '
6722: ||' (SELECT pcrd.resource_id prim_resource_id, '
6723: ||' pcrd.resources prim_resources, '
6724: ||' acrd.resource_id alt_resource_id, '
6725: ||' acrd.resources alt_resources, '

Line 6762: ||' gmd_operations'||at_apps_link||' o '

6758: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
6759: ||' gmp_sequence_types'||at_apps_link||' s, '
6760: ||' gmd_operation_resources'||at_apps_link||' r, '
6761: ||' gmd_operation_activities'||at_apps_link||' a, '
6762: ||' gmd_operations'||at_apps_link||' o '
6763: ||' WHERE o.oprn_id = a.oprn_id '
6764: ||' AND a.oprn_line_id = r.oprn_line_id '
6765: ||' AND a.sequence_dependent_ind = 1 '
6766: ||' AND r.prim_rsrc_ind = 1 '

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

6784: ||' FROM '
6785: ||' gmp_sequence_types'||at_apps_link||' s, '
6786: ||' gmd_operation_resources'||at_apps_link||' r, '
6787: ||' gmd_operation_activities'||at_apps_link||' a, '
6788: ||' gmd_operations'||at_apps_link||' o, '
6789: ||' (SELECT pcrd.resource_id prim_resource_id, '
6790: ||' pcrd.resources prim_resources, '
6791: ||' acrd.resource_id alt_resource_id, '
6792: ||' acrd.resources alt_resources, '