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 689: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;

685: FROM OKX_UNITS_OF_MEASURE_V
686: WHERE uom_code = p_uom_code ;
687:
688:
689: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;
690: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
691: BEGIN
692: rowcount := px_rowcount;
693:

Line 690: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;

686: WHERE uom_code = p_uom_code ;
687:
688:
689: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;
690: l_gen_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
691: BEGIN
692: rowcount := px_rowcount;
693:
694: ----------------------errorout_an(' in populate table ');

Line 812: FROM okx_system_items_v it

808: IS
809: SELECT DISTINCT id1,
810: name,
811: description
812: FROM okx_system_items_v it
813: WHERE id1 IN
814: (SELECT inventory_item_id FROM
815: csi_item_instances
816: WHERE instance_id IN (SELECT PR.object_id

Line 870: , OKX_SYSTEM_ITEMS_V IT

866: , CII.external_reference -- bug 4372877
867: FROM CSI_ITEM_INSTANCES CII
868: , CSI_INSTANCE_STATUSES CIS
869: , OE_ORDER_LINES_ALL OOL
870: , OKX_SYSTEM_ITEMS_V IT
871: WHERE CII.INSTANCE_ID = p_instance_id
872: AND CII.inventory_item_id = IT.id1
873: AND IT.serviceable_product_flag = 'Y'
874: AND IT.organization_id = p_organization_id

Line 3789: FROM OKX_SYSTEM_ITEMS_V

3785:
3786: CURSOR l_csr_get_item_name(p_inventory_item_Id IN NUMBER)
3787: IS
3788: SELECT name
3789: FROM OKX_SYSTEM_ITEMS_V
3790: WHERE id1 = p_inventory_item_id
3791: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3792: AND ROWNUM < 2;
3793:

Line 3794: l_item_name OKX_SYSTEM_ITEMS_V.name%TYPE;

3790: WHERE id1 = p_inventory_item_id
3791: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3792: AND ROWNUM < 2;
3793:
3794: l_item_name OKX_SYSTEM_ITEMS_V.name%TYPE;
3795:
3796: BEGIN
3797:
3798: OPEN l_csr_Get_item_name(p_inventory_item_id);

Line 3815: FROM OKX_SYSTEM_ITEMS_V

3811:
3812: CURSOR l_csr_get_item_desc(p_inventory_item_Id IN NUMBER)
3813: IS
3814: SELECT description
3815: FROM OKX_SYSTEM_ITEMS_V
3816: WHERE id1 = p_inventory_item_id
3817: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3818: AND ROWNUM < 2;
3819:

Line 3820: l_item_desc OKX_SYSTEM_ITEMS_V.description%TYPE;

3816: WHERE id1 = p_inventory_item_id
3817: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3818: AND ROWNUM < 2;
3819:
3820: l_item_desc OKX_SYSTEM_ITEMS_V.description%TYPE;
3821:
3822: BEGIN
3823:
3824: OPEN l_csr_Get_item_desc(p_inventory_item_id);

Line 3842: FROM OKX_SYSTEM_ITEMS_V

3838: CURSOR l_csr_get_item_desc(p_inventory_item_Id IN NUMBER,
3839: p_organization_id IN NUMBER)
3840: IS
3841: SELECT description
3842: FROM OKX_SYSTEM_ITEMS_V
3843: WHERE inventory_item_id = p_inventory_item_id
3844: AND organization_id = p_organization_id
3845: AND TRUNC(SYSDATE) BETWEEN trunc(nvl(start_date_active, SYSDATE)) AND trunc(nvl(end_date_active, SYSDATE))
3846: AND ROWNUM < 2;

Line 4190: --FROM okx_system_items_v

4186:
4187: --Bug 5041682, modifed the cursor to have a lower parse time, current query takes 3 seconds
4188: CURSOR l_covtemp_csr IS
4189: --SELECT coverage_template_id
4190: --FROM okx_system_items_v
4191: --WHERE id1 = p_item_id
4192: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4193: SELECT COVERAGE_SCHEDULE_ID
4194: FROM mtl_system_items_b

Line 5652: l_inv_item_id OKX_system_items_v.id1%TYPE;

5648: /* Cursors for traversing logic to get site id */
5649: /* Fetch ship_to_site_use_id and bill_to_site_use_id */
5650:
5651:
5652: l_inv_item_id OKX_system_items_v.id1%TYPE;
5653: l_inv_organization_id NUMBER;
5654: l_dnz_chr_id NUMBER;
5655: l_party_id NUMBER;
5656: l_uom OKC_K_ITEMS.uom_code%TYPE;