DBA Data[Home] [Help]

APPS.OE_VERSION_BLANKET_COMP dependencies on OE_BLANKET_LINES_HIST

Line 4216: FROM OE_BLANKET_LINES_HIST

4212: ,x_line_rec.RETURNED_AMOUNT
4213: ,x_line_rec.TRANSACTION_PHASE_CODE
4214: ,x_line_rec.source_document_version_number
4215: ,x_line_rec.modifier_list_line_id
4216: FROM OE_BLANKET_LINES_HIST
4217: WHERE
4218: line_id = p_line_id
4219: AND header_id = p_header_id
4220: AND version_number = p_version

Line 7701: from oe_blanket_lines_hist

7697: l_line_id NUMBER;
7698:
7699: CURSOR C_get_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
7700: SELECT distinct line_id,line_number
7701: from oe_blanket_lines_hist
7702: where header_id = p_header_id
7703: --and transaction_phase_code = p_transaction_phase_code
7704: and version_number in (p_prior_version,p_current_version,p_next_version)
7705: union

Line 7713: from oe_blanket_lines_hist

7709: --and transaction_phase_code = p_transaction_phase_code;
7710:
7711: CURSOR C_get_hist_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
7712: SELECT distinct line_id,line_number
7713: from oe_blanket_lines_hist
7714: where header_id = p_header_id
7715: -- and transaction_phase_code = p_transaction_phase_code
7716: and version_number in (p_prior_version,p_current_version,p_next_version);
7717: