DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_LGL_MSG

Line 4455: FROM jl_zz_ar_tx_lgl_msg lm,

4451: IF v_rule IN ('GET_ITEM_TX_CODE', 'GET_EXC_ITEM_TX_CODE')
4452: THEN
4453: SELECT substr(st.text,1,150)
4454: INTO v_message_text
4455: FROM jl_zz_ar_tx_lgl_msg lm,
4456: ar_standard_text_vl st
4457: WHERE st.standard_text_id = lm.message_id
4458: AND lm.rule_data_id = p_rule_data_id
4459: AND lm.inventory_organization_id = p_ship_from_warehouse_id

Line 4465: FROM jl_zz_ar_tx_lgl_msg lm,

4461: AND lm.exception_code = p_legal_message_exception;
4462: ELSE
4463: SELECT substr(st.text,1,150)
4464: INTO v_message_text
4465: FROM jl_zz_ar_tx_lgl_msg lm,
4466: ar_standard_text_vl st
4467: WHERE st.standard_text_id = lm.message_id
4468: AND lm.rule_data_id = p_rule_data_id
4469: AND lm.rule_id = p_rule_id