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.BOM_COPY_ROUTING dependencies on STANDARD

Line 290: SELECT standard_operation_id,

286:
287: -- Cursor Bug fix 3473802
288: CURSOR update_st_op
289: IS
290: SELECT standard_operation_id,
291: operation_sequence_id
292: FROM bom_operation_sequences
293: WHERE routing_sequence_id = to_sequence_id;
294: l_from_item_id NUMBER;

Line 353: standard_operation_id,

349: last_updated_by,
350: creation_date,
351: created_by,
352: last_update_login,
353: standard_operation_id,
354: department_id,
355: operation_lead_time_percent,
356: minimum_transfer_quantity,
357: count_point_type,

Line 429: a.standard_operation_id,

425: a.operation_sequence_id,
426: l_curr_date,
427: user_id,
428: user_id,
429: a.standard_operation_id,
430: c.department_id,
431: NULL,
432: a.minimum_transfer_quantity,
433: a.count_point_type,

Line 955: SELECT b.standard_operation_id,

951:
952: EXIT WHEN update_st_op%NOTFOUND;
953:
954: BEGIN
955: SELECT b.standard_operation_id,
956: b.minimum_transfer_quantity,
957: b.backflush_flag,
958: b.option_dependent_flag,
959: b.count_point_type,

Line 967: FROM bom_standard_operations_v a, -- BUG 3936049

963: back_flag,
964: opt_flag,
965: count_type,
966: opr_desc
967: FROM bom_standard_operations_v a, -- BUG 3936049
968: bom_standard_operations_v b -- BUG 3936049
969: WHERE a.standard_operation_id = p_st_op_id
970: AND a.operation_code = b.operation_code
971: AND a.organization_id = from_org_id

Line 968: bom_standard_operations_v b -- BUG 3936049

964: opt_flag,
965: count_type,
966: opr_desc
967: FROM bom_standard_operations_v a, -- BUG 3936049
968: bom_standard_operations_v b -- BUG 3936049
969: WHERE a.standard_operation_id = p_st_op_id
970: AND a.operation_code = b.operation_code
971: AND a.organization_id = from_org_id
972: AND b.organization_id = to_org_id

Line 969: WHERE a.standard_operation_id = p_st_op_id

965: count_type,
966: opr_desc
967: FROM bom_standard_operations_v a, -- BUG 3936049
968: bom_standard_operations_v b -- BUG 3936049
969: WHERE a.standard_operation_id = p_st_op_id
970: AND a.operation_code = b.operation_code
971: AND a.organization_id = from_org_id
972: AND b.organization_id = to_org_id
973: AND NVL (a.line_code, '@@@') = NVL (b.line_code, '@@@')

Line 979: SET standard_operation_id = new_st_op_id,

975: AND NVL (a.operation_type, -99) = NVL (b.operation_type,
976: -99); -- BUG 3936049
977:
978: UPDATE bom_operation_sequences
979: SET standard_operation_id = new_st_op_id,
980: minimum_transfer_quantity = min_qty,
981: backflush_flag = back_flag,
982: option_dependent_flag = opt_flag,
983: count_point_type = count_type,

Line 993: SET standard_operation_id = NULL

989: EXCEPTION
990: WHEN NO_DATA_FOUND
991: THEN
992: UPDATE bom_operation_sequences
993: SET standard_operation_id = NULL
994: WHERE routing_sequence_id = to_sequence_id
995: AND operation_sequence_id = p_op_seq_id;
996: END;
997: END LOOP;

Line 1456: standard_rate_flag,

1452: (operation_sequence_id,
1453: resource_seq_num,
1454: resource_id,
1455: activity_id,
1456: standard_rate_flag,
1457: assigned_units,
1458: usage_rate_or_amount,
1459: usage_rate_or_amount_inverse,
1460: basis_type,

Line 1501: b.standard_rate_flag,

1497: SELECT a.operation_sequence_id,
1498: b.resource_seq_num,
1499: d.resource_id,
1500: b.activity_id,
1501: b.standard_rate_flag,
1502: -- DECODE(E.AVAILABLE_24_HOURS_FLAG, 1, 1, B.ASSIGNED_UNITS), -- changed for bug 2661684
1503: b.assigned_units,
1504: b.usage_rate_or_amount,
1505: b.usage_rate_or_amount_inverse,

Line 1699: standard_rate_flag,

1695: resource_id,
1696: schedule_seq_num,
1697: replacement_group_num,
1698: activity_id,
1699: standard_rate_flag,
1700: assigned_units,
1701: usage_rate_or_amount,
1702: usage_rate_or_amount_inverse,
1703: basis_type,

Line 1745: b.standard_rate_flag,

1741: d.resource_id,
1742: b.schedule_seq_num,
1743: b.replacement_group_num,
1744: b.activity_id,
1745: b.standard_rate_flag,
1746: b.assigned_units,
1747: b.usage_rate_or_amount,
1748: b.usage_rate_or_amount_inverse,
1749: b.basis_type,

Line 2340: SELECT standard_operation_id,

2336:
2337: -- Cursor Bug fix 3473802
2338: CURSOR update_st_op
2339: IS
2340: SELECT standard_operation_id,
2341: operation_sequence_id
2342: FROM bom_operation_sequences
2343: WHERE routing_sequence_id = to_sequence_id;
2344: l_from_item_id NUMBER;

Line 2403: standard_operation_id,

2399: last_updated_by,
2400: creation_date,
2401: created_by,
2402: last_update_login,
2403: standard_operation_id,
2404: department_id,
2405: operation_lead_time_percent,
2406: minimum_transfer_quantity,
2407: count_point_type,

Line 2479: a.standard_operation_id,

2475: a.operation_sequence_id,
2476: l_curr_date,
2477: user_id,
2478: user_id,
2479: a.standard_operation_id,
2480: c.department_id,
2481: NULL,
2482: a.minimum_transfer_quantity,
2483: a.count_point_type,

Line 2832: SELECT b.standard_operation_id,

2828:
2829: EXIT WHEN update_st_op%NOTFOUND;
2830:
2831: BEGIN
2832: SELECT b.standard_operation_id,
2833: b.minimum_transfer_quantity,
2834: b.backflush_flag,
2835: b.option_dependent_flag,
2836: b.count_point_type,

Line 2844: FROM bom_standard_operations_v a, -- BUG 3936049

2840: back_flag,
2841: opt_flag,
2842: count_type,
2843: opr_desc
2844: FROM bom_standard_operations_v a, -- BUG 3936049
2845: bom_standard_operations_v b -- BUG 3936049
2846: WHERE a.standard_operation_id = p_st_op_id
2847: AND a.operation_code = b.operation_code
2848: AND a.organization_id = from_org_id

Line 2845: bom_standard_operations_v b -- BUG 3936049

2841: opt_flag,
2842: count_type,
2843: opr_desc
2844: FROM bom_standard_operations_v a, -- BUG 3936049
2845: bom_standard_operations_v b -- BUG 3936049
2846: WHERE a.standard_operation_id = p_st_op_id
2847: AND a.operation_code = b.operation_code
2848: AND a.organization_id = from_org_id
2849: AND b.organization_id = to_org_id

Line 2846: WHERE a.standard_operation_id = p_st_op_id

2842: count_type,
2843: opr_desc
2844: FROM bom_standard_operations_v a, -- BUG 3936049
2845: bom_standard_operations_v b -- BUG 3936049
2846: WHERE a.standard_operation_id = p_st_op_id
2847: AND a.operation_code = b.operation_code
2848: AND a.organization_id = from_org_id
2849: AND b.organization_id = to_org_id
2850: AND NVL (a.line_code, '@@@') = NVL (b.line_code, '@@@')

Line 2856: SET standard_operation_id = new_st_op_id,

2852: AND NVL (a.operation_type, -99) = NVL (b.operation_type,
2853: -99); -- BUG 3936049
2854:
2855: UPDATE bom_operation_sequences
2856: SET standard_operation_id = new_st_op_id,
2857: minimum_transfer_quantity = min_qty,
2858: backflush_flag = back_flag,
2859: option_dependent_flag = opt_flag,
2860: count_point_type = count_type,

Line 2870: SET standard_operation_id = NULL

2866: EXCEPTION
2867: WHEN NO_DATA_FOUND
2868: THEN
2869: UPDATE bom_operation_sequences
2870: SET standard_operation_id = NULL
2871: WHERE routing_sequence_id = to_sequence_id
2872: AND operation_sequence_id = p_op_seq_id;
2873: END;
2874: END LOOP;

Line 3285: standard_rate_flag,

3281: (operation_sequence_id,
3282: resource_seq_num,
3283: resource_id,
3284: activity_id,
3285: standard_rate_flag,
3286: assigned_units,
3287: usage_rate_or_amount,
3288: usage_rate_or_amount_inverse,
3289: basis_type,

Line 3330: b.standard_rate_flag,

3326: SELECT a.operation_sequence_id,
3327: b.resource_seq_num,
3328: d.resource_id,
3329: b.activity_id,
3330: b.standard_rate_flag,
3331: -- DECODE(E.AVAILABLE_24_HOURS_FLAG, 1, 1, B.ASSIGNED_UNITS), -- changed for bug 2661684
3332: b.assigned_units,
3333: b.usage_rate_or_amount,
3334: b.usage_rate_or_amount_inverse,

Line 3531: standard_rate_flag,

3527: resource_id,
3528: schedule_seq_num,
3529: replacement_group_num,
3530: activity_id,
3531: standard_rate_flag,
3532: assigned_units,
3533: usage_rate_or_amount,
3534: usage_rate_or_amount_inverse,
3535: basis_type,

Line 3576: b.standard_rate_flag,

3572: d.resource_id,
3573: b.schedule_seq_num,
3574: b.replacement_group_num,
3575: b.activity_id,
3576: b.standard_rate_flag,
3577: b.assigned_units,
3578: b.usage_rate_or_amount,
3579: b.usage_rate_or_amount_inverse,
3580: b.basis_type,