APPS.GMD_SPREAD_FETCH_PKG dependencies on FM_MATL_DTL

Line 76: FROM fm_matl_dtl

72: WHERE material_detail_id = V_matldetlid;
73:
74: CURSOR Cur_get_formula_text(V_formlineid IN NUMBER) IS
75: SELECT text_code
76: FROM fm_matl_dtl
77: WHERE formulaline_id = V_formlineid;
78:
79: l_text_code NUMBER(10);
80: l_line_id NUMBER DEFAULT 0;

Line 500: FROM fm_matl_dtl a, mtl_system_items_b b

496: SELECT a.*,b.description,b.default_grade,
497: b.primary_uom_code primary,b.secondary_uom_code secondary,
498: b.lot_control_code,b.revision_qty_control_code,b.secondary_default_ind,
499: b.grade_control_flag,b.tracking_quantity_ind,b.location_control_code
500: FROM fm_matl_dtl a, mtl_system_items_b b
501: WHERE a.inventory_item_id = b.inventory_item_id
502: AND b.organization_id = a.organization_id
503: AND a.formula_id = V_entity_id
504: AND (a.line_type <> 1 OR a.line_no = 1)

Line 601: FROM Fm_form_mst a, fm_matl_dtl b, gmd_technical_data_hdr g

597: BEGIN
598: SELECT a.formula_id INTO l_tpformula_id
599: FROM
600: (SELECT a.formula_id
601: FROM Fm_form_mst a, fm_matl_dtl b, gmd_technical_data_hdr g
602: WHERE b.item_id = l_formula_rec.item_id
603: AND a.formula_id = b.formula_id
604: AND g.item_id = b.item_id
605: AND g.formula_id = a.formula_id

Line 706: FROM fm_matl_dtl

702: V_orgn_id IN NUMBER,V_folder_name IN VARCHAR2,
703: V_inv_item_id IN NUMBER,V_formula_id IN NUMBER) IS
704: CURSOR Cur_get_prod IS
705: SELECT inventory_item_id
706: FROM fm_matl_dtl
707: WHERE formula_id = V_entity_id
708: AND line_type = 1
709: AND line_no = 1;
710:

Line 1930: FROM fm_matl_dtl a, ic_item_mst b

1926: V_line_type IN NUMBER, V_line_no IN NUMBER,V_orgn_id IN number,V_plant_id IN number) IS
1927: /* CURSOR Cur_get_formula IS
1928: SELECT a.*,b.item_no,b.item_desc1,b.qc_grade,b.item_um primary,b.item_um2 secondary,
1929: b.lot_ctl,b.sublot_ctl,b.grade_ctl,b.loct_ctl,b.dualum_ind
1930: FROM fm_matl_dtl a, ic_item_mst b
1931: WHERE a.item_id = b.item_id
1932: AND a.formula_id = V_formula_id
1933: AND a.line_type = 1
1934: AND a.line_no = V_line_no; */

Line 1938: FROM fm_matl_dtl a, mtl_system_items_b b

1934: AND a.line_no = V_line_no; */
1935:
1936: CURSOR Cur_get_formula IS
1937: SELECT a.*,b.segment1 original_item_id, b.primary_uom_code primary,b.secondary_uom_code secondary,b.dual_uom_control dualum_ind
1938: FROM fm_matl_dtl a, mtl_system_items_b b
1939: WHERE a.inventory_item_id = b.inventory_item_id
1940: and b.organization_id = V_orgn_id
1941: AND a.formula_id = V_formula_id
1942: AND a.line_type = 1