DBA Data[Home] [Help]

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 2820: FROM mtl_system_items mtl,

2816: --cursor to find serialized
2817: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
2818: p_chr_id IN NUMBER) IS
2819: SELECT mtl.serial_number_control_code
2820: FROM mtl_system_items mtl,
2821: okc_k_headers_b chrb
2822: WHERE mtl.inventory_item_id = p_inv_item_id
2823: AND mtl.organization_id = chrb.inv_organization_id
2824: --BUG# 3489089

Line 2831: FROM mtl_system_items mtl,

2827: --cursor2 to find serialized
2828: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
2829: p_cle_id IN NUMBER) IS
2830: SELECT mtl.serial_number_control_code
2831: FROM mtl_system_items mtl,
2832: okc_k_headers_b chrb,
2833: okc_k_lines_b cleb
2834: WHERE mtl.inventory_item_id = p_inv_item_id
2835: AND mtl.organization_id = chrb.inv_organization_id

Line 2839: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;

2835: AND mtl.organization_id = chrb.inv_organization_id
2836: AND chrb.id = cleb.dnz_chr_id
2837: AND cleb.id = p_cle_id;
2838:
2839: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;
2840:
2841: l_exception_halt EXCEPTION;
2842:
2843: BEGIN

Line 3164: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;

3160:
3161: l_party_tbl party_tbl_type;
3162: l_party_account NUMBER;
3163: l_inv_mstr_org_id NUMBER;
3164: l_primary_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
3165: l_cimv_rec cimv_rec_type;
3166: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
3167: l_klev_rec okl_kle_pvt.klev_rec_type;
3168: x_clev_rec okl_okc_migration_pvt.clev_rec_type;