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.OKS_AUTH_UTIL_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 46: FROM OKX_SYSTEM_ITEMS_V

42: x_description OUT NOCOPY VARCHAR2 )
43: IS
44: CURSOR l_csr_get_name_desc(p_inv_id IN NUMBER) IS
45: SELECT name, description
46: FROM OKX_SYSTEM_ITEMS_V
47: WHERE id1 = p_inv_id
48: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE)) ;
49:
50: l_sp_flag VARCHAR2(1);

Line 51: l_name OKX_SYSTEM_ITEMS_V.name%TYPE;

47: WHERE id1 = p_inv_id
48: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE)) ;
49:
50: l_sp_flag VARCHAR2(1);
51: l_name OKX_SYSTEM_ITEMS_V.name%TYPE;
52: l_description OKX_SYSTEM_ITEMS_V.name%TYPE;
53:
54: BEGIN
55: OPEN l_csr_get_name_desc(p_inv_id) ;

Line 52: l_description OKX_SYSTEM_ITEMS_V.name%TYPE;

48: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE)) ;
49:
50: l_sp_flag VARCHAR2(1);
51: l_name OKX_SYSTEM_ITEMS_V.name%TYPE;
52: l_description OKX_SYSTEM_ITEMS_V.name%TYPE;
53:
54: BEGIN
55: OPEN l_csr_get_name_desc(p_inv_id) ;
56: FETCH l_csr_get_name_desc INTO l_name, l_description ;

Line 771: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;

767: FROM OKX_UNITS_OF_MEASURE_V
768: WHERE uom_code = p_uom_code ;
769:
770:
771: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;
772: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
773: BEGIN
774: rowcount := px_rowcount;
775:

Line 772: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;

768: WHERE uom_code = p_uom_code ;
769:
770:
771: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;
772: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
773: BEGIN
774: rowcount := px_rowcount;
775:
776: ----------------------errorout_an(' in populate table ');

Line 895: FROM okx_system_items_v it

891: IS
892: SELECT DISTINCT id1,
893: name,
894: description
895: FROM okx_system_items_v it
896: WHERE id1 IN
897: (SELECT inventory_item_id FROM
898: csi_item_instances
899: WHERE instance_id IN (SELECT PR.object_id

Line 953: , OKX_SYSTEM_ITEMS_V IT

949: , CII.external_reference -- bug 4372877
950: FROM CSI_ITEM_INSTANCES CII
951: , CSI_INSTANCE_STATUSES CIS
952: , OE_ORDER_LINES_ALL OOL
953: , OKX_SYSTEM_ITEMS_V IT
954: WHERE CII.INSTANCE_ID = p_instance_id
955: AND CII.inventory_item_id = IT.id1
956: AND IT.serviceable_product_flag = 'Y'
957: AND IT.organization_id = p_organization_id

Line 1396: FROM okx_system_items_v it

1392: IS
1393: /* Cursor to select all Model having Covered Products for a given Party ID */
1394: CURSOR l_csr_all_models(p_party_id IN NUMBER, p_organization_id IN NUMBER) IS
1395: SELECT DISTINCT id1, name, description
1396: FROM okx_system_items_v it
1397: WHERE id1 IN
1398: (SELECT inventory_item_id
1399: FROM csi_item_instances
1400: WHERE instance_id IN

Line 1449: OKX_SYSTEM_ITEMS_V IT

1445: CII.external_reference -- bug 4372877
1446: FROM CSI_ITEM_INSTANCES CII,
1447: CSI_INSTANCE_STATUSES CIS,
1448: OE_ORDER_LINES_ALL OOL,
1449: OKX_SYSTEM_ITEMS_V IT
1450: WHERE CII.INSTANCE_ID = p_instance_id
1451: AND CII.inventory_item_id = IT.id1
1452: AND IT.serviceable_product_flag = 'Y'
1453: AND IT.organization_id = p_organization_id

Line 1511: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;

1507: FROM OKX_UNITS_OF_MEASURE_V
1508: WHERE uom_code = p_uom_code ;
1509:
1510:
1511: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;
1512: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
1513:
1514: BEGIN
1515: rowcount := 1;

Line 1512: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;

1508: WHERE uom_code = p_uom_code ;
1509:
1510:
1511: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;
1512: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
1513:
1514: BEGIN
1515: rowcount := 1;
1516:

Line 4329: FROM OKX_SYSTEM_ITEMS_V

4325:
4326: CURSOR l_csr_get_item_name(p_inventory_item_Id IN NUMBER)
4327: IS
4328: SELECT name
4329: FROM OKX_SYSTEM_ITEMS_V
4330: WHERE id1 = p_inventory_item_id
4331: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4332: AND ROWNUM < 2;
4333:

Line 4334: l_item_name OKX_SYSTEM_ITEMS_V.name%TYPE;

4330: WHERE id1 = p_inventory_item_id
4331: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4332: AND ROWNUM < 2;
4333:
4334: l_item_name OKX_SYSTEM_ITEMS_V.name%TYPE;
4335:
4336: BEGIN
4337:
4338: OPEN l_csr_Get_item_name(p_inventory_item_id);

Line 4355: FROM OKX_SYSTEM_ITEMS_V

4351:
4352: CURSOR l_csr_get_item_desc(p_inventory_item_Id IN NUMBER)
4353: IS
4354: SELECT description
4355: FROM OKX_SYSTEM_ITEMS_V
4356: WHERE id1 = p_inventory_item_id
4357: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4358: AND ROWNUM < 2;
4359:

Line 4360: l_item_desc OKX_SYSTEM_ITEMS_V.description%TYPE;

4356: WHERE id1 = p_inventory_item_id
4357: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4358: AND ROWNUM < 2;
4359:
4360: l_item_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
4361:
4362: BEGIN
4363:
4364: OPEN l_csr_Get_item_desc(p_inventory_item_id);

Line 4382: FROM OKX_SYSTEM_ITEMS_V

4378: CURSOR l_csr_get_item_desc(p_inventory_item_Id IN NUMBER,
4379: p_organization_id IN NUMBER)
4380: IS
4381: SELECT description
4382: FROM OKX_SYSTEM_ITEMS_V
4383: WHERE inventory_item_id = p_inventory_item_id
4384: AND organization_id = p_organization_id
4385: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
4386: AND ROWNUM < 2;

Line 4730: --FROM okx_system_items_v

4726:
4727: --Bug 5041682, modifed the cursor to have a lower parse time, current query takes 3 seconds
4728: CURSOR l_covtemp_csr IS
4729: --SELECT coverage_template_id
4730: --FROM okx_system_items_v
4731: --WHERE id1 = p_item_id
4732: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4733: SELECT COVERAGE_SCHEDULE_ID
4734: FROM mtl_system_items_b

Line 6266: l_inv_item_id OKX_system_items_v.id1%TYPE;

6262: /* Cursors for traversing logic to get site id */
6263: /* Fetch ship_to_site_use_id and bill_to_site_use_id */
6264:
6265:
6266: l_inv_item_id OKX_system_items_v.id1%TYPE;
6267: l_inv_organization_id NUMBER;
6268: l_dnz_chr_id NUMBER;
6269: l_party_id NUMBER;
6270: l_uom OKC_K_ITEMS.uom_code%TYPE;