DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_HEADERS

Line 1324: FROM ozf_resale_headers_all a

1320: , p_cust_id IN NUMBER
1321: , p_date IN DATE
1322: ) IS
1323: SELECT a.resale_header_id
1324: FROM ozf_resale_headers_all a
1325: , ozf_resale_lines_int_all b
1326: , ozf_resale_lines_all c
1327: WHERE b.resale_batch_id = p_id
1328: AND b.order_number = p_order_number

Line 1832: FROM ozf_resale_headers_all a

1828: , a.header_attribute12
1829: , a.header_attribute13
1830: , a.header_attribute14
1831: , a.header_attribute15
1832: FROM ozf_resale_headers_all a
1833: , ozf_resale_lines_all b
1834: , ozf_resale_batch_line_maps_all c
1835: WHERE a.resale_header_id = b.resale_header_id
1836: AND b.resale_line_id = c.resale_line_id

Line 1844: FROM ozf_resale_headers

1840: l_header_id_tbl header_id_tbl_type;
1841:
1842: CURSOR order_header_csr(p_header_id in NUMBER) IS
1843: SELECT *
1844: FROM ozf_resale_headers
1845: WHERE resale_header_id = p_header_id;
1846:
1847: l_header_rec order_header_csr%rowtype;
1848: