DBA Data[Home] [Help]

APPS.BOMPVALR dependencies on BOM_RESOURCES

Line 1269: from bom_Resources br, bom_department_resources bdr

1265: into res_cnt
1266: from bom_op_resources_interface ori
1267: where ori.operation_sequence_id = c1rec.OSI
1268: and ori.resource_id not in (select br.resource_id
1269: from bom_Resources br, bom_department_resources bdr
1270: where br.resource_id = ori.resource_id
1271: and nvl(br.disable_date, dummy_eff + 1) > dummy_eff
1272: and bdr.department_id = dept_id
1273: and bdr.resource_id = ori.resource_id);

Line 1403: from bom_op_resources_interface ori, bom_resources br,

1399: and ood.set_of_books_id = gsb.set_of_books_id;
1400:
1401: select count(*)
1402: into res_cnt
1403: from bom_op_resources_interface ori, bom_resources br,
1404: mtl_units_of_measure uom
1405: where ori.operation_sequence_id = c1rec.OSI
1406: and ori.schedule_flag = 1
1407: and ori.resource_id = br.resource_id

Line 1521: bom_resources br

1517: or
1518: (hr_uom_class in
1519: (select uom_class
1520: from mtl_units_of_measure mum,
1521: bom_resources br
1522: where br.resource_id = bori.resource_id
1523: and mum.uom_code = br.unit_of_measure))
1524: );
1525: if (res_cnt <> 0) then