APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_SALES_TRANSACTIONS_ALL_S

Line 246: select ozf_Sales_Transactions_all_s.nextval

242: l_common_uom_code VARCHAR2(30);
243: l_common_currency_code VARCHAR2(30);
244:
245: CURSOR transaction_id_csr is
246: select ozf_Sales_Transactions_all_s.nextval
247: from dual;
248: l_sales_transaction_id number;
249:
250: CURSOR sales_transation_csr(p_line_id NUMBER,p_source_code VARCHAR2) IS

Line 754: FROM ozf_sales_transactions_all stn

750: ) * NVL(stn.primary_quantity,0)),
751: stn.primary_uom_code,
752: NULL,
753: NULL
754: FROM ozf_sales_transactions_all stn
755: WHERE stn.transaction_date <= p_start_date
756: AND stn.source_code IN ('OM', 'MA')
757: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
758: FROM ozf_resale_lines_int_all rli

Line 786: FROM ozf_sales_transactions_all stn

782: ) * NVL(stn.primary_quantity,0)),
783: stn.primary_uom_code,
784: NULL,
785: NULL
786: FROM ozf_sales_transactions_all stn
787: WHERE stn.transaction_date <= p_start_date
788: AND stn.source_code = 'IS'
789: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id
790: FROM ozf_resale_lines_int_all rli

Line 835: FROM ozf_sales_transactions_all stn

831: ) * NVL(stn.primary_quantity,0),
832: stn.primary_uom_code,
833: NULL,
834: NULL
835: FROM ozf_sales_transactions_all stn
836: WHERE stn.transaction_date > p_start_date
837: AND stn.transaction_date <= p_end_date
838: AND stn.source_code IN ('OM', 'MA')
839: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id

Line 865: FROM ozf_sales_transactions_all stn

861: ) * NVL(stn.primary_quantity,0),
862: stn.primary_uom_code,
863: NULL,
864: NULL
865: FROM ozf_sales_transactions_all stn
866: WHERE stn.transaction_date > p_start_date
867: AND stn.transaction_date <= p_end_date
868: AND source_code = 'IS'
869: AND stn.inventory_item_id IN ( SELECT rli.inventory_item_id