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.OKL_ARINTF_PVT dependencies on HZ_PARTIES

Line 1041: l_party_id hz_parties.party_id%type;

1037: l_entity_id NUMBER;
1038: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
1039: l_true VARCHAR2(1) := 'T';
1040: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
1041: l_party_id hz_parties.party_id%type;
1042:
1043: BEGIN
1044: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1045: x_receipt_method_id := p_receipt_method_id;

Line 1530: l_party_id hz_parties.party_id%type;

1526: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
1527: -- This values based on global variables from FND_API G_TRUE and G_FALSE;
1528: l_true VARCHAR2(1) := 'T';
1529: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
1530: l_party_id hz_parties.party_id%type;
1531:
1532: CURSOR instr_type_csr(p_instr_use_id NUMBER)
1533: IS
1534: SELECT ipiu.payment_function

Line 2057: hz_parties hp

2053: ,COUNT(tai.id) cust_rec_cnt
2054: FROM okl_trx_ar_invoices_b tai,
2055: hz_cust_accounts hca,
2056: okc_k_headers_b khr,
2057: hz_parties hp
2058: WHERE tai.ixx_id = khr.cust_acct_id
2059: AND khr.cust_acct_id = hca.cust_account_id
2060: AND hca.party_id = hp.party_id
2061: AND tai.khr_id = khr.id

Line 2107: hz_parties hp

2103: FROM okl_trx_ar_invoices_b tai,
2104: hz_cust_accounts hca,
2105: okc_k_headers_b khr,
2106: ap_suppliers ap,
2107: hz_parties hp
2108: WHERE tai.ixx_id = hca.cust_account_id
2109: AND khr.cust_acct_id <> tai.ixx_id
2110: AND tai.khr_id = khr.id
2111: AND ap.party_id = hp.party_id