APPS.BOM_VALIDATE_SUB_OP_RES dependencies on BOM_RESOURCES

Line 645: FROM BOM_RESOURCES br

641: THEN
642: BEGIN
643: SELECT br.DEFAULT_BASIS_TYPE
644: INTO l_default_basis_type
645: FROM BOM_RESOURCES br
646: WHERE br.RESOURCE_ID = p_rev_sub_res_unexp_rec.resource_id;
647: EXCEPTION
648: WHEN NO_DATA_FOUND THEN
649: l_default_basis_type := 1;

Line 1596: FROM bom_resources

1592: OPEN get_setups (p_rev_sub_res_unexp_rec.resource_id, p_rev_sub_res_unexp_rec.organization_id);
1593: FETCH get_setups INTO l_get_setups;
1594: CLOSE get_setups;
1595: SELECT nvl(batchable,2) INTO l_batchable
1596: FROM bom_resources
1597: WHERE resource_id = p_rev_sub_res_unexp_rec.resource_id;
1598: IF (l_get_setups > 0 or l_batchable = 1) THEN
1599: IF p_rev_sub_resource_rec.assigned_units <> 1 THEN
1600: l_Token_Tbl(2).token_name := 'RES_SEQ_NUMBER';

Line 2398: from bom_resources_v

2394: If (l_rev_sub_resource_rec.sub_resource_code is not null) Then
2395: l_res_code := l_rev_sub_resource_rec.sub_resource_code;
2396: Else
2397: Select resource_code into l_res_code
2398: from bom_resources_v
2399: where resource_id=l_rev_sub_res_unexp_rec.resource_id;
2400: End If;
2401:
2402: Select resource_code into l_res_code_2

Line 2403: from bom_resources_v

2399: where resource_id=l_rev_sub_res_unexp_rec.resource_id;
2400: End If;
2401:
2402: Select resource_code into l_res_code_2
2403: from bom_resources_v
2404: where resource_id=l_res_id;
2405:
2406: l_Token_Tbl(1).Token_Name := 'RES_SEQ_1';
2407: l_Token_Tbl(1).Token_Value:= l_res_code;