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 15060: FROM hz_cust_accounts hca,

15056:
15057: IF p_account_id is not null THEN
15058: SELECT hp.party_name
15059: INTO l_customer_name
15060: FROM hz_cust_accounts hca,
15061: hz_parties hp
15062: WHERE hca.cust_account_id = p_account_id
15063: AND hp.party_id = hca.party_id;
15064: ELSE

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

15382: oel.sold_to_org_id owner_acct,
15383: oel.ordered_quantity ordered_qty,
15384: oel.order_quantity_uom ordered_uom,
15385: hca.party_id party_id
15386: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15387: WHERE cte.processed_flag in ('E', 'R')
15388: AND cte.transaction_type_id = 53
15389: AND cte.inv_material_transaction_id = mmt.transaction_id
15390: AND msi.inventory_item_id = mmt.inventory_item_id