DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on OZF_SALES_TRANSACTIONS_ALL

Line 1555: ozf_sales_transactions_all osta

1551: p_inventory_item_id IN NUMBER) IS
1552: SELECT osta.primary_uom_code uom,
1553: 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
1554: FROM
1555: ozf_sales_transactions_all osta
1556: ,hz_parties hp
1557: ,hz_cust_accounts hca
1558: WHERE osta.sold_to_party_id = hp.party_id
1559: AND osta.error_flag='N'