APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_TECH_HDR

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

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

Line 788: FROM lm_sprd_prm a, lm_tech_hdr b

784: b.data_type,b.expression_char,b.lm_unit_code,
785: DECODE(b.data_type, 4, NVL(b.signif_figures, 0 ), 11, NVL(b.signif_figures, 0 ),b.signif_figures ),
786: a.min_value,a.max_value,a.optimize_type,
787: b.lowerbound_char,b.upperbound_char,b.max_length
788: FROM lm_sprd_prm a, lm_tech_hdr b
789: WHERE a.tech_parm_id = b.tech_parm_id
790: AND a.sprd_id = V_entity_id
791: AND a.organization_id = V_orgn_id;
792:

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;