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

Line 1343: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

1339: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1340: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1341: AND CMEE.ENTRY_ID = p_entry_id
1342: AND INSTANCE_ID IS NULL)
1343: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'
1344: AND RELATIONSHIP_TYPE_CODE = 'OWNER'
1345: AND ROWNUM = 1;
1346:
1347: SELECT 'x' INTO l_old_owner

Line 1353: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'

1349: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1350: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1351: AND CMEE.ENTRY_ID = p_entry_id
1352: AND INSTANCE_ID IS NOT NULL)
1353: AND PARTY_SOURCE_TABLE = 'HZ_PARTIES'
1354: AND RELATIONSHIP_TYPE_CODE = 'OWNER'
1355: AND ROWNUM = 1;
1356:
1357: debug('l_old_owner type - ' || l_old_owner);

Line 1367: as the owner type is not HZ_PARTIES');

1363:
1364: EXCEPTION
1365: WHEN OTHERS THEN
1366: debug('The Batch doesn not qualify for system mass update
1367: as the owner type is not HZ_PARTIES');
1368: l_perform_system_mu := 'N';
1369: END;
1370:
1371: -- The processing of systems must proceed only if the owner type is HZ_PARTIES

Line 1371: -- The processing of systems must proceed only if the owner type is HZ_PARTIES

1367: as the owner type is not HZ_PARTIES');
1368: l_perform_system_mu := 'N';
1369: END;
1370:
1371: -- The processing of systems must proceed only if the owner type is HZ_PARTIES
1372: IF l_batch_type in ('XFER') AND l_system_cascade = 'Y' AND l_perform_system_mu = 'Y' THEN
1373: IF n_instance_tbl.count > 0 THEN
1374:
1375: -- Call the PROCESS_SYSTEM_MASS_UPDATE to

Line 2257: hz_parties party,

2253: party.party_number PartyNumber
2254: FROM csi_t_txn_line_details tld,
2255: csi_t_party_details tp,
2256: csi_t_party_accounts ta,
2257: hz_parties party,
2258: hz_cust_accounts account
2259: WHERE tld.txn_line_detail_id = tp.txn_line_detail_id
2260: AND tld.transaction_line_id = p_transaction_line_id
2261: AND tld.INSTANCE_ID IS NULL

Line 2266: AND tp.party_source_table = 'HZ_PARTIES';

2262: AND tp.txn_party_detail_id = ta.txn_party_detail_id
2263: AND tp.party_source_id = party.party_id
2264: AND ta.account_id = account.cust_account_id
2265: AND tp.relationship_type_code = 'OWNER'
2266: AND tp.party_source_table = 'HZ_PARTIES';
2267: -- Bug 7350165
2268: -- CURSOR mu_customer_id_csr (p_party_id IN NUMBER, p_account_number IN NUMBER) IS
2269: -- SELECT CUST_ACCOUNT_ID CUSTOMER_ID
2270: -- FROM HZ_CUST_ACCOUNTS