APPS.INVPCOII dependencies on BOM_RESOURCES

Line 85: from bom_resources br

81: If (l_material_sub_elem is not NULL) Then
82: l_location := 110;
83: select resource_id
84: into l_material_sub_elem_id
85: from bom_resources br
86: where br.resource_code = l_material_sub_elem
87: and br.organization_id = l_cost_organization_id
88: and br.cost_code_type = 1;
89: End if;

Line 98: from bom_resources br

94: If (l_material_oh_sub_elem is not NULL) Then
95: l_location := 120;
96: select resource_id
97: into l_material_oh_sub_elem_id
98: from bom_resources br
99: where br.resource_code = l_material_oh_sub_elem
100: and br.organization_id = l_cost_organization_id
101: and br.cost_code_type = 2;
102: End if;

Line 191: /* by the user in the bom_resources table. */

187: /* */
188: /* */
189: /* Note : */
190: /* The basis type will default to the following if one is not define */
191: /* by the user in the bom_resources table. */
192: /* I_COST_ELEMENT_ID : 1 Material item basis */
193: /* 2 Material Overhead total value basis */
194: /* For average costing, there is no material overhead concept */
195: /* Assume that the record does not exist yet */

Line 221: from bom_resources

217: l_location := 199;
218:
219: select nvl(default_basis_type,decode(i_cost_element_id,1,1,2,5,0))
220: into l_basis_type
221: from bom_resources
222: where resource_id = i_resource_id;
223:
224: l_location := 200;
225: