APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_SALES_TRANSACTIONS_ALL

Line 228: select ozf_Sales_Transactions_all_s.nextval

224: l_common_uom_code VARCHAR2(30);
225: l_common_currency_code VARCHAR2(30);
226:
227: CURSOR transaction_id_csr is
228: select ozf_Sales_Transactions_all_s.nextval
229: from dual;
230: l_sales_transaction_id number;
231:
232: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS

Line 235: FROM ozf_sales_transactions_all trx

231:
232: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS
233: SELECT 1 FROM DUAL WHERE EXISTS
234: ( SELECT 1
235: FROM ozf_sales_transactions_all trx
236: WHERE trx.line_id = p_line_id
237: AND source_code = nvl(p_source_code,'OM')); --fix for bug 6808124
238: --Added for bug 7030415
239: CURSOR c_get_conversion_type( p_org_id IN NUMBER) IS

Line 441: insert into ozf_sales_transactions_all(

437: OPEN transaction_id_csr;
438: FETCH transaction_id_csr INTO l_sales_transaction_id;
439: CLOSE transaction_id_csr;
440:
441: insert into ozf_sales_transactions_all(
442: Sales_Transaction_id,
443: OBJECT_VERSION_NUMBER,
444: LAST_UPDATE_DATE,
445: LAST_UPDATED_BY,

Line 736: FROM ozf_sales_transactions_all stn

732: ) * NVL(stn.primary_quantity,0)),
733: stn.primary_uom_code,
734: NULL,
735: NULL
736: FROM ozf_sales_transactions_all stn
737: WHERE stn.transaction_date <= p_start_date
738: AND stn.source_code IN ('OM', 'MA')
739: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
740: FROM ozf_resale_lines_int_all rli

Line 768: FROM ozf_sales_transactions_all stn

764: ) * NVL(stn.primary_quantity,0)),
765: stn.primary_uom_code,
766: NULL,
767: NULL
768: FROM ozf_sales_transactions_all stn
769: WHERE stn.transaction_date <= p_start_date
770: AND stn.source_code = 'IS'
771: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
772: FROM ozf_resale_lines_int_all rli

Line 817: FROM ozf_sales_transactions_all stn

813: ) * NVL(stn.primary_quantity,0),
814: stn.primary_uom_code,
815: NULL,
816: NULL
817: FROM ozf_sales_transactions_all stn
818: WHERE stn.transaction_date > p_start_date
819: AND stn.transaction_date <= p_end_date
820: AND stn.source_code IN ('OM', 'MA')
821: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id

Line 847: FROM ozf_sales_transactions_all stn

843: ) * NVL(stn.primary_quantity,0),
844: stn.primary_uom_code,
845: NULL,
846: NULL
847: FROM ozf_sales_transactions_all stn
848: WHERE stn.transaction_date > p_start_date
849: AND stn.transaction_date <= p_end_date
850: AND source_code = 'IS'
851: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id

Line 992: from OZF_SALES_TRANSACTIONS_ALL

988: l_msg_count number;
989:
990: CURSOR transaction_info_csr (p_id number) is
991: select primary_quantity, inventory_item_id, sold_from_party_id
992: from OZF_SALES_TRANSACTIONS_ALL
993: where Sales_Transaction_id = p_id;
994: l_primary_quantity number;
995: l_inventory_item_id number;
996: l_party_id number;

Line 1547: UPDATE ozf_sales_transactions_all

1543: END LOOP;
1544: x_purchase_price := l_numerator / l_denominator;
1545:
1546: FORALL i IN 1..l_trans_id_tbl.LAST
1547: UPDATE ozf_sales_transactions_all
1548: SET available_primary_quantity = available_primary_quantity - l_used_quantity_tbl(i)
1549: WHERE sales_transaction_id = l_trans_id_tbl(i);
1550:
1551: IF p_x_purchase_uom_code IS NULL THEN