APPS.OE_VERSION_COMP dependencies on OE_SALES_CREDIT_HISTORY

Line 18880: FROM OE_SALES_CREDIT_HISTORY

18876: ,x_header_scredit_rec.WH_UPDATE_DATE
18877: ,x_header_scredit_rec.SALES_GROUP_ID
18878: ,x_header_scredit_rec.SALES_GROUP_UPDATED_FLAG
18879: ,x_header_scredit_rec.LOCK_CONTROL
18880: FROM OE_SALES_CREDIT_HISTORY
18881: WHERE
18882: HEADER_ID = p_header_id
18883: AND sales_credit_id = p_sales_credit_id
18884: AND LINE_ID IS NULL

Line 20101: from oe_sales_credit_history

20097: IS
20098:
20099: CURSOR C_get_sales_credits(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
20100: SELECT distinct sales_credit_id
20101: from oe_sales_credit_history
20102: where header_id = p_header_id
20103: and line_id is null
20104: --Bug 8478088
20105: and version_flag = 'Y'

Line 20117: from oe_sales_credit_history

20113: --and transaction_phase_code = p_transaction_phase_code;
20114:
20115: CURSOR C_get_hist_sales_credits(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
20116: SELECT distinct sales_credit_id
20117: from oe_sales_credit_history
20118: where header_id = p_header_id
20119: and line_id is null
20120: --Bug 8478088
20121: and version_flag = 'Y'

Line 20302: FROM OE_SALES_CREDIT_HISTORY

20298: ,x_line_scredit_rec.WH_UPDATE_DATE
20299: ,x_line_scredit_rec.SALES_GROUP_ID
20300: ,x_line_scredit_rec.SALES_GROUP_UPDATED_FLAG
20301: ,x_line_scredit_rec.LOCK_CONTROL
20302: FROM OE_SALES_CREDIT_HISTORY
20303: WHERE
20304: HEADER_ID = p_header_id
20305: AND sales_credit_id = p_sales_credit_id
20306: AND VERSION_NUMBER=p_version

Line 21576: from oe_sales_credit_history

21572: IS
21573:
21574: CURSOR C_get_sales_credits(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
21575: SELECT distinct sales_credit_id,line_id
21576: from oe_sales_credit_history
21577: where header_id = p_header_id
21578: and line_id is not null
21579: --Bug 8478088
21580: and version_flag = 'Y'

Line 21592: from oe_sales_credit_history

21588: --and transaction_phase_code = p_transaction_phase_code;
21589:
21590: CURSOR C_get_hist_sales_credits(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
21591: SELECT distinct sales_credit_id,line_id
21592: from oe_sales_credit_history
21593: where header_id = p_header_id
21594: and line_id is not null
21595: --Bug 8478088
21596: and version_flag = 'Y'