APPS.BOM_VALIDATE_SUB_OP_RES dependencies on BOM_RESOURCES

Line 650: FROM BOM_RESOURCES br

646: THEN
647: BEGIN
648: SELECT br.DEFAULT_BASIS_TYPE
649: INTO l_default_basis_type
650: FROM BOM_RESOURCES br
651: WHERE br.RESOURCE_ID = p_rev_sub_res_unexp_rec.resource_id;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: l_default_basis_type := 1;

Line 1628: FROM bom_resources

1624: OPEN get_setups (p_rev_sub_res_unexp_rec.resource_id, p_rev_sub_res_unexp_rec.organization_id);
1625: FETCH get_setups INTO l_get_setups;
1626: CLOSE get_setups;
1627: SELECT nvl(batchable,2) INTO l_batchable
1628: FROM bom_resources
1629: WHERE resource_id = p_rev_sub_res_unexp_rec.resource_id;
1630: IF (l_get_setups > 0 or l_batchable = 1) THEN
1631: IF p_rev_sub_resource_rec.assigned_units <> 1 THEN
1632: l_Token_Tbl(2).token_name := 'RES_SEQ_NUMBER';

Line 2438: from bom_resources_v

2434: If (l_rev_sub_resource_rec.sub_resource_code is not null) Then
2435: l_res_code := l_rev_sub_resource_rec.sub_resource_code;
2436: Else
2437: Select resource_code into l_res_code
2438: from bom_resources_v
2439: where resource_id=l_rev_sub_res_unexp_rec.resource_id;
2440: End If;
2441:
2442: Select resource_code into l_res_code_2

Line 2443: from bom_resources_v

2439: where resource_id=l_rev_sub_res_unexp_rec.resource_id;
2440: End If;
2441:
2442: Select resource_code into l_res_code_2
2443: from bom_resources_v
2444: where resource_id=l_res_id;
2445:
2446: l_Token_Tbl(1).Token_Name := 'RES_SEQ_1';
2447: l_Token_Tbl(1).Token_Value:= l_res_code;