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 2483: mtl_system_items_b b,

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

Line 2511: mtl_system_items_b b,

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

Line 2598: mtl_system_items_b b,

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

Line 2620: mtl_system_items_b b,

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

Line 2836: FROM mtl_system_items_b msi,

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

Line 2851: FROM mtl_system_items_b msi,

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

Line 2866: FROM mtl_system_items_b msi

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

Line 3222: FROM mtl_system_items_b

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

Line 3239: mtl_system_items_b b,

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

Line 3257: mtl_system_items_b b,

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

Line 3283: mtl_system_items_b b,

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

Line 3300: mtl_system_items_b b,

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

Line 4156: FROM mtl_system_items_vl item,

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

Line 4253: FROM mtl_system_items_b

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

Line 4331: FROM mtl_system_items_b

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

Line 4406: FROM mtl_system_items_b

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

Line 4499: FROM mtl_system_items_b

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

Line 4638: FROM mtl_system_items_b

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

Line 4721: mtl_system_items_b kfv

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

Line 4774: FROM mtl_system_items_b

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

Line 4842: mtl_system_items_b kfv

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

Line 4896: FROM mtl_system_items_b

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

Line 9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;

9591: l_inv_org_id mtl_parameters.organization_id % TYPE;
9592: l_maint_org_id mtl_parameters.organization_id % TYPE;
9593: l_master_org_id mtl_parameters.organization_id % TYPE;
9594: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9599: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;

Line 9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;

9592: l_maint_org_id mtl_parameters.organization_id % TYPE;
9593: l_master_org_id mtl_parameters.organization_id % TYPE;
9594: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9599: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9600: l_sys_dt DATE;

Line 9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;

9593: l_master_org_id mtl_parameters.organization_id % TYPE;
9594: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9599: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9600: l_sys_dt DATE;
9601: l_end_dt DATE;

Line 9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;

9594: l_eam_enabled_flag mtl_parameters.eam_enabled_flag % TYPE;
9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9599: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9600: l_sys_dt DATE;
9601: l_end_dt DATE;
9602: l_start_dt DATE;

Line 9599: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;

9595: l_eam_type mtl_system_items_b.eam_item_type % TYPE;
9596: l_inv_item_id mtl_system_items_b.inventory_item_id % TYPE;
9597: l_enabled_flag mtl_system_items_b.enabled_flag % TYPE;
9598: l_last_vld_org_id mtl_system_items_b.inventory_item_id % TYPE;
9599: l_serv_req_enabled mtl_system_items_b.serv_req_enabled_code % TYPE;
9600: l_sys_dt DATE;
9601: l_end_dt DATE;
9602: l_start_dt DATE;
9603: l_dummy NUMBER;

Line 10397: FROM mtl_system_items_b

10393: -- Check if the platform is serial number controlled
10394:
10395: SELECT revision_qty_control_code
10396: INTO l_revision_qty_control_code
10397: FROM mtl_system_items_b
10398: WHERE inventory_item_id = p_platform_id
10399: AND organization_id = p_organization_id ;
10400:
10401: IF NVL(l_revision_qty_control_code,-99) = 2 THEN