APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_RECIPES_B

Line 3976: table_list := table_list ||', gmd_recipes_b r ';

3972: END IF;
3973:
3974: IF (p_wip_recipe_no IS NOT NULL or p_wip_recipe_version IS NOT NULL)
3975: THEN
3976: table_list := table_list ||', gmd_recipes_b r ';
3977: where_clause := where_clause ||'AND gs.recipe_id = r.recipe_id ';
3978:
3979: IF p_wip_recipe_no IS NOT NULL
3980: THEN

Line 4478: -- dbms_output.put_line('select from gmd_recipes_b with recipe_id of '|| g_samples_table(i).recipe_id);

4474: END IF;
4475:
4476: IF g_samples_table(i).recipe_id is not NULL
4477: THEN
4478: -- dbms_output.put_line('select from gmd_recipes_b with recipe_id of '|| g_samples_table(i).recipe_id);
4479: select recipe_no, recipe_version into g_samples_table(i).recipe_no,
4480: g_samples_table(i).recipe_version
4481: from gmd_recipes_b
4482: where recipe_id = g_samples_table(i).recipe_id;

Line 4481: from gmd_recipes_b

4477: THEN
4478: -- dbms_output.put_line('select from gmd_recipes_b with recipe_id of '|| g_samples_table(i).recipe_id);
4479: select recipe_no, recipe_version into g_samples_table(i).recipe_no,
4480: g_samples_table(i).recipe_version
4481: from gmd_recipes_b
4482: where recipe_id = g_samples_table(i).recipe_id;
4483: END IF;
4484:
4485: IF g_samples_table(i).formula_id is not NULL

Line 4833: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'

4829: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4830: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4831:
4832: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4833: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4834: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4835: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4836: ||',mtl_parameters mp';
4837: