DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_LCF_DETAILS_GTMP

Line 720: FROM gmd_lcf_details_gtmp

716: AND line_no = 1;
717:
718: CURSOR Cur_get_lcf_prod IS
719: SELECT inventory_item_id
720: FROM gmd_lcf_details_gtmp
721: WHERE entity_id = V_entity_id
722: AND line_type = 1
723: AND line_no = 1;
724:

Line 1744: FROM gmd_lcf_details_gtmp a, mtl_system_items_b b

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;