APPS.FLM_EKB_SUMMARY_UTIL dependencies on PO_HEADERS_ALL

Line 16: po_headers_all h

12: IF p_doc_type = 1 THEN /*PO*/
13: SELECT h.segment1
14: INTO l_doc_num
15: FROM po_distributions_all d,
16: po_headers_all h
17: WHERE d.po_distribution_id = p_doc_detail_id
18: AND h.po_header_id = d.po_header_id;
19:
20: ELSIF p_doc_type = 2 THEN /*Blanket Release*/

Line 24: po_headers_all h

20: ELSIF p_doc_type = 2 THEN /*Blanket Release*/
21: SELECT h.segment1
22: INTO l_doc_num
23: FROM po_distributions_all d,
24: po_headers_all h
25: WHERE d.po_distribution_id = p_doc_detail_id
26: AND h.po_header_id = d.po_header_id;
27:
28: ELSIF p_doc_type = 3 THEN /*Internal Req*/

Line 66: po_headers_all h

62: IF p_doc_type = 1 THEN /*PO*/
63: SELECT h.creation_date
64: INTO l_doc_creation_date
65: FROM po_distributions_all d,
66: po_headers_all h
67: WHERE d.po_distribution_id = p_doc_detail_id
68: AND h.po_header_id = d.po_header_id;
69:
70: ELSIF p_doc_type = 2 THEN /*Blanket Release*/

Line 74: po_headers_all h

70: ELSIF p_doc_type = 2 THEN /*Blanket Release*/
71: SELECT h.creation_date
72: INTO l_doc_creation_date
73: FROM po_distributions_all d,
74: po_headers_all h
75: WHERE d.po_distribution_id = p_doc_detail_id
76: AND h.po_header_id = d.po_header_id;
77:
78: ELSIF p_doc_type = 3 THEN /*Internal Req*/