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.CS_SERVICEREQUEST_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 224: -- mtl_system_items_b table.

220: -- Procedure Name : get_item_details
221: -- Parameter :
222: -- IN : p_inv_item_id inventory item. This paramter and
223: -- p_inventory_org id is a key to
224: -- mtl_system_items_b table.
225: -- : p_inventory__org_id inventory organization
226: -- OUT : x_enable_flag indicates if item is enabled
227: -- : x_serv_req_enabled indicates if inv item can be used
228: -- in a service request.

Line 266: mtl_system_items

262: , x_eam_item_type
263: , x_start_date_active
264: , x_end_date_active
265: FROM
266: mtl_system_items
267: WHERE organization_id = p_inventory_org_id
268: AND inventory_item_id = p_inv_item_id;
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: EXCEPTION

Line 2481: mtl_system_items_b b,

2477: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2478: SELECT a.inventory_item_id
2479: INTO p_inventory_item_id
2480: FROM csi_item_instances a,
2481: mtl_system_items_b b,
2482: csi_i_parties cip
2483: WHERE a.instance_id = p_customer_product_id
2484: --AND a.owner_party_id = p_customer_id
2485: AND cip.party_id = p_customer_id

Line 2509: mtl_system_items_b b,

2505: ELSE
2506: SELECT a.inventory_item_id
2507: INTO p_inventory_item_id
2508: FROM csi_item_instances a,
2509: mtl_system_items_b b,
2510: csi_i_parties cip
2511: WHERE a.instance_id = p_customer_product_id
2512: -- AND a.owner_party_id = p_customer_id
2513: AND cip.party_id = p_customer_id

Line 2596: mtl_system_items_b b,

2592: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2593:
2594: SELECT 'x' INTO l_dummy
2595: FROM csi_item_instances a,
2596: mtl_system_items_b b,
2597: csi_i_parties cip
2598: WHERE a.instance_id = p_customer_product_id
2599: AND a.serial_number = p_current_serial_number
2600: -- AND a.owner_party_account_id = p_customer_id

Line 2618: mtl_system_items_b b,

2614: AND rownum<2;
2615: ELSE
2616: SELECT 'x' INTO l_dummy
2617: FROM csi_item_instances a,
2618: mtl_system_items_b b,
2619: csi_i_parties cip
2620: WHERE a.instance_id = p_customer_product_id
2621: AND a.serial_number = p_current_serial_number
2622: -- AND a.owner_party_account_id = p_customer_id

Line 2834: FROM mtl_system_items_b msi,

2830: ELSIF p_inv_org_master_org_flag = 'Y'
2831: THEN
2832: SELECT 'X'
2833: INTO l_dummy
2834: FROM mtl_system_items_b msi,
2835: mtl_parameters mp
2836: WHERE msi.inventory_item_id = p_inventory_item_id
2837: AND msi.enabled_flag = 'Y'
2838: AND msi.serv_req_enabled_code = 'E'

Line 2849: FROM mtl_system_items_b msi,

2845: AND rownum = 1;
2846: ELSE
2847: SELECT 'X'
2848: INTO l_dummy
2849: FROM mtl_system_items_b msi,
2850: mtl_parameters mp
2851: WHERE msi.inventory_item_id = p_inventory_item_id
2852: AND msi.enabled_flag = 'Y'
2853: AND msi.serv_req_enabled_code = 'E'

Line 2864: FROM mtl_system_items_b msi

2860: END IF; -- end if for condition p_maint_organization_id IS NULL
2861: ELSE
2862: -- item is not EAM
2863: SELECT 'x' INTO l_dummy
2864: FROM mtl_system_items_b msi
2865: WHERE msi.inventory_item_id = p_inventory_item_id
2866: AND msi.enabled_flag = 'Y'
2867: AND msi.serv_req_enabled_code = 'E'
2868: -- For ER 3701924

Line 3220: FROM mtl_system_items_b

3216: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
3217:
3218: CURSOR c_ib_restrict
3219: IS SELECT COMMS_NL_TRACKABLE_FLAG
3220: FROM mtl_system_items_b
3221: WHERE inventory_item_id = p_inventory_item_id
3222: AND organization_id = p_inventory_org_id;
3223:
3224: BEGIN

Line 3237: mtl_system_items_b b,

3233: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
3234:
3235: SELECT 'x' INTO l_dummy
3236: FROM csi_item_instances a,
3237: mtl_system_items_b b,
3238: csi_i_parties cip
3239: WHERE a.instance_id = p_customer_product_id
3240: AND a.external_reference = p_external_reference
3241: AND cip.party_id = p_customer_id

Line 3255: mtl_system_items_b b,

3251: ELSE
3252:
3253: SELECT 'x' INTO l_dummy
3254: FROM csi_item_instances a,
3255: mtl_system_items_b b,
3256: csi_i_parties cip
3257: WHERE a.instance_id = p_customer_product_id
3258: AND a.external_reference = p_external_reference
3259: AND cip.party_id = p_customer_id

Line 3281: mtl_system_items_b b,

3277: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
3278:
3279: SELECT 'X' INTO l_dummy
3280: FROM csi_item_instances a,
3281: mtl_system_items_b b,
3282: csi_i_parties cip
3283: WHERE b.inventory_item_id = p_inventory_item_id
3284: AND b.organization_id = p_inventory_org_id
3285: AND b.inventory_item_id = a.inventory_item_id

Line 3298: mtl_system_items_b b,

3294: ELSE
3295:
3296: SELECT 'X' INTO l_dummy
3297: FROM csi_item_instances a,
3298: mtl_system_items_b b,
3299: csi_i_parties cip
3300: WHERE b.inventory_item_id = p_inventory_item_id
3301: AND b.organization_id = p_inventory_org_id
3302: AND b.inventory_item_id = a.inventory_item_id

Line 4154: FROM mtl_system_items_vl item,

4150: x_return_status := FND_API.G_RET_STS_SUCCESS;
4151:
4152: SELECT NVL(revision_qty_control_code,0)
4153: INTO l_control_code
4154: FROM mtl_system_items_vl item,
4155: mtl_item_categories ic
4156: WHERE item.organization_id = p_organization_id
4157: AND item.inventory_item_id = p_platform_id
4158: AND item.organization_id = ic.organization_id

Line 4251: FROM mtl_system_items_b

4247: x_return_status := FND_API.G_RET_STS_SUCCESS;
4248: BEGIN
4249: SELECT revision_qty_control_code
4250: INTO l_rev_control_code
4251: FROM mtl_system_items_b
4252: WHERE inventory_item_id = p_inventory_item_id
4253: AND organization_id = p_inventory_org_id;
4254:
4255: IF l_rev_control_code = 2 THEN

Line 4329: FROM mtl_system_items_b

4325:
4326:
4327: CURSOR c_rev_code(l_inv_item_id IN NUMBER)
4328: IS SELECT revision_qty_control_code
4329: FROM mtl_system_items_b
4330: WHERE inventory_item_id = l_inv_item_id
4331: AND organization_id = p_inventory_org_id;
4332:
4333: BEGIN

Line 4404: FROM mtl_system_items_b

4400:
4401:
4402: CURSOR c_rev_code(l_inv_item_id IN NUMBER)
4403: IS SELECT revision_qty_control_code
4404: FROM mtl_system_items_b
4405: WHERE inventory_item_id = l_inv_item_id
4406: AND organization_id = p_inventory_org_id;
4407:
4408: BEGIN

Line 4497: FROM mtl_system_items_b

4493:
4494:
4495: CURSOR c_rev_code(l_inv_item_id IN NUMBER)
4496: IS SELECT revision_qty_control_code
4497: FROM mtl_system_items_b
4498: WHERE inventory_item_id = l_inv_item_id
4499: AND organization_id = p_inventory_org_id;
4500:
4501: BEGIN

Line 4636: FROM mtl_system_items_b

4632:
4633: BEGIN
4634: SELECT revision_qty_control_code
4635: INTO l_rev_control_code
4636: FROM mtl_system_items_b
4637: WHERE inventory_item_id = p_inventory_item_id
4638: AND serv_req_enabled_code = 'E'
4639: AND organization_id = p_inventory_org_id;
4640:

Line 4719: mtl_system_items_b kfv

4715: SELECT 'X' INTO l_test
4716: FROM
4717: bom_bill_of_materials bom,
4718: bom_inventory_components bic,
4719: mtl_system_items_b kfv
4720: WHERE
4721: bom.organization_id = kfv.organization_id AND
4722: bic.bill_sequence_id = bom.common_bill_sequence_id AND
4723: trunc(sysdate) between trunc(bic.effectivity_date) and

Line 4772: FROM mtl_system_items_b

4768: x_return_status := FND_API.G_RET_STS_SUCCESS;
4769:
4770: SELECT revision_qty_control_code
4771: INTO l_rev_control_code
4772: FROM mtl_system_items_b
4773: WHERE inventory_item_id = p_inv_component_id
4774: AND organization_id = p_inventory_org_id;
4775:
4776: IF l_rev_control_code = 2 THEN

Line 4840: mtl_system_items_b kfv

4836: SELECT 'X' INTO l_test
4837: FROM
4838: bom_bill_of_materials bom,
4839: bom_inventory_components bic,
4840: mtl_system_items_b kfv
4841: WHERE
4842: bom.organization_id = kfv.organization_id AND
4843: bic.bill_sequence_id = bom.common_bill_sequence_id AND
4844: trunc(sysdate) between trunc(bic.effectivity_date) and

Line 4894: FROM mtl_system_items_b

4890: x_return_status := FND_API.G_RET_STS_SUCCESS;
4891:
4892: SELECT revision_qty_control_code
4893: INTO l_rev_control_code
4894: FROM mtl_system_items_b
4895: WHERE inventory_item_id = p_inv_subcomponent_id
4896: AND organization_id = p_inventory_org_id;
4897:
4898: IF l_rev_control_code = 2 THEN

Line 9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;

9539: l_inv_org_id mtl_parameters.organization_id % TYPE;
9540: l_maint_org_id mtl_parameters.organization_id % TYPE;
9541: l_master_org_id mtl_parameters.organization_id % TYPE;
9542: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9547: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;

Line 9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;

9540: l_maint_org_id mtl_parameters.organization_id % TYPE;
9541: l_master_org_id mtl_parameters.organization_id % TYPE;
9542: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9547: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9548: l_sys_dt DATE;

Line 9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;

9541: l_master_org_id mtl_parameters.organization_id % TYPE;
9542: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9547: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9548: l_sys_dt DATE;
9549: l_end_dt DATE;

Line 9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;

9542: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9547: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9548: l_sys_dt DATE;
9549: l_end_dt DATE;
9550: l_start_dt DATE;

Line 9547: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;

9543: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9544: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9545: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9546: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9547: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9548: l_sys_dt DATE;
9549: l_end_dt DATE;
9550: l_start_dt DATE;
9551: l_dummy NUMBER;

Line 10317: FROM mtl_system_items_b

10313: -- Check if the platform is serial number controlled
10314:
10315: SELECT revision_qty_control_code
10316: INTO l_revision_qty_control_code
10317: FROM mtl_system_items_b
10318: WHERE inventory_item_id = p_platform_id
10319: AND organization_id = p_organization_id ;
10320:
10321: IF NVL(l_revision_qty_control_code,-99) = 2 THEN