DBA Data[Home] [Help]

APPS.OKC_PHI_PVT dependencies on OKC_K_HEADERS_V

Line 54: ,p_chr_id IN OKC_K_HEADERS_V.id%TYPE

50: */
51:
52: PROCEDURE process_price_hold(p_api_version IN NUMBER
53: ,p_init_msg_list IN VARCHAR2
54: ,p_chr_id IN OKC_K_HEADERS_V.id%TYPE
55: ,p_operation_code IN VARCHAR2
56: ,p_termination_date IN DATE
57: ,p_unconditional_call IN varchar2
58: ,x_return_status OUT NOCOPY VARCHAR2

Line 75: FROM okc_k_headers_V chr

71: chr.start_date start_date,
72: chr.end_date end_date,
73: chr.authoring_org_id authoring_org_id,
74: chr.inv_organization_id inv_organization_id
75: FROM okc_k_headers_V chr
76: WHERE chr.id=b_chr_id
77: and chr.application_id in (510,871)
78: AND chr.buy_or_sell='S'
79: AND chr.issue_or_receive='I'

Line 1163: FROM okc_k_headers_V chr,

1159: ) IS
1160:
1161: Cursor c_k_header(b_cle_id Number) IS
1162: SELECT chr.id ID
1163: FROM okc_k_headers_V chr,
1164: okc_k_lines_V cle
1165: WHERE cle.id=b_cle_id
1166: AND chr.id=cle.dnz_chr_id
1167: AND chr.application_id in (510,871)