DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on MTL_SYSTEM_ITEMS

Line 50: FROM lm_sprd_dtl a, mtl_system_items_b b, mtl_lot_numbers c,

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 (+)

Line 156: FROM gme_material_details a, mtl_system_items_b b, gme_batch_steps c,

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

Line 187: FROM mtl_system_items b,mtl_lot_numbers c

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

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 893: FROM mtl_system_items_b b

889: SELECT b.description,b.default_grade,b.secondary_default_ind,
890: b.primary_uom_code,b.secondary_uom_code,b.tracking_quantity_ind,
891: b.lot_control_code,b.grade_control_flag,b.location_control_code,
892: b.revision_qty_control_code,b.mtl_transactions_enabled_flag
893: FROM mtl_system_items_b b
894: WHERE b.inventory_item_id = V_inv_item_id
895: AND b.organization_id = V_orgn_id;
896:
897: CURSOR Cur_line_id IS

Line 1363: FROM mtl_system_items_kfv

1359: WHERE line_id = V_line_id;
1360:
1361: CURSOR Cur_line_item_number (V_inventory_item_id NUMBER)IS
1362: SELECT concatenated_segments
1363: FROM mtl_system_items_kfv
1364: WHERE inventory_item_id = V_inventory_item_id;
1365:
1366: l_conv_factor NUMBER;
1367: l_mass_qty NUMBER;

Line 1700: FROM gmd_lcf_details_gtmp a, mtl_system_items_b b

1696: SELECT a.*,b.description descrip, b.default_grade,
1697: b.primary_uom_code primary,b.secondary_uom_code secondary,
1698: b.lot_control_code,b.secondary_default_ind,
1699: b.grade_control_flag,b.tracking_quantity_ind,b.location_control_code
1700: FROM gmd_lcf_details_gtmp a, mtl_system_items_b b
1701: WHERE a.inventory_item_id = b.inventory_item_id
1702: AND b.organization_id = V_orgn_id
1703: ORDER BY a.line_type, a.line_no;
1704: l_formula_rec Cur_get_lcf%ROWTYPE;