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.WSMPLBMI dependencies on BOM_STANDARD_OPERATIONS

Line 1405: FROM bom_standard_operations

1401:
1402: IF (l_wo_std_op_id IS NOT NULL) THEN
1403: SELECT operation_code
1404: INTO l_wo_op_code
1405: FROM bom_standard_operations
1406: WHERE standard_operation_id = l_wo_std_op_id;
1407: ELSE
1408: l_wo_op_code := NULL;
1409: END IF;

Line 1726: FROM bom_standard_operations

1722: if (l_std_op_id is NOT NULL) then -- it is a std op
1723: l_stmt_num := 205;
1724: SELECT operation_code
1725: INTO l_op_code
1726: FROM bom_standard_operations
1727: WHERE NVL(operation_type, 1) = 1 -- Standard operation
1728: AND organization_id = p_org_id
1729: AND standard_operation_id = l_std_op_id;
1730: else -- it is a non-std op

Line 1775: from bom_standard_operations

1771: select standard_operation_id,
1772: department_id
1773: into l_std_op_id,
1774: l_dept_id
1775: from bom_standard_operations
1776: where nvl(operation_type, 1) = 1
1777: and organization_id = p_org_id
1778: and operation_code = p_to_op_code;
1779: exception

Line 1976: FROM bom_standard_operations

1972:
1973: -- Get corresponding op_code from BOS/BSO
1974: SELECT operation_code
1975: INTO l_jmp_op_code
1976: FROM bom_standard_operations
1977: WHERE standard_operation_id = l_jmp_std_op_id
1978: AND organization_id = p_org_id;
1979:
1980: l_stmt_num := 255;

Line 2030: FROM bom_standard_operations

2026: SELECT nvl(standard_operation_id, -1),
2027: nvl(department_id, -1)
2028: INTO l_jmp_std_op_id,
2029: l_jmp_dept_id
2030: FROM bom_standard_operations
2031: WHERE operation_code = p_to_op_code
2032: AND organization_id = p_org_id;
2033:
2034: EXCEPTION

Line 2353: from bom_standard_operations

2349: select standard_operation_id,
2350: department_id
2351: into l_std_op_id,
2352: l_dept_id
2353: from bom_standard_operations
2354: where nvl(operation_type, 1) = 1
2355: and organization_id = p_org_id
2356: and operation_code = p_to_op_code;
2357: exception

Line 2576: FROM bom_standard_operations

2572: SELECT nvl(standard_operation_id, -1),
2573: nvl(department_id, -1)
2574: INTO l_jmp_std_op_id,
2575: l_jmp_dept_id
2576: FROM bom_standard_operations
2577: WHERE operation_code = p_to_op_code
2578: AND organization_id = p_org_id;
2579:
2580: EXCEPTION

Line 2942: FROM bom_standard_operations

2938: --move enh changed l_std_operation_id to l_std_op_id
2939: IF (l_std_op_id IS NULL) THEN
2940: SELECT standard_operation_id
2941: INTO l_std_op_id
2942: FROM bom_standard_operations
2943: WHERE operation_code = l_op_code
2944: AND organization_id = p_org_id;
2945:
2946: END IF;

Line 3670: FROM bom_standard_operations

3666: IF (l_end_std_op_id IS NOT NULL) THEN
3667: IF (g_aps_wps_profile='N') THEN
3668: SELECT operation_code
3669: INTO l_end_op_code
3670: FROM bom_standard_operations
3671: WHERE standard_operation_id = l_end_std_op_id;
3672: END IF; --(g_aps_wps_profile='N')
3673:
3674: l_stmt_num := 350;

Line 5251: FROM bom_standard_operations

5247: if (l_op_code is not NULL) then
5248: l_stmt_num := 515;
5249: SELECT standard_operation_id
5250: INTO l_std_operation_id
5251: FROM bom_standard_operations
5252: WHERE operation_code = l_op_code
5253: AND organization_id = p_org_id;
5254: end if;
5255:

Line 6874: FROM BOM_STD_OP_SCRAP_CODES BSOSC, BOM_STANDARD_OPERATIONS BSO

6870:
6871: l_stmt_num := 110.6;
6872: SELECT max_acceptable_scrap_qty
6873: INTO l_max_acceptable_scrap_qty
6874: FROM BOM_STD_OP_SCRAP_CODES BSOSC, BOM_STANDARD_OPERATIONS BSO
6875: WHERE BSO.operation_code = l_fm_operation_code
6876: AND BSO.organization_id = l_organization_id
6877: AND BSOSC.standard_operation_id = BSO.standard_operation_id
6878: AND BSOSC.scrap_code = p_scrap_codes_tbls(l_header_id)(i);

Line 12175: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

12171: nvl(BSO.track_multiple_res_usage_dates, 0), nvl(BSO.to_move_mandatory_flag, 0)
12172: INTO l_bos_use_org_settings, l_bos_show_next_op_by_default,
12173: x_show_scrap_codes, l_bos_show_lot_attrib, l_bos_mul_res_usage_dates,
12174: l_bos_to_move_mandatory_flag
12175: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
12176: WHERE WO.wip_entity_id = p_wip_entity_id
12177: AND WO.operation_seq_num = p_operation_seq_num
12178: AND BSO.standard_operation_id = WO.standard_operation_id
12179: AND BSO.organization_id = WO.organization_id;

Line 12189: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

12185: nvl(BSO.track_multiple_res_usage_dates, 0), nvl(BSO.to_move_mandatory_flag, 0)
12186: INTO l_bos_use_org_settings, l_bos_show_next_op_by_default,
12187: x_show_scrap_codes, l_bos_show_lot_attrib, l_bos_mul_res_usage_dates,
12188: l_bos_to_move_mandatory_flag
12189: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
12190: WHERE WO.wip_entity_id = p_wip_entity_id
12191: AND WO.operation_seq_num = p_operation_seq_num
12192: AND BSO.standard_operation_id = WO.standard_operation_id
12193: AND BSO.organization_id = WO.organization_id;

Line 12854: FROM BOM_STANDARD_OPERATIONS BSO

12850: AND BOS.operation_sequence_id = WO.operation_sequence_id;
12851: ELSE
12852: SELECT nvl(BSO.show_lot_attrib, 0)
12853: INTO x_show_lot_attrib
12854: FROM BOM_STANDARD_OPERATIONS BSO
12855: WHERE BSO.standard_operation_id = p_standard_op_id;
12856: END IF;
12857: ********************************************************************/
12858: x_show_lot_attrib := 1;