DBA Data[Home] [Help]

APPS.BOMPVALR dependencies on BOM_OPERATION_RESOURCES

Line 1773: from bom_operation_resources a, bom_op_resources_interface b

1769: */
1770: begin
1771: select 1
1772: into dummy
1773: from bom_operation_resources a, bom_op_resources_interface b
1774: where b.transaction_id = trans_id
1775: and a.operation_sequence_id = b.operation_sequence_id
1776: and a.resource_seq_num =
1777: b.resource_seq_num

Line 2915: from bom_operation_resources bor

2911: */
2912: if (res_cnt = 1) then
2913: select count(*)
2914: into res_cnt
2915: from bom_operation_resources bor
2916: where operation_sequence_id = op_seq
2917: and schedule_flag = sched_type;
2918:
2919: if (res_cnt <> 0) then

Line 2990: from bom_operation_resources

2986:
2987: if (cnt = 1) then
2988: select count(*)
2989: into cnt
2990: from bom_operation_resources
2991: where operation_sequence_id = op_seq
2992: and autocharge_type = 4;
2993: if (cnt > 0) then
2994: err_text := 'BOMPVALR(bmvauto):Invalid autocharge type, too many';