DBA Data[Home] [Help]

APPS.MSC_CL_GMP_UTILITY dependencies on GMD_OPERATIONS

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

750: BINARY_INTEGER;
751: gt_seq_dep_class seq_dep_class_typ ;
752: empty_seq_dep_class seq_dep_class_typ ;
753: --
754: TYPE oprn_no_typ IS TABLE OF gmd_operations.oprn_no%TYPE INDEX BY
755: BINARY_INTEGER;
756: gt_oprn_no oprn_no_typ ;
757: empty_oprn_no oprn_no_typ ;
758:

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

2168: ||' FROM sy_uoms_mst'||at_apps_link||' sou, '
2169: ||' sy_uoms_mst'||at_apps_link||' sou2, '
2170: ||' cr_rsrc_dtl'||at_apps_link||' crd, '
2171: ||' fm_rout_dtl'||at_apps_link||' frd, '
2172: ||' gmd_operations'||at_apps_link||' fom, '
2173: ||' gmd_operation_activities'||at_apps_link||' goa, '
2174: ||' gmd_operation_resources'||at_apps_link||' gor '
2175: ||' WHERE frd.oprn_id = fom.oprn_id '
2176: ||' AND fom.oprn_id = goa.oprn_id '

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

2296: ||' goa.offset_interval, '
2297: /* NAMIT_RD */
2298: ||' sou.uom_code '
2299: ||' FROM fm_rout_dtl'||at_apps_link||' frd, '
2300: ||' gmd_operations'||at_apps_link||' fom, '
2301: ||' gmd_operation_activities'||at_apps_link||' goa, '
2302: ||' gmd_operation_resources'||at_apps_link||' gor, '
2303: /* NAMIT_RD */
2304: ||' sy_uoms_mst'||at_apps_link||' sou '

Line 7179: ||' gmd_operations'||at_apps_link||' o '

7175: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
7176: ||' gmp_sequence_types'||at_apps_link||' s, '
7177: ||' gmd_operation_resources'||at_apps_link||' r, '
7178: ||' gmd_operation_activities'||at_apps_link||' a, '
7179: ||' gmd_operations'||at_apps_link||' o '
7180: ||' WHERE o.oprn_id = a.oprn_id '
7181: ||' AND a.oprn_line_id = r.oprn_line_id '
7182: ||' AND rd.orgn_code = sy.orgn_code '
7183: ||' AND sy.resource_whse_code = iwm.whse_code '

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

7202: ||' FROM '
7203: ||' gmp_sequence_types'||at_apps_link||' s, '
7204: ||' gmd_operation_resources'||at_apps_link||' r, '
7205: ||' gmd_operation_activities'||at_apps_link||' a, '
7206: ||' gmd_operations'||at_apps_link||' o, '
7207: ||' (SELECT pcrd.resource_id prim_resource_id, '
7208: ||' pcrd.resources prim_resources, '
7209: ||' acrd.resource_id alt_resource_id, '
7210: ||' acrd.resources alt_resources, '

Line 7252: ||' gmd_operations'||at_apps_link||' o '

7248: ||' cr_rsrc_dtl'||at_apps_link||' rd, '
7249: ||' gmp_sequence_types'||at_apps_link||' s, '
7250: ||' gmd_operation_resources'||at_apps_link||' r, '
7251: ||' gmd_operation_activities'||at_apps_link||' a, '
7252: ||' gmd_operations'||at_apps_link||' o '
7253: ||' WHERE o.oprn_id = a.oprn_id '
7254: ||' AND a.oprn_line_id = r.oprn_line_id '
7255: ||' AND rd.orgn_code = sy.orgn_code '
7256: ||' AND sy.resource_whse_code = iwm.whse_code '

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

7275: ||' FROM '
7276: ||' gmp_sequence_types'||at_apps_link||' s, '
7277: ||' gmd_operation_resources'||at_apps_link||' r, '
7278: ||' gmd_operation_activities'||at_apps_link||' a, '
7279: ||' gmd_operations'||at_apps_link||' o, '
7280: ||' (SELECT pcrd.resource_id prim_resource_id, '
7281: ||' pcrd.resources prim_resources, '
7282: ||' acrd.resource_id alt_resource_id, '
7283: ||' acrd.resources alt_resources, '