APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_RECIPES_B

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

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

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

4501: END IF;
4502:
4503: IF g_samples_table(i).recipe_id is not NULL
4504: THEN
4505: -- dbms_output.put_line('select from gmd_recipes_b with recipe_id of '|| g_samples_table(i).recipe_id);
4506: select recipe_no, recipe_version into g_samples_table(i).recipe_no,
4507: g_samples_table(i).recipe_version
4508: from gmd_recipes_b
4509: where recipe_id = g_samples_table(i).recipe_id;

Line 4508: from gmd_recipes_b

4504: THEN
4505: -- dbms_output.put_line('select from gmd_recipes_b with recipe_id of '|| g_samples_table(i).recipe_id);
4506: select recipe_no, recipe_version into g_samples_table(i).recipe_no,
4507: g_samples_table(i).recipe_version
4508: from gmd_recipes_b
4509: where recipe_id = g_samples_table(i).recipe_id;
4510: END IF;
4511:
4512: IF g_samples_table(i).formula_id is not NULL

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

4877: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4878: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4879:
4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4881: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4882: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4883: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4884: ||',mtl_parameters mp';
4885: