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.OKS_OC_INT_KTO_PVT dependencies on OKC_K_LINES_B

Line 48: FROM okc_k_lines_b

44: -- Cursor for contract line information
45: --
46: CURSOR c_cle(p_cle_id NUMBER) IS SELECT
47: object_version_number
48: FROM okc_k_lines_b
49: WHERE id = p_cle_id;
50: -- 4915691 --
51:
52:

Line 155: CLE_ID okc_k_lines_b.cle_id%TYPE

151:
152:
153: TYPE kl_attr_rec_type IS RECORD
154: (
155: CLE_ID okc_k_lines_b.cle_id%TYPE
156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE
157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE
158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE
159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE

Line 156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE

152:
153: TYPE kl_attr_rec_type IS RECORD
154: (
155: CLE_ID okc_k_lines_b.cle_id%TYPE
156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE
157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE
158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE
159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
160: ,PRICE_LIST_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE

Line 157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE

153: TYPE kl_attr_rec_type IS RECORD
154: (
155: CLE_ID okc_k_lines_b.cle_id%TYPE
156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE
157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE
158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE
159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
160: ,PRICE_LIST_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
161: );

Line 158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE

154: (
155: CLE_ID okc_k_lines_b.cle_id%TYPE
156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE
157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE
158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE
159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
160: ,PRICE_LIST_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
161: );
162:

Line 159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE

155: CLE_ID okc_k_lines_b.cle_id%TYPE
156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE
157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE
158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE
159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
160: ,PRICE_LIST_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
161: );
162:
163: TYPE kl_attr_tbl_type IS TABLE OF kl_attr_rec_type INDEX BY BINARY_INTEGER;

Line 160: ,PRICE_LIST_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE

156: ,CUST_ACCT_ID okc_k_lines_b.CUST_ACCT_ID%TYPE
157: ,BILL_TO_SITE_USE_ID okc_k_lines_b.BILL_TO_SITE_USE_ID%TYPE
158: ,INV_RULE_ID okc_k_lines_b.INV_RULE_ID%TYPE
159: ,SHIP_TO_SITE_USE_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
160: ,PRICE_LIST_ID okc_k_lines_b.SHIP_TO_SITE_USE_ID%TYPE
161: );
162:
163: TYPE kl_attr_tbl_type IS TABLE OF kl_attr_rec_type INDEX BY BINARY_INTEGER;
164: l_kl_attr_tab kl_attr_tbl_type;

Line 169: cle_id okc_k_lines_b.id%TYPE,

165:
166: TYPE bto_sto_rec_typ IS RECORD
167: (
168: chr_id okc_k_headers_b.id%TYPE,
169: cle_id okc_k_lines_b.id%TYPE,
170: party_site_id okx_cust_site_uses_v.party_site_id%TYPE,
171: cust_acct_id okx_cust_site_uses_v.cust_account_id%TYPE,
172: party_id okx_cust_site_uses_v.party_id%TYPE,
173: address1 HZ_LOCATIONS.address1%TYPE,

Line 331: FROM OKC_K_LINES_B

327: ,BILL_TO_SITE_USE_ID
328: ,INV_RULE_ID
329: ,SHIP_TO_SITE_USE_ID
330: ,PRICE_LIST_ID
331: FROM OKC_K_LINES_B
332: WHERE dnz_chr_id = p_chr_id
333: AND id = p_cle_id;
334:
335: -- get party site id for a customer account site id

Line 599: ,p_cle_id IN okc_k_lines_b.id%TYPE

595: -- Out Parameters: x_return_status standard return status
596: -----------------------------------------------------------------------------
597:
598: PROCEDURE build_k_structures (p_chr_id IN okc_k_headers_b.ID%TYPE
599: ,p_cle_id IN okc_k_lines_b.id%TYPE
600: ,p_k_header_rec IN c_k_header%ROWTYPE
601: ,x_return_status OUT NOCOPY VARCHAR2
602: ) IS
603:

Line 1376: okc_k_lines_b line,

1372: sub.start_date,
1373: sub.end_date,
1374: sub.om_interface_date
1375: from oks_subscr_elements sub ,
1376: okc_k_lines_b line,
1377: okc_statuses_b sts
1378: where sub.dnz_chr_id = nvl(p_contract_id ,sub.dnz_chr_id)
1379: and sub.dnz_chr_id between nvl(nvl(p_contract_id,p_contract_hdr_id_lo),sub.dnz_chr_id)
1380: and nvl(nvl(p_contract_id,p_contract_hdr_id_hi),sub.dnz_chr_id)