DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_LGL_MSG

Line 4583: FROM jl_zz_ar_tx_lgl_msg lm,

4579: IF v_rule IN ('GET_ITEM_TX_CODE', 'GET_EXC_ITEM_TX_CODE')
4580: THEN
4581: SELECT substr(st.text,1,150)
4582: INTO v_message_text
4583: FROM jl_zz_ar_tx_lgl_msg lm,
4584: ar_standard_text_vl st
4585: WHERE st.standard_text_id = lm.message_id
4586: AND lm.rule_data_id = p_rule_data_id
4587: AND lm.inventory_organization_id = p_ship_from_warehouse_id

Line 4593: FROM jl_zz_ar_tx_lgl_msg lm,

4589: AND lm.exception_code = p_legal_message_exception;
4590: ELSE
4591: SELECT substr(st.text,1,150)
4592: INTO v_message_text
4593: FROM jl_zz_ar_tx_lgl_msg lm,
4594: ar_standard_text_vl st
4595: WHERE st.standard_text_id = lm.message_id
4596: AND lm.rule_data_id = p_rule_data_id
4597: AND lm.rule_id = p_rule_id