DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on STANDARD

Line 4584: ar_standard_text_vl st

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

Line 4585: WHERE st.standard_text_id = lm.message_id

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

Line 4594: ar_standard_text_vl st

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

Line 4595: WHERE st.standard_text_id = lm.message_id

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