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.WSMPUTIL dependencies on MTL_PARAMETERS

Line 87: FROM MTL_PARAMETERS MP

83: /*
84: ** commented out by Bala Balakumar, June 01, 2000.
85: SELECT count(*)
86: INTO l_rowcount
87: FROM MTL_PARAMETERS MP
88: WHERE MP.ORGANIZATION_ID = p_organization_id
89: AND UPPER(WSM_ENABLED_FLAG)='Y';
90: */
91:

Line 98: FROM MTL_PARAMETERS MP, WSM_PARAMETERS WSM

94: */
95:
96: SELECT count(*)
97: INTO l_rowcount
98: FROM MTL_PARAMETERS MP, WSM_PARAMETERS WSM
99: WHERE WSM.ORGANIZATION_ID = p_organization_id
100: AND MP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
101: AND UPPER(MP.WSM_ENABLED_FLAG)='Y';
102:

Line 511: MTL_PARAMETERS MP

507: CURSOR forward_cur(p_lead_time NUMBER) IS
508: SELECT BCD1.CALENDAR_DATE
509: FROM BOM_CALENDAR_DATES BCD1,
510: BOM_CALENDAR_DATES BCD2,
511: MTL_PARAMETERS MP
512: WHERE MP.ORGANIZATION_ID = p_organization_id
513: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
514: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
515: AND BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID

Line 525: MTL_PARAMETERS MP

521: CURSOR backward_cur(p_lead_time NUMBER) IS
522: SELECT BCD1.CALENDAR_DATE
523: FROM BOM_CALENDAR_DATES BCD1,
524: BOM_CALENDAR_DATES BCD2,
525: MTL_PARAMETERS MP
526: WHERE MP.ORGANIZATION_ID = p_organization_id
527: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
528: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
529: AND BCD1.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID

Line 1296: From MTL_PARAMETERS MTL, WIP_PARAMETERS WIP

1292: l_wpsEnabledFlag
1293: /*BA#1490834*/
1294: , l_wmsEnabledFlag
1295: /*EA#1490834*/
1296: From MTL_PARAMETERS MTL, WIP_PARAMETERS WIP
1297: Where MTL.organization_id = p_organization_id
1298: And MTL.organization_id = WIP.organization_id (+);
1299:
1300: If l_primaryCostMethod <> 1 Then

Line 2572: mtl_parameters MP

2568: into l_sub_loc_control, l_org_loc_control,
2569: l_restrict_locators_code, l_item_loc_control
2570: FROM mtl_system_items MS,
2571: mtl_secondary_inventories MSUB,
2572: mtl_parameters MP
2573: WHERE MP.organization_id = p_organization_id
2574: AND MS.organization_id = p_organization_id
2575: AND MS.inventory_item_id = p_assembly_item_id
2576: AND MSUB.secondary_inventory_name = p_completion_subinventory