DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on HZ_PARTIES

Line 1522: ,hz_parties hp

1518: SELECT osta.primary_uom_code uom,
1519: sum(decode(osta.transfer_type, 'IN', nvl(osta.common_quantity,0), 0)) - sum(decode(osta.transfer_type, 'OUT', nvl(osta.common_quantity,0), 0)) as end_inventory
1520: FROM
1521: ozf_sales_transactions_all osta
1522: ,hz_parties hp
1523: ,hz_cust_accounts hca
1524: WHERE osta.sold_to_party_id = hp.party_id
1525: AND osta.error_flag='N'
1526: AND osta.sold_to_party_id =hp.party_id