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.CSI_UTL_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

2295: p_order_line_rec IN csi_order_ship_pub.order_line_rec)
2296: RETURN BOOLEAN
2297: IS
2298:
2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
2300: l_bom_found varchar2(1);
2301: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2302: l_explosion_level number;
2303: l_explode_flag varchar2(3);

Line 6215: mtl_system_items_b c

6211: ---For Shippable and Non-shippable Items--
6212: SELECT a.*
6213: FROM csi_t_txn_line_details a ,
6214: csi_t_transaction_lines b ,
6215: mtl_system_items_b c
6216: WHERE a.transaction_line_id = b.transaction_line_id
6217: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')
6218: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))
6219: AND a.instance_id IS NOT NULL ---meaning it is already processed. or it is Non Source

Line 7418: mtl_system_items_b1_kfv sysitems,

7414: okc_k_lines_b tl,
7415: okc_statuses_v sts,
7416: okc_k_items sli,
7417: okc_k_items li,
7418: mtl_system_items_b1_kfv sysitems,
7419: okc_line_styles_v tlst
7420: where sl.id = sli.cle_id
7421: and sl.sts_code=sts.code
7422: and tl.lse_id = tlst.id