DBA Data[Home] [Help]

APPS.GMD_EXPRESSION_MIG_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 586: FROM gmd_material_details_gtmp a

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

Line 590: FROM gmd_material_details_gtmp b

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