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 STANDARD

Line 1380: standard_operation_id,

1376: -- Find out at which operation/intra-op step the quantity lies in WIP_OPERATIONS table
1377: --bug 3370199 added wsm_op_seq_num
1378: select operation_seq_num,
1379: operation_sequence_id,
1380: standard_operation_id,
1381: department_id,
1382: decode(sign(QUANTITY_IN_QUEUE),1,QUANTITY_IN_QUEUE,0),
1383: decode(sign(QUANTITY_RUNNING),1,QUANTITY_RUNNING,0),
1384: decode(sign(QUANTITY_WAITING_TO_MOVE),1,QUANTITY_WAITING_TO_MOVE,0),

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 1406: WHERE standard_operation_id = l_wo_std_op_id;

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;
1410:

Line 1686: standard_operation_id

1682: --***VJ Changed for Performance Upgrade***--
1683: BEGIN
1684: SELECT operation_sequence_id,
1685: department_id,
1686: standard_operation_id
1687: INTO l_op_seq_id, -- CZH.I_OED-2: since select from BOS, replacement is already considered!
1688: l_dept_id,
1689: l_std_op_id
1690: FROM bom_operation_sequences

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 1727: WHERE NVL(operation_type, 1) = 1 -- Standard operation

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
1731: l_stmt_num := 210;

Line 1729: AND standard_operation_id = l_std_op_id;

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
1731: l_stmt_num := 210;
1732: l_op_code := '';
1733: end if;

Line 1771: select standard_operation_id,

1767: l_op_code := p_to_op_code;
1768: -- EA: CZH.bug 2362225
1769: l_stmt_num := 220;
1770: begin
1771: select standard_operation_id,
1772: department_id
1773: into l_std_op_id,
1774: l_dept_id
1775: from bom_standard_operations

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 1933: SELECT nvl(standard_operation_id, -1),

1929: IF ( nvl(p_to_op_seq_num, -1) <> -1) THEN -- JUMP to inside routing
1930:
1931: --***VJ Changed for Performance Upgrade***--
1932: BEGIN
1933: SELECT nvl(standard_operation_id, -1),
1934: nvl(department_id, -1),
1935: operation_sequence_id
1936: INTO l_jmp_std_op_id,
1937: l_jmp_dept_id,

Line 1971: IF (l_jmp_std_op_id <> -1) THEN -- a standard op

1967: --***VJ End Changes***--
1968:
1969: l_stmt_num := 250;
1970:
1971: IF (l_jmp_std_op_id <> -1) THEN -- a standard op
1972:
1973: -- Get corresponding op_code from BOS/BSO
1974: SELECT operation_code
1975: INTO l_jmp_op_code

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 1977: WHERE standard_operation_id = l_jmp_std_op_id

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;
1981: ELSE

Line 2026: SELECT nvl(standard_operation_id, -1),

2022:
2023: l_stmt_num := 270;
2024: --***VJ Changed for Performance Upgrade***--
2025: BEGIN
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

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 2219: standard_operation_id,

2215:
2216: l_stmt_num := 190;
2217: BEGIN
2218: SELECT operation_sequence_id,
2219: standard_operation_id,
2220: department_id,
2221: operation_seq_num,
2222: standard_operation_code
2223: INTO l_end_op_seq_id,

Line 2222: standard_operation_code

2218: SELECT operation_sequence_id,
2219: standard_operation_id,
2220: department_id,
2221: operation_seq_num,
2222: standard_operation_code
2223: INTO l_end_op_seq_id,
2224: l_end_std_op_id,
2225: l_end_dept_id,
2226: l_end_op_seq_num,

Line 2274: standard_operation_id,

2270: BEGIN
2271: SELECT operation_sequence_id,
2272: department_id,
2273: department_code,
2274: standard_operation_id,
2275: standard_operation_code,
2276: nvl(WCO.recommended, 'N'),
2277: scrap_account,
2278: backflush_flag

Line 2275: standard_operation_code,

2271: SELECT operation_sequence_id,
2272: department_id,
2273: department_code,
2274: standard_operation_id,
2275: standard_operation_code,
2276: nvl(WCO.recommended, 'N'),
2277: scrap_account,
2278: backflush_flag
2279: INTO l_op_seq_id,

Line 2349: select standard_operation_id,

2345: l_op_code := p_to_op_code;
2346: -- EA: CZH.bug 2362225
2347: l_stmt_num := 220;
2348: begin
2349: select standard_operation_id,
2350: department_id
2351: into l_std_op_id,
2352: l_dept_id
2353: from bom_standard_operations

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 2494: standard_operation_id,

2490: BEGIN
2491: SELECT operation_sequence_id,
2492: department_id,
2493: department_code,
2494: standard_operation_id,
2495: standard_operation_code,
2496: nvl(WCO.recommended, 'N'),
2497: scrap_account,
2498: backflush_flag

Line 2495: standard_operation_code,

2491: SELECT operation_sequence_id,
2492: department_id,
2493: department_code,
2494: standard_operation_id,
2495: standard_operation_code,
2496: nvl(WCO.recommended, 'N'),
2497: scrap_account,
2498: backflush_flag
2499: INTO l_jmp_op_seq_id,

Line 2572: SELECT nvl(standard_operation_id, -1),

2568:
2569: l_stmt_num := 270;
2570: --***VJ Changed for Performance Upgrade***--
2571: BEGIN
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

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 2940: SELECT standard_operation_id

2936: IF (l_wo_op_seq_id <> l_op_seq_id) AND (l_op_code is not NULL) THEN
2937: -- Check if p_fm_op_seq_num = p_to_op_seq_num
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;

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 3645: SELECT standard_operation_id,

3641: end if;
3642:
3643: l_stmt_num := 340;
3644: IF (g_aps_wps_profile='N') THEN
3645: SELECT standard_operation_id,
3646: department_id,
3647: operation_seq_num
3648: INTO l_end_std_op_id,
3649: l_end_dept_id,

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 3671: WHERE standard_operation_id = l_end_std_op_id;

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;
3675: --NSO Modification by abedajna begin

Line 5249: SELECT standard_operation_id

5245: --AND (l_temp = 0) THEN -- Fix for bug #1524416
5246:
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;

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 6877: AND BSOSC.standard_operation_id = BSO.standard_operation_id

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);
6879:
6880: l_stmt_num := 110.7;
6881: --bug 5490644 perform this check only if the txn is move txn

Line 12150: /********bug 5463926 Always look at BSO instead of BOS. For the case of non standard operation

12146: FROM WSM_PARAMETERS
12147: WHERE organization_id = p_organization_id;
12148:
12149: l_stmt_num := 30;
12150: /********bug 5463926 Always look at BSO instead of BOS. For the case of non standard operation
12151: trap the no data found exception and set the values
12152:
12153: IF (p_routing_operation IS NOT NULL) THEN
12154: --bug 5300662 change the interpretation of NULL value for the column use_org_settings to YES

Line 12177: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

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

Line 12180: AND BSO.standard_operation_id = WO.standard_operation_id

12176: l_bos_to_move_mandatory_flag
12177: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
12178: WHERE WO.wip_entity_id = p_wip_entity_id
12179: AND WO.operation_seq_num = p_operation_seq_num
12180: AND BSO.standard_operation_id = WO.standard_operation_id
12181: AND BSO.organization_id = WO.organization_id;
12182: END IF;
12183: ********/
12184: BEGIN

Line 12191: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO

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

Line 12194: AND BSO.standard_operation_id = WO.standard_operation_id

12190: l_bos_to_move_mandatory_flag
12191: FROM BOM_STANDARD_OPERATIONS BSO, WIP_OPERATIONS WO
12192: WHERE WO.wip_entity_id = p_wip_entity_id
12193: AND WO.operation_seq_num = p_operation_seq_num
12194: AND BSO.standard_operation_id = WO.standard_operation_id
12195: AND BSO.organization_id = WO.organization_id;
12196: EXCEPTION
12197: WHEN no_data_found THEN
12198: l_bos_use_org_settings := 1;

Line 12665: , p_standard_op_id IN NUMBER

12661: , p_wip_entity_id IN NUMBER
12662: , p_operation_seq_num IN NUMBER
12663: , p_routing_operation IN NUMBER
12664: , p_responsibility_id IN NUMBER
12665: , p_standard_op_id IN NUMBER
12666: , p_current_step_type IN NUMBER
12667: , p_status_type IN NUMBER
12668: , x_show_move_in OUT NOCOPY NUMBER
12669: , x_show_move_out OUT NOCOPY NUMBER

Line 12709: '; p_standard_op_id '||p_standard_op_id||

12705: '; p_wip_entity_id '||p_wip_entity_id||
12706: '; p_operation_seq_num '||p_operation_seq_num||
12707: '; p_routing_operation '||p_routing_operation||
12708: '; p_responsibility_id '||p_responsibility_id||
12709: '; p_standard_op_id '||p_standard_op_id||
12710: '; p_current_step_type '||p_current_step_type||
12711: '; p_status_type '||p_status_type,
12712: p_stmt_num => l_stmt_num ,
12713: p_msg_tokens => l_msg_tokens ,

Line 12777: p_standard_op_id => p_standard_op_id,

12773: p_responsibility_id => fnd_global.resp_id,
12774: p_wip_entity_id => p_wip_entity_id,
12775: p_org_id => p_organization_id,
12776: p_job_op_seq_num => p_operation_seq_num,
12777: p_standard_op_id => p_standard_op_id,
12778: p_intraop_step => p_current_step_type,
12779: p_status_type => p_status_type
12780: );
12781: END IF;

Line 12856: FROM BOM_STANDARD_OPERATIONS BSO

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

Line 12857: WHERE BSO.standard_operation_id = p_standard_op_id;

12853: ELSE
12854: SELECT nvl(BSO.show_lot_attrib, 0)
12855: INTO x_show_lot_attrib
12856: FROM BOM_STANDARD_OPERATIONS BSO
12857: WHERE BSO.standard_operation_id = p_standard_op_id;
12858: END IF;
12859: ********************************************************************/
12860: x_show_lot_attrib := 1;
12861: