DBA Data[Home] [Help]

APPS.OKL_TXL_ITM_INSTS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 983: mtl_system_items mtl

979: mtl.description item_desc
980: FROM okc_k_lines_b line,
981: okc_line_styles_b style,
982: okc_k_items kitem,
983: mtl_system_items mtl
984: WHERE line.lse_id = style.id
985: AND style.lty_code = 'ITEM'
986: AND line.id = kitem.cle_id
987: AND kitem.jtot_object1_code = 'OKX_SYSITEM'

Line 1021: l_serial_control mtl_system_items.serial_number_control_code%TYPE;

1017:
1018: l_chr_valid VARCHAR2(1);
1019: l_asset_line_id NUMBER;
1020: l_return_status VARCHAR2(1);
1021: l_serial_control mtl_system_items.serial_number_control_code%TYPE;
1022: l_item_desc mtl_system_items.description%TYPE;
1023:
1024:
1025: FUNCTION get_rec (

Line 1022: l_item_desc mtl_system_items.description%TYPE;

1018: l_chr_valid VARCHAR2(1);
1019: l_asset_line_id NUMBER;
1020: l_return_status VARCHAR2(1);
1021: l_serial_control mtl_system_items.serial_number_control_code%TYPE;
1022: l_item_desc mtl_system_items.description%TYPE;
1023:
1024:
1025: FUNCTION get_rec (
1026: p_id IN NUMBER,