APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_TECHNICAL_SEQUENCE_VL

Line 737: FROM gmd_technical_sequence_vl

733: l_category_id NUMBER;
734:
735: CURSOR Cur_get_item_count IS
736: SELECT count(*)
737: FROM gmd_technical_sequence_vl
738: WHERE organization_id = V_orgn_id
739: AND inventory_item_id = l_item_id
740: AND delete_mark = 0;
741:

Line 744: FROM gmd_technical_sequence_vl

740: AND delete_mark = 0;
741:
742: CURSOR Cur_get_category_count IS
743: SELECT count(*)
744: FROM gmd_technical_sequence_vl
745: WHERE category_id = l_category_id
746: AND organization_id = V_orgn_id
747: AND delete_mark = 0;
748: l_count NUMBER;

Line 764: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s

760: -- if item parameters sequence is not defined.
761: CURSOR Cur_get_folder_cols IS
762: SELECT c.*, b.sequence
763: FROM fnd_folders a,
764: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s
765: WHERE a.folder_id(+) = b.folder_id
766: AND c.tech_parm_name = b.item_prompt(+)
767: AND a.name(+) = V_folder_name --- Bug 4254315 ....
768: AND a.OBJECT(+) = 'SPREAD_DTL_SUB'

Line 777: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s

773: AND NVL(s.category_id, 1) = NVL(l_category_id ,1)
774: UNION
775: SELECT c.*, b.sequence
776: FROM fnd_folders a,
777: fnd_folder_columns b, lm_tech_hdr c, gmd_technical_sequence_vl s
778: WHERE a.folder_id(+) = b.folder_id
779: AND c.tech_parm_name = b.item_prompt(+)
780: AND a.name(+) = V_folder_name --- Bug 4254315 ....
781: AND a.OBJECT(+) = 'SPREAD_DTL_SUB'

Line 858: FROM gmd_technical_sequence_vl a, lm_tech_hdr b

854: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
855: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
856: b.lowerbound_num,b.upperbound_num,
857: b.lowerbound_char,b.upperbound_char,b.max_length
858: FROM gmd_technical_sequence_vl a, lm_tech_hdr b
859: WHERE a.tech_parm_id = b.tech_parm_id
860: AND a.inventory_item_id = l_item_id
861: AND a.organization_id = V_orgn_id;
862: ELSE

Line 876: FROM gmd_technical_sequence_vl a, lm_tech_hdr b

872: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
873: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
874: b.lowerbound_num,b.upperbound_num,
875: b.lowerbound_char,b.upperbound_char,b.max_length
876: FROM gmd_technical_sequence_vl a, lm_tech_hdr b
877: WHERE a.tech_parm_id = b.tech_parm_id
878: AND a.category_id = l_category_id
879: AND a.organization_id = V_orgn_id;
880: ELSE

Line 890: FROM gmd_technical_sequence_vl a, lm_tech_hdr b

886: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
887: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
888: b.lowerbound_num,b.upperbound_num,
889: b.lowerbound_char,b.upperbound_char,b.max_length
890: FROM gmd_technical_sequence_vl a, lm_tech_hdr b
891: WHERE a.tech_parm_id = b.tech_parm_id
892: AND a.organization_id = V_orgn_id
893: AND a.inventory_item_id IS NULL
894: AND a.category_id IS NULL;