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_CUST_SITE_USES_ALL

Line 839: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

835: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
836: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
837: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
838: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
839: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
840: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
841: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
842: SELECT instrument_payment_use_id, fpc.payment_channel_code
843: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc

Line 860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

856: p_bank_id iby_pmt_instr_uses_all.instrument_id%TYPE,
857: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
858: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
859: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
860: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
861: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
862: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
863: ) IS
864: SELECT instr_assignment_id,

Line 884: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

880: l_payment_channel_code iby_fndcpt_pmt_chnnls_vl.payment_channel_code%type;
881:
882: CURSOR cust_instr_payment_use_id_csr (
883: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
884: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
885: p_currency_code okl_k_headers_full_v.currency_code%type
886: ) IS
887: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),
888: '1' || to_char(instr_assignment_id))), 2)

Line 1008: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;

1004:
1005: chr_dtls_rec chr_dtls_csr%ROWTYPE;
1006: instr_type_rec instr_type_csr%ROWTYPE;
1007: l_vendor_bank_rec c_vendor_bank_csr%ROWTYPE;
1008: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
1009: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
1010: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1011: l_payment_method_id okc_rules_b.object1_id1%type;
1012: l_receipt_method_id RA_CUST_RECEIPT_METHODS.RECEIPT_METHOD_ID%TYPE;

Line 1581: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;

1577: Select site_use_id
1578: from HZ_CUST_SITE_USES
1579: where cust_acct_site_id=cp_customer_address_id
1580: and site_use_code = 'BILL_TO';
1581: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
1582: -- gboomina modified for bug 6832065 - End
1583:
1584: CURSOR c_get_account_details (cp_customer_address_id NUMBER)IS
1585: select a.cust_account_id, a.party_id

Line 1600: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

1596: /* CURSOR instrument_payment_use_id_csr(
1597: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1598: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1599: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1600: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1601: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
1602: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
1603: SELECT instrument_payment_use_id,fpc.payment_channel_code
1604: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay,iby_fndcpt_pmt_chnnls_vl fpc

Line 1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

1616: CURSOR instrument_payment_use_id_csr(
1617: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
1618: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
1619: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1620: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1621: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE
1622: -- p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE
1623: ) IS
1624: SELECT instr_assignment_id,

Line 1645: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

1641: payment_channel_code iby_fndcpt_pmt_chnnls_vl.payment_channel_code%type;
1642:
1643: CURSOR cust_instr_payment_use_id_csr (
1644: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
1645: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
1646: p_currency_code okl_k_headers_full_v.currency_code%type
1647: ) IS
1648: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),
1649: '1' || to_char(instr_assignment_id))), 2)

Line 2334: hz_cust_site_uses_all b,

2330:
2331: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
2332: SELECT a.CUST_ACCT_SITE_ID
2333: FROM hz_cust_acct_sites_all a,
2334: hz_cust_site_uses_all b,
2335: hz_party_sites c
2336: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
2337: b.site_use_code = 'SHIP_TO' AND
2338: a.party_site_id = c.party_site_id AND

Line 2492: hz_cust_site_uses_all hsu

2488: SELECT hsu.cust_acct_site_id
2489: FROM okl_txl_ar_inv_lns_b til,
2490: oe_order_lines_all oli,
2491: oe_order_headers_all ohe,
2492: hz_cust_site_uses_all hsu
2493: WHERE til.id = p_til_id
2494: AND oli.line_id = til.isl_id
2495: AND ohe.header_id = oli.header_id
2496: AND hsu.site_use_id = NVL(oli.ship_to_org_id, ohe.ship_to_org_id);