APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_TECH_HDR

Line 752: FROM fnd_folders a, fnd_folder_columns b, lm_tech_hdr c

748: l_count NUMBER;
749:
750: /*CURSOR Cur_get_folder_cols IS
751: SELECT c.*, b.sequence
752: FROM fnd_folders a, fnd_folder_columns b, lm_tech_hdr c
753: WHERE a.folder_id = b.folder_id
754: AND b.item_prompt = c.tech_parm_name
755: AND a.name = V_folder_name
756: AND a.OBJECT = 'SPREAD_DTL_SUB'

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 818: FROM lm_sprd_prm a, lm_tech_hdr b

814: b.data_type,b.expression_char,b.lm_unit_code,
815: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
816: a.min_value,a.max_value,a.optimize_type,
817: b.lowerbound_char,b.upperbound_char,b.max_length
818: FROM lm_sprd_prm a, lm_tech_hdr b
819: WHERE a.tech_parm_id = b.tech_parm_id
820: AND a.sprd_id = V_entity_id
821: AND a.organization_id = V_orgn_id;
822:

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;