APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_TECHNICAL_SEQUENCE_VL

Line 736: FROM gmd_technical_sequence_vl

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

Line 743: FROM gmd_technical_sequence_vl

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

Line 828: FROM gmd_technical_sequence_vl a, lm_tech_hdr b

824: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
825: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
826: b.lowerbound_num,b.upperbound_num,
827: b.lowerbound_char,b.upperbound_char,b.max_length
828: FROM gmd_technical_sequence_vl a, lm_tech_hdr b
829: WHERE a.tech_parm_id = b.tech_parm_id
830: AND a.inventory_item_id = l_item_id
831: AND a.organization_id = V_orgn_id;
832: ELSE

Line 846: FROM gmd_technical_sequence_vl a, lm_tech_hdr b

842: b.qcassy_typ_id,b.data_type,b.expression_char,b.lm_unit_code,
843: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
844: b.lowerbound_num,b.upperbound_num,
845: b.lowerbound_char,b.upperbound_char,b.max_length
846: FROM gmd_technical_sequence_vl a, lm_tech_hdr b
847: WHERE a.tech_parm_id = b.tech_parm_id
848: AND a.category_id = l_category_id
849: AND a.organization_id = V_orgn_id;
850: ELSE

Line 860: FROM gmd_technical_sequence_vl a, lm_tech_hdr b

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