DBA Data[Home] [Help]

APPS.GMO_VBATCH_PVT dependencies on MTL_PARAMETERS

Line 1614: cursor get_org_detail is select a.organization_id, a.organization_code from mtl_parameters a, gme_batch_header b where a.organization_id = b.organization_id and b.batch_id = l_batch_id;

1610: cursor get_material_detail is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where formulaline_id = l_formula_line_id and batch_id = l_batch_id;
1611: cursor get_material_detail_from_id is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where material_detail_id = l_material_detail_id;
1612: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1613:
1614: cursor get_org_detail is select a.organization_id, a.organization_code from mtl_parameters a, gme_batch_header b where a.organization_id = b.organization_id and b.batch_id = l_batch_id;
1615:
1616: GMO_INVALID_TASK_ERR exception;
1617: GMO_INSTR_TASK_PARAM_ERR exception;
1618: NO_BATCH_FOUND_ERR exception;