DBA Data[Home] [Help]

APPS.OE_VERSION_COMP dependencies on OE_SALES_CREDITS

Line 18470: FROM OE_SALES_CREDITS

18466: ,x_header_scredit_rec.WH_UPDATE_DATE
18467: ,x_header_scredit_rec.SALES_GROUP_ID
18468: ,x_header_scredit_rec.SALES_GROUP_UPDATED_FLAG
18469: ,x_header_scredit_rec.LOCK_CONTROL
18470: FROM OE_SALES_CREDITS
18471: WHERE
18472: HEADER_ID = p_header_id
18473: AND sales_credit_id = p_sales_credit_id
18474: AND LINE_ID IS NULL;

Line 19583: from oe_sales_credits

19579: --and phase_change_flag = p_transaction_phase_code
19580: and version_number in (p_prior_version,p_current_version,p_next_version)
19581: union
19582: SELECT sales_credit_id
19583: from oe_sales_credits
19584: where header_id=p_header_id
19585: and line_id is null;
19586: --and transaction_phase_code = p_transaction_phase_code;
19587:

Line 19886: FROM OE_SALES_CREDITS

19882: ,x_line_scredit_rec.WH_UPDATE_DATE
19883: ,x_line_scredit_rec.SALES_GROUP_ID
19884: ,x_line_scredit_rec.SALES_GROUP_UPDATED_FLAG
19885: ,x_line_scredit_rec.LOCK_CONTROL
19886: FROM OE_SALES_CREDITS
19887: WHERE
19888: HEADER_ID = p_header_id
19889: AND sales_credit_id = p_sales_credit_id
19890: AND LINE_ID IS NOT NULL;

Line 21052: from oe_sales_credits

21048: --and phase_change_flag = p_transaction_phase_code
21049: and version_number in (p_prior_version,p_current_version,p_next_version)
21050: union
21051: SELECT sales_credit_id,line_id
21052: from oe_sales_credits
21053: where header_id=p_header_id
21054: and line_id is not null;
21055: --and transaction_phase_code = p_transaction_phase_code;
21056: