DBA Data[Home] [Help]

APPS.GMD_EXPRESSION_UTIL dependencies on GMD_MATERIAL_DETAILS_GTMP

Line 518: FROM gmd_material_details_gtmp

514: ) RETURN VARCHAR2 IS
515:
516: CURSOR Cur_get_line_qty (V_line_id NUMBER) IS
517: SELECT qty_mass, qty_vol
518: FROM gmd_material_details_gtmp
519: WHERE line_id = V_line_id;
520:
521: CURSOR Cur_value (V_line_id NUMBER, V_parameter VARCHAR2) IS
522: SELECT value

Line 584: FROM gmd_material_details_gtmp a

580:
581:
582: CURSOR Cur_get_line (V_line_type NUMBER) IS
583: SELECT line_id
584: FROM gmd_material_details_gtmp a
585: WHERE entity_id = p_entity_id
586: AND rollup_ind = 1
587: AND EXISTS (SELECT 1
588: FROM gmd_material_details_gtmp b

Line 588: FROM gmd_material_details_gtmp b

584: FROM gmd_material_details_gtmp a
585: WHERE entity_id = p_entity_id
586: AND rollup_ind = 1
587: AND EXISTS (SELECT 1
588: FROM gmd_material_details_gtmp b
589: WHERE line_type = V_line_type
590: AND entity_id = p_entity_id
591: AND a.parent_line_id = b.parent_line_id);
592: