[Home] [Help]
1184: u.instrument_payment_use_id instr_assignment_id,
1185: bank.bank_id bank_party_id,
1186: bank.branch_id branch_party_id,
1187: bank.object_version_number
1188: FROM hz_cust_accounts cust,
1189: hz_party_preferences pp1,
1190: iby_external_payers_all p,
1191: iby_pmt_instr_uses_all u,
1192: iby_ext_bank_accounts bank,
1234: u.instrument_payment_use_id,
1235: NULL bank_party_id,
1236: NULL branch_party_id,
1237: NULL object_version_number
1238: FROM hz_cust_accounts cust,
1239: hz_party_preferences pp1,
1240: iby_external_payers_all p,
1241: iby_pmt_instr_uses_all u,
1242: iby_creditcard c,
1290: bank.bank_id bank_party_id,
1291: bank.branch_id branch_party_id,
1292: bank.object_version_number
1293: FROM
1294: hz_cust_accounts cust,
1295: iby_external_payers_all p,
1296: iby_pmt_instr_uses_all u,
1297: iby_ext_bank_accounts bank,
1298: hz_organization_profiles bapr,
1346: iby_creditcard_issuers_vl i,
1347: iby_external_payers_all p,
1348: iby_pmt_instr_uses_all u,
1349: hz_parties hzcc,
1350: hz_cust_accounts cust,
1351: hz_party_site_uses psu,
1352: hz_party_sites hps,
1353: hz_locations loc,
1354: fnd_territories_vl terr
1699: l_msg_data VARCHAR(2000);
1700:
1701: CURSOR customer_party_cur IS
1702: SELECT party_id
1703: FROM hz_cust_accounts
1704: WHERE cust_account_id = p_customer_id;
1705:
1706: CURSOR object_version_cur(p_party_id IN NUMBER, p_preference_code IN VARCHAR2) IS
1707: SELECT party_preference_id, object_version_number
2221: ct.PAYING_SITE_USE_ID,
2222: ( decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) ) dispute_amt
2223: FROM AR_PAYMENT_SCHEDULES ps,
2224: RA_CUSTOMER_TRX ct,
2225: HZ_CUST_ACCOUNTS acct,
2226: RA_TERMS trm
2227: WHERE ps.CLASS IN ('INV', 'DM', 'CB', 'DEP')
2228: AND ps.customer_trx_id = ct.customer_trx_id
2229: AND acct.cust_account_id = ps.customer_id
2492: 0 PAYING_SITE_USE_ID,
2493: 0 dispute_amt
2494: FROM AR_PAYMENT_SCHEDULES ps,
2495: RA_CUSTOMER_TRX_ALL ct,
2496: HZ_CUST_ACCOUNTS acct,
2497: RA_TERMS trm
2498: WHERE ps.customer_id = p_customer_id
2499: AND ( ps.CLASS = 'CM'
2500: OR
3913:
3914: l_cvv_use VARCHAR2(100);
3915: l_billing_addr_use VARCHAR2(100);
3916: CURSOR party_id_cur IS
3917: SELECT PARTY_ID FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = p_customer_id;
3918:
3919: party_id_rec party_id_cur%ROWTYPE;
3920:
3921: p_site_use_id_srvc_chrg NUMBER;
5167: decode(ps.customer_site_use_id, null, -1,ps.customer_site_use_id) as CUSTOMER_SITE_USE_ID,
5168: (decode( nvl(ps.AMOUNT_DUE_ORIGINAL,0),0,1,(ps.AMOUNT_DUE_ORIGINAL/abs(ps.AMOUNT_DUE_ORIGINAL)) ) *abs(nvl(ps.amount_in_dispute,0)) )
5169: FROM AR_PAYMENT_SCHEDULES ps,
5170: RA_CUSTOMER_TRX_ALL ct,
5171: HZ_CUST_ACCOUNTS acct,
5172: RA_TERMS trm
5173: WHERE ps.payment_schedule_id = p_payment_schedule_id
5174: AND ps.CLASS IN ('INV', 'DM', 'GUAR', 'CB', 'DEP', 'CM', 'PMT' ) -- CCA - hikumar
5175: AND ps.customer_trx_id = ct.customer_trx_id(+)