[Home] [Help]
669: INDEX BY BINARY_INTEGER;
670: or_resource_seq_num resource_seq_num ;
671: rs_resource_seq_num resource_seq_num ;
672: /* SGIDUGU - Seq Dep */
673: TYPE setup_id_typ IS TABLE OF gmp_sequence_types.seq_dep_id%TYPE INDEX BY BINARY_INTEGER;
674: or_setup_id setup_id_typ ;
675: gt_setup_id setup_id_typ ;
676: --
677: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY
2035: setup_id_cursor :=
2036: ' SELECT oprn_id, '
2037: ||' category_id, '
2038: ||' seq_dep_id '
2039: ||' FROM gmp_sequence_types'||at_apps_link||' gst '
2040: ||' WHERE oprn_id <> -1 '
2041: ||' ORDER BY oprn_id,category_id ' ;
2042:
2043: setup_size := 1;
7409: ||' rd.resource_id, '
7410: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.resource_id) CNT '
7411: ||' FROM '
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 '
7435: ||' o.oprn_id, '
7436: ||' rd.alt_resource_id, '
7437: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.alt_resource_id) CNT '
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, '
7476: ||' rd.resource_id, '
7477: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.resource_id) CNT '
7478: ||' FROM '
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 '
7502: ||' o.oprn_id, '
7503: ||' rd.alt_resource_id, '
7504: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.alt_resource_id) CNT '
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, '
7639: ||' gst.SEQ_DEP_ID , '
7640: ||' mc.CONCATENATED_SEGMENTS, '
7641: ||' mc.CONCATENATED_SEGMENTS, '
7642: ||' 2 '
7643: ||' FROM gmp_sequence_types'||at_apps_link||' gst, '
7644: ||' MTL_CATEGORIES_B_KFV'||at_apps_link||' mc, '
7645: ||' ( SELECT unique mt.organization_id, mt.resource_id, '
7646: ||' mt.transition_uom,mt.sr_instance_id, '
7647: ||' mt.deleted_flag , mt.from_setup_id, mt.to_setup_id '
7682: ||' gmp.SEQ_DEP_ID , '
7683: ||' mtl.CONCATENATED_SEGMENTS, '
7684: ||' mtl.CONCATENATED_SEGMENTS, '
7685: ||' 2 '
7686: ||' FROM gmp_sequence_types'||at_apps_link||' gmp, '
7687: ||' MTL_CATEGORIES_B_KFV'||at_apps_link||' mtl, '
7688: ||' gmd_operation_activities'||at_apps_link||' gao, '
7689: ||' gmd_operation_resources'||at_apps_link||' gmd, '
7690: ||' cr_rsrc_dtl'||at_apps_link||' crd '
8014: ||' mtl_system_items'||at_apps_link||' msi,'
8015: ||' mtl_units_of_measure'||at_apps_link||' mum, '
8016: ||' sy_orgn_mst'||at_apps_link||' som, '
8017: ||' (SELECT category_id,seq_dep_id ' /* SGIDUGU */
8018: ||' FROM gmp_sequence_types'||at_apps_link /* SGIDUGU
8019: */
8020: ||' WHERE oprn_id = -1 ' /* SGIDUGU */
8021: ||' ) t '
8022: ||' WHERE iim.delete_mark = 0 '