DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_LCF_DETAILS_GTMP

Line 719: FROM gmd_lcf_details_gtmp

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

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;