eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_COPY_ROUTING dependencies on BOM_STANDARD_OPERATIONS

Line 47: from bom_standard_operations

43: p_op_type number) Return Boolean Is
44: l_total number := 0;
45: Begin
46: select count(*) into l_total
47: from bom_standard_operations
48: where organization_id = p_org_id
49: and line_id = p_line_id
50: and operation_code = p_std_op_code
51: and operation_type = p_op_type;

Line 237: from bom_operation_sequences bos1, bom_standard_operations bso1

233: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
234: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
235: and (p_lineop_code is NULL or exists (
236: select 1
237: from bom_operation_sequences bos1, bom_standard_operations bso1
238: where bos1.routing_sequence_id = bor.common_routing_sequence_id
239: and p_lineop_code = bso1.operation_code
240: and bos1.standard_operation_id = bso1.standard_operation_id
241: and bso1.organization_id = p_organization_id

Line 247: from bom_operation_sequences bos1, bom_standard_operations bso1

243: and bos1.operation_type = 3)
244: )
245: and (p_process_code is NULL or exists (
246: select 1
247: from bom_operation_sequences bos1, bom_standard_operations bso1
248: where bos1.routing_sequence_id = bor.common_routing_sequence_id
249: and p_process_code = bso1.operation_code
250: and bos1.standard_operation_id = bso1.standard_operation_id
251: and bso1.organization_id = p_organization_id

Line 557: Select * From bom_standard_operations

553: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
554: Order by standard_operation_code;
555:
556: Cursor c_std_op(p_standard_operation_id number) Is
557: Select * From bom_standard_operations
558: Where standard_operation_id = p_standard_operation_id;
559:
560: Cursor c_std_op_res(p_standard_operation_id number) Is
561: Select * From bom_std_op_resources

Line 838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,

834:
835: BEGIN
836: l_diff_count := 0;
837: select count(*) into l_diff_count
838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,
839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to
840: and operation_code = stdop.standard_operation_code and operation_type = stdop.operation_type) b
841: where a.department_id <> b.department_id;
842: if (l_diff_count = 1) then

Line 839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to

835: BEGIN
836: l_diff_count := 0;
837: select count(*) into l_diff_count
838: from (select department_id from bom_standard_operations where standard_operation_id = stdop.standard_operation_id) a,
839: (select department_id from bom_standard_operations where organization_id = p_organization_id and line_id = p_line_id_to
840: and operation_code = stdop.standard_operation_code and operation_type = stdop.operation_type) b
841: where a.department_id <> b.department_id;
842: if (l_diff_count = 1) then
843: l_dept_diff := 1;

Line 1489: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);

1485:
1486: -- both RTG and/or BOM copied, then copy attachments
1487: if (o_return_status = 'S') then
1488: if l_2_ids.COUNT > 0 then
1489: copy_attach('BOM_STANDARD_OPERATIONS','BOM_STANDARD_OPERATIONS',l_2_ids);
1490: end if;
1491: if a_operation_tbl.COUNT > 0 then
1492: l_new_rtg_seq_id := null;
1493: OPEN c_new_rtg_seq_id(l_rtg_tbl(i).assembly_item_id,p_organization_id,p_alternate_code_to);