APPS.BOM_RTG_OI_UTIL dependencies on BOM_RESOURCES

Line 1145: FROM BOM_RESOURCES br

1141: /* Update resource code */
1142:
1143: UPDATE BOM_OP_RESOURCES_INTERFACE BORI
1144: SET resource_code = (SELECT resource_code
1145: FROM BOM_RESOURCES br
1146: WHERE br.resource_id = BORI.resource_id
1147: and br.organization_id = BORI.organization_id)
1148: WHERE process_flag = 1
1149: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1158: FROM BOM_RESOURCES br

1154: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
1155: OR ( p_batch_id = BORI.batch_id )
1156: )
1157: AND exists (SELECT 'x'
1158: FROM BOM_RESOURCES br
1159: WHERE br.resource_id = BORI.resource_id
1160: and br.organization_id = BORI.organization_id);
1161:
1162:

Line 1422: FROM BOM_RESOURCES br

1418: /* Update resource code */
1419:
1420: UPDATE BOM_SUB_OP_RESOURCES_INTERFACE BSORI
1421: SET sub_resource_code = (SELECT resource_code
1422: FROM BOM_RESOURCES br
1423: WHERE br.resource_id = BSORI.resource_id
1424: and br.organization_id = BSORI.organization_id)
1425: WHERE process_flag = 1
1426: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 1435: FROM BOM_RESOURCES br

1431: ( (p_batch_id IS NULL) AND (BSORI.batch_id IS NULL) )
1432: OR ( p_batch_id = BSORI.batch_id )
1433: )
1434: AND exists (SELECT 'x'
1435: FROM BOM_RESOURCES br
1436: WHERE br.resource_id = BSORI.resource_id
1437: and br.organization_id = BSORI.organization_id);
1438:
1439: