APPS.OZF_CUST_FACTS_PVT dependencies on DUAL

Line 225: FROM dual

221: AND eni.parent_id = p_item_id
222: AND 'PRICING_ATTRIBUTE2' = p_item_type
223: UNION ALL
224: SELECT p_item_id inventory_item_id
225: FROM dual
226: WHERE 'PRICING_ATTRIBUTE1' = p_item_type
227: UNION ALL
228: SELECT p_item_id inventory_item_id
229: FROM dual

Line 229: FROM dual

225: FROM dual
226: WHERE 'PRICING_ATTRIBUTE1' = p_item_type
227: UNION ALL
228: SELECT p_item_id inventory_item_id
229: FROM dual
230: WHERE 'OTHERS' = p_item_type;
231:
232: -- for R12, get the last year sales for Month, Quarter and Year as of the report_date
233: CURSOR ly_sales_csr (p_report_date DATE,

Line 586: FROM dual

582: AND eni.parent_id = p_item_id
583: AND 'PRICING_ATTRIBUTE2' = p_item_type
584: UNION ALL
585: SELECT p_item_id inventory_item_id
586: FROM dual
587: WHERE 'PRICING_ATTRIBUTE1' = p_item_type
588: UNION ALL
589: SELECT p_item_id inventory_item_id
590: FROM dual

Line 590: FROM dual

586: FROM dual
587: WHERE 'PRICING_ATTRIBUTE1' = p_item_type
588: UNION ALL
589: SELECT p_item_id inventory_item_id
590: FROM dual
591: WHERE 'OTHERS' = p_item_type;
592:
593: CURSOR daily_facts_csr IS
594: SELECT cust_daily_fact_id,

Line 1823: FROM dual

1819: AND eni.parent_id = p_item_id
1820: AND 'PRICING_ATTRIBUTE2' = p_item_type
1821: UNION ALL
1822: SELECT p_item_id inventory_item_id
1823: FROM dual
1824: WHERE 'PRICING_ATTRIBUTE1' = p_item_type
1825: UNION ALL
1826: SELECT p_item_id inventory_item_id
1827: FROM dual

Line 1827: FROM dual

1823: FROM dual
1824: WHERE 'PRICING_ATTRIBUTE1' = p_item_type
1825: UNION ALL
1826: SELECT p_item_id inventory_item_id
1827: FROM dual
1828: WHERE 'OTHERS' = p_item_type;
1829:
1830: CURSOR acct_time_sales_csr ( p_account_allocation_id NUMBER,
1831: p_time_id NUMBER ) IS

Line 2694: FROM dual

2690: ozf_cust_facts_pvt.get_cust_target( outer.party_id, NULL, NULL,
2691: 'YEAR_QUOTA', 0,
2692: outer.report_date,outer.resource_id
2693: ) YEAR_QUOTA
2694: FROM dual
2695: )
2696: WHERE outer.fact_row_for = 'PARTY'
2697: AND outer.report_date = p_report_date;
2698:

Line 2717: FROM dual

2713: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2714: NULL, 'YEAR_QUOTA', 0,
2715: outer.report_date,outer.resource_id
2716: ) YEAR_QUOTA
2717: FROM dual
2718: )
2719: WHERE outer.fact_row_for = 'BILL_TO'
2720: AND outer.report_date = p_report_date;
2721:

Line 2740: FROM dual

2736: ozf_cust_facts_pvt.get_cust_target( outer.party_id, outer.bill_to_site_use_id,
2737: outer.ship_to_site_use_id, 'YEAR_QUOTA', 0,
2738: outer.report_date,outer.resource_id
2739: ) YEAR_QUOTA
2740: FROM dual
2741: )
2742: WHERE outer.fact_row_for = 'SHIP_TO'
2743: AND outer.report_date = p_report_date;
2744: