[Home] [Help]
46: CURSOR Cur_get_spread IS
47: SELECT a.*,b.description,b.lot_control_code,b.secondary_default_ind,
48: b.grade_control_flag,b.location_control_code,b.tracking_quantity_ind,c.expiration_date expiry_date,
49: b.primary_uom_code PRIMARY, c.lot_number lot, d.batchstep_no
50: FROM lm_sprd_dtl a, mtl_system_items_b b, mtl_lot_numbers c,
51: gme_batch_steps d, gme_batch_step_items e
52: WHERE a.inventory_item_id = b.inventory_item_id
53: AND a.organization_id = b.organization_id
54: AND a.inventory_item_id = c.inventory_item_id (+)
152: SELECT a.*,b.description,b.lot_control_code,
153: b.grade_control_flag,b.tracking_quantity_ind,b.location_control_code,
154: b.default_grade,b.primary_uom_code primary,b.secondary_uom_code secondary,
155: c.batchstep_no,e.batch_status, b.revision_qty_control_code,b.secondary_default_ind
156: FROM gme_material_details a, mtl_system_items_b b, gme_batch_steps c,
157: gme_batch_step_items d, gme_batch_header e
158: WHERE a.inventory_item_id = b.inventory_item_id
159: AND b.organization_id = a.organization_id
160: AND a.batch_id = V_entity_id
183: CURSOR Cur_get_controls (V_inventory_item_id NUMBER,V_lot_number VARCHAR2,V_organization_id NUMBER) IS
184: SELECT b.tracking_quantity_ind,b.lot_control_code,
185: b.grade_control_flag,b.location_control_code,
186: b.default_grade,b.secondary_default_ind,c.expiration_date,c.organization_id
187: FROM mtl_system_items b,mtl_lot_numbers c
188: WHERE b.inventory_item_id = c.inventory_item_id
189: AND b.organization_id = c.organization_id
190: AND b.inventory_item_id = V_inventory_item_id
191: AND b.organization_id = V_organization_id
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)
919: SELECT b.description,b.default_grade,b.secondary_default_ind,
920: b.primary_uom_code,b.secondary_uom_code,b.tracking_quantity_ind,
921: b.lot_control_code,b.grade_control_flag,b.location_control_code,
922: b.revision_qty_control_code,b.mtl_transactions_enabled_flag
923: FROM mtl_system_items_b b
924: WHERE b.inventory_item_id = V_inv_item_id
925: AND b.organization_id = V_orgn_id;
926:
927: CURSOR Cur_line_id IS
1393: WHERE line_id = V_line_id;
1394:
1395: CURSOR Cur_line_item_number (V_inventory_item_id NUMBER)IS
1396: SELECT concatenated_segments
1397: FROM mtl_system_items_kfv
1398: WHERE inventory_item_id = V_inventory_item_id;
1399:
1400: l_conv_factor NUMBER;
1401: l_mass_qty NUMBER;
1740: SELECT a.*,b.description descrip, b.default_grade,
1741: b.primary_uom_code primary,b.secondary_uom_code secondary,
1742: b.lot_control_code,b.secondary_default_ind,
1743: b.grade_control_flag,b.tracking_quantity_ind,b.location_control_code
1744: FROM gmd_lcf_details_gtmp a, mtl_system_items_b b
1745: WHERE a.inventory_item_id = b.inventory_item_id
1746: AND b.organization_id = V_orgn_id
1747: ORDER BY a.line_type, a.line_no;
1748: l_formula_rec Cur_get_lcf%ROWTYPE;
1873: WHERE a.tech_parm_id = b.tech_parm_id
1874: AND c.line_id = V_line_id;
1875: CURSOR Cur_get_item (V_inv_item_id NUMBER) IS
1876: SELECT primary_uom_code
1877: FROM mtl_system_items_b
1878: WHERE inventory_item_id = V_inv_item_id
1879: AND organization_id = V_orgn_id;
1880: l_value NUMBER;
1881: l_parm_value VARCHAR2(240);
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