DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;

65: l_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;
72: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;
73:

Line 70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;

66: lp_rct_line_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;
72: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;
73:
74: l_khr_id okc_k_headers_b.id%type;

Line 71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;

67: l_bank_line_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;
72: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;
73:
74: l_khr_id okc_k_headers_b.id%type;
75:

Line 72: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;

68:
69: l_line_cust_bank_acct_id OKL_TRX_AR_INVOICES_V.customer_bank_account_id%TYPE;
70: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
71: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;
72: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;
73:
74: l_khr_id okc_k_headers_b.id%type;
75:
76: CURSOR get_chr_id (p_kle_id NUMBER) IS

Line 2000: OKL_TRX_AR_INVOICES_V TAI,

1996: , TLD.INVOICE_FORMAT_LINE_TYPE INVOICE_LINE_TYPE -- Bug 7045347
1997: , TIL.ID TIL_ID -- Bug# 12617408
1998: FROM OKL_TXD_AR_LN_DTLS_B TLD,
1999: OKL_TXL_AR_INV_LNS_V TIL,
2000: OKL_TRX_AR_INVOICES_V TAI,
2001: OKC_K_HEADERS_ALL_B KHR,
2002: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2003: -- OKC_K_LINES_V KLE,
2004: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |