APPS.BOM_RTG_OI_UTIL dependencies on BOM_RESOURCES

Line 1147: FROM BOM_RESOURCES br

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

Line 1160: FROM BOM_RESOURCES br

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

Line 1424: FROM BOM_RESOURCES br

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

Line 1437: FROM BOM_RESOURCES br

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