APPS.GMP_BOM_ROUTING_PKG dependencies on GMP_SEQUENCE_TYPES

Line 641: TYPE setup_id_typ IS TABLE OF gmp_sequence_types.seq_dep_id%TYPE INDEX BY BINARY_INTEGER;

637: INDEX BY BINARY_INTEGER;
638: or_resource_seq_num resource_seq_num ;
639: rs_resource_seq_num resource_seq_num ;
640: /* SGIDUGU - Seq Dep */
641: TYPE setup_id_typ IS TABLE OF gmp_sequence_types.seq_dep_id%TYPE INDEX BY BINARY_INTEGER;
642: or_setup_id setup_id_typ ;
643: gt_setup_id setup_id_typ ;
644: --
645: TYPE seq_dep_class_typ IS TABLE OF ic_item_mst.seq_dpnd_class%TYPE INDEX BY

Line 1846: ||' FROM gmp_sequence_types'||at_apps_link||' gst '

1842: setup_id_cursor :=
1843: ' SELECT oprn_id, '
1844: ||' category_id, '
1845: ||' seq_dep_id '
1846: ||' FROM gmp_sequence_types'||at_apps_link||' gst '
1847: ||' WHERE oprn_id <> -1 '
1848: ||' ORDER BY oprn_id,category_id ' ;
1849:
1850: setup_size := 1;

Line 6692: ||' gmp_sequence_types'||at_apps_link||' s, '

6688: ||' rd.resource_id, '
6689: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.resource_id) CNT '
6690: ||' FROM '
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 '

Line 6718: ||' gmp_sequence_types'||at_apps_link||' s, '

6714: ||' o.oprn_id, '
6715: ||' rd.alt_resource_id, '
6716: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.alt_resource_id) CNT '
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, '

Line 6759: ||' gmp_sequence_types'||at_apps_link||' s, '

6755: ||' rd.resource_id, '
6756: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.resource_id) CNT '
6757: ||' FROM '
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 '

Line 6785: ||' gmp_sequence_types'||at_apps_link||' s, '

6781: ||' o.oprn_id, '
6782: ||' rd.alt_resource_id, '
6783: ||' count(o.oprn_id) OVER (PARTITION BY rd.organization_id,s.category_id,rd.alt_resource_id) CNT '
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, '

Line 6888: ||' FROM gmp_sequence_types'||at_apps_link||' gst, '

6884: ||' gst.SEQ_DEP_ID , '
6885: ||' mc.CONCATENATED_SEGMENTS, '
6886: ||' mc.CONCATENATED_SEGMENTS, '
6887: ||' 2 '
6888: ||' FROM gmp_sequence_types'||at_apps_link||' gst, '
6889: ||' MTL_CATEGORIES_B_KFV'||at_apps_link||' mc, '
6890: ||' ( SELECT unique mt.organization_id, mt.resource_id, '
6891: ||' mt.transition_uom,mt.sr_instance_id, '
6892: ||' mt.deleted_flag , mt.from_setup_id, mt.to_setup_id '

Line 7223: ||' FROM gmp_sequence_types'||at_apps_link /* SGIDUGU

7219: ||' mtl_system_items'||at_apps_link||' msi,'
7220: ||' mtl_units_of_measure'||at_apps_link||' mum, '
7221: ||' sy_orgn_mst'||at_apps_link||' som, '
7222: ||' (SELECT category_id,seq_dep_id ' /* SGIDUGU */
7223: ||' FROM gmp_sequence_types'||at_apps_link /* SGIDUGU
7224: */
7225: ||' WHERE oprn_id = -1 ' /* SGIDUGU */
7226: ||' ) t '
7227: ||' WHERE iim.delete_mark = 0 '