APPS.CSI_DIAGNOSTICS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 8822: FROM hz_cust_accounts

8818: AND oeh.header_id = oel.header_id;
8819:
8820: SELECT party_id
8821: INTO l_owner_party_id
8822: FROM hz_cust_accounts
8823: WHERE cust_account_id = l_owner_account_id;
8824:
8825: END IF;
8826:

Line 15071: FROM hz_cust_accounts hca,

15067:
15068: IF p_account_id is not null THEN
15069: SELECT hp.party_name
15070: INTO l_customer_name
15071: FROM hz_cust_accounts hca,
15072: hz_parties hp
15073: WHERE hca.cust_account_id = p_account_id
15074: AND hp.party_id = hca.party_id;
15075: ELSE

Line 15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca

15393: oel.sold_to_org_id owner_acct,
15394: oel.ordered_quantity ordered_qty,
15395: oel.order_quantity_uom ordered_uom,
15396: hca.party_id party_id
15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15398: WHERE cte.processed_flag in ('E', 'R')
15399: AND cte.transaction_type_id = 53
15400: AND cte.inv_material_transaction_id = mmt.transaction_id
15401: AND msi.inventory_item_id = mmt.inventory_item_id