DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on STANDARD

Line 4456: ar_standard_text_vl st

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
4460: AND lm.rule_id = p_rule_id

Line 4457: WHERE st.standard_text_id = lm.message_id

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
4460: AND lm.rule_id = p_rule_id
4461: AND lm.exception_code = p_legal_message_exception;

Line 4466: ar_standard_text_vl st

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
4470: AND lm.exception_code = p_legal_message_exception;

Line 4467: WHERE st.standard_text_id = lm.message_id

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
4470: AND lm.exception_code = p_legal_message_exception;
4471: END IF;