DBA Data[Home] [Help]

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_SALES_TRANSACTIONS

Line 155: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type

151: ,p_commit IN VARCHAR2
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2
155: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type
156: ,p_qp_list_header_id IN NUMBER
157: ,p_offer_id IN NUMBER
158: ,p_indirect_flag IN VARCHAR2
159: ,p_sign IN NUMBER)

Line 752: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type

748: ,p_commit IN VARCHAR2
749: ,x_return_status OUT NOCOPY VARCHAR2
750: ,x_msg_count OUT NOCOPY NUMBER
751: ,x_msg_data OUT NOCOPY VARCHAR2
752: ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type
753: ,p_qp_list_header_id IN NUMBER
754: ,x_apply_discount OUT NOCOPY VARCHAR2
755: )
756: IS

Line 1531: FROM ozf_sales_transactions

1527: WHERE line_id = p_order_line_id;
1528:
1529: CURSOR c_resale_detail IS
1530: SELECT quantity, amount, sold_from_cust_account_id, sold_to_cust_account_id, ship_to_site_use_id, bill_to_site_use_id, transaction_date
1531: FROM ozf_sales_transactions
1532: WHERE line_id = p_order_line_id;
1533:
1534: CURSOR c_interface_detail IS
1535: SELECT quantity, quantity * selling_price, sold_from_cust_account_id, bill_to_cust_account_id, ship_to_site_use_id, bill_to_site_use_id, date_ordered