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

Line 863: FROM MTL_SYSTEM_ITEMS

859: segment1,
860: description,
861: --Bug#2845959
862: primary_uom_code
863: FROM MTL_SYSTEM_ITEMS
864: WHERE inventory_item_id = p_inv_item_id
865: AND organization_id = p_inv_org_id;
866:
867: l_track_flag VARCHAR2(1);

Line 868: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;

864: WHERE inventory_item_id = p_inv_item_id
865: AND organization_id = p_inv_org_id;
866:
867: l_track_flag VARCHAR2(1);
868: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;
869: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
870: --Bug#2845959
871: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
872:

Line 869: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

865: AND organization_id = p_inv_org_id;
866:
867: l_track_flag VARCHAR2(1);
868: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;
869: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
870: --Bug#2845959
871: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
872:
873: /*-Bug# 3124577 : 11.5.10:Rule Migration----------------------------------------------

Line 871: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

867: l_track_flag VARCHAR2(1);
868: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;
869: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
870: --Bug#2845959
871: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
872:
873: /*-Bug# 3124577 : 11.5.10:Rule Migration----------------------------------------------
874: --cursor to fetch customer account
875: CURSOR party_account_csr(p_chrv_id IN NUMBER) is

Line 1462: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;

1458: l_asset_assignment_tbl instance_asset_tbl_type;
1459: l_txn_rec trx_rec_type;
1460:
1461: l_track_flag VARCHAR2(1);
1462: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;
1463: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1464: --Bug#2845959
1465: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
1466:

Line 1463: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

1459: l_txn_rec trx_rec_type;
1460:
1461: l_track_flag VARCHAR2(1);
1462: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;
1463: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1464: --Bug#2845959
1465: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
1466:
1467:

Line 1465: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

1461: l_track_flag VARCHAR2(1);
1462: l_item_name MTL_SYSTEM_ITEMS.SEGMENT1%TYPE;
1463: l_item_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1464: --Bug#2845959
1465: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
1466:
1467:
1468: CURSOR get_qty_csr (p_inst_line_id IN NUMBER) is
1469: SELECT cim.number_of_items,

Line 1488: FROM MTL_SYSTEM_ITEMS

1484: segment1,
1485: description,
1486: --Bug#2845959
1487: primary_uom_code
1488: FROM MTL_SYSTEM_ITEMS
1489: WHERE inventory_item_id = p_inv_item_id
1490: AND organization_id = p_inv_org_id;
1491:
1492: --cursor to fetch party location id

Line 1983: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

1979: l_ib_line_lty_code VARCHAR2(200) := G_IB_LINE_LTY_CODE;
1980: l_party_tbl party_tbl_type;
1981: l_model_line_qty NUMBER;
1982: --bug# 2845959
1983: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
1984: --rkuttiya added for bug #6795295
1985: l_start_date DATE;
1986:
1987: TYPE ib_cle_id_tbl is table of okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;

Line 2268: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

2264: l_inv_mstr_org_id NUMBER;
2265: l_cimv_rec cimv_rec_type;
2266: l_model_line_qty NUMBER;
2267: --bug# 2845959
2268: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
2269: --bug# 3222804
2270: l_inv_org_id NUMBER;
2271:
2272:

Line 2847: FROM mtl_system_items mtl,

2843: --cursor to find serialized
2844: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
2845: p_chr_id IN NUMBER) IS
2846: SELECT mtl.serial_number_control_code
2847: FROM mtl_system_items mtl,
2848: okc_k_headers_b chrb
2849: WHERE mtl.inventory_item_id = p_inv_item_id
2850: AND mtl.organization_id = chrb.inv_organization_id
2851: --BUG# 3489089

Line 2858: FROM mtl_system_items mtl,

2854: --cursor2 to find serialized
2855: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
2856: p_cle_id IN NUMBER) IS
2857: SELECT mtl.serial_number_control_code
2858: FROM mtl_system_items mtl,
2859: okc_k_headers_b chrb,
2860: okc_k_lines_b cleb
2861: WHERE mtl.inventory_item_id = p_inv_item_id
2862: AND mtl.organization_id = chrb.inv_organization_id

Line 2866: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;

2862: AND mtl.organization_id = chrb.inv_organization_id
2863: AND chrb.id = cleb.dnz_chr_id
2864: AND cleb.id = p_cle_id;
2865:
2866: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;
2867:
2868: l_exception_halt EXCEPTION;
2869:
2870: BEGIN

Line 3201: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

3197:
3198: l_party_tbl party_tbl_type;
3199: l_party_account NUMBER;
3200: l_inv_mstr_org_id NUMBER;
3201: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
3202: l_cimv_rec cimv_rec_type;
3203: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
3204: l_klev_rec okl_kle_pvt.klev_rec_type;
3205: x_clev_rec okl_okc_migration_pvt.clev_rec_type;