DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_HEADERS

Line 1709: FROM ozf_resale_headers_all a

1705: , p_cust_id IN NUMBER
1706: , p_date IN DATE
1707: ) IS
1708: SELECT a.resale_header_id
1709: FROM ozf_resale_headers_all a
1710: , ozf_resale_lines_int_all b
1711: , ozf_resale_lines_all c
1712: WHERE b.resale_batch_id = p_id
1713: AND b.order_number = p_order_number

Line 2354: FROM ozf_resale_headers_all a

2350: , a.header_attribute12
2351: , a.header_attribute13
2352: , a.header_attribute14
2353: , a.header_attribute15
2354: FROM ozf_resale_headers_all a
2355: , ozf_resale_lines_all b
2356: , ozf_resale_batch_line_maps_all c
2357: WHERE a.resale_header_id = b.resale_header_id
2358: AND b.resale_line_id = c.resale_line_id

Line 2366: FROM ozf_resale_headers

2362: l_header_id_tbl header_id_tbl_type;
2363:
2364: CURSOR order_header_csr(p_header_id in NUMBER) IS
2365: SELECT *
2366: FROM ozf_resale_headers
2367: WHERE resale_header_id = p_header_id;
2368:
2369: l_header_rec order_header_csr%rowtype;
2370: