eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERSION_COMP dependencies on OE_SALES_CREDIT_HISTORY

Line 18355: FROM OE_SALES_CREDIT_HISTORY

18351: ,x_header_scredit_rec.WH_UPDATE_DATE
18352: ,x_header_scredit_rec.SALES_GROUP_ID
18353: ,x_header_scredit_rec.SALES_GROUP_UPDATED_FLAG
18354: ,x_header_scredit_rec.LOCK_CONTROL
18355: FROM OE_SALES_CREDIT_HISTORY
18356: WHERE
18357: HEADER_ID = p_header_id
18358: AND sales_credit_id = p_sales_credit_id
18359: AND LINE_ID IS NULL

Line 19576: from oe_sales_credit_history

19572: IS
19573:
19574: 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
19575: SELECT distinct sales_credit_id
19576: from oe_sales_credit_history
19577: where header_id = p_header_id
19578: and line_id is null
19579: --and phase_change_flag = p_transaction_phase_code
19580: and version_number in (p_prior_version,p_current_version,p_next_version)

Line 19590: from oe_sales_credit_history

19586: --and transaction_phase_code = p_transaction_phase_code;
19587:
19588: 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
19589: SELECT distinct sales_credit_id
19590: from oe_sales_credit_history
19591: where header_id = p_header_id
19592: and line_id is null
19593: --and phase_change_flag = p_transaction_phase_code
19594: and version_number in (p_prior_version,p_current_version,p_next_version);

Line 19773: FROM OE_SALES_CREDIT_HISTORY

19769: ,x_line_scredit_rec.WH_UPDATE_DATE
19770: ,x_line_scredit_rec.SALES_GROUP_ID
19771: ,x_line_scredit_rec.SALES_GROUP_UPDATED_FLAG
19772: ,x_line_scredit_rec.LOCK_CONTROL
19773: FROM OE_SALES_CREDIT_HISTORY
19774: WHERE
19775: HEADER_ID = p_header_id
19776: AND sales_credit_id = p_sales_credit_id
19777: AND VERSION_NUMBER=p_version

Line 21045: from oe_sales_credit_history

21041: IS
21042:
21043: 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
21044: SELECT distinct sales_credit_id,line_id
21045: from oe_sales_credit_history
21046: where header_id = p_header_id
21047: and line_id is not null
21048: --and phase_change_flag = p_transaction_phase_code
21049: and version_number in (p_prior_version,p_current_version,p_next_version)

Line 21059: from oe_sales_credit_history

21055: --and transaction_phase_code = p_transaction_phase_code;
21056:
21057: 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
21058: SELECT distinct sales_credit_id,line_id
21059: from oe_sales_credit_history
21060: where header_id = p_header_id
21061: and line_id is not null
21062: --and phase_change_flag = p_transaction_phase_code
21063: and version_number in (p_prior_version,p_current_version,p_next_version);