APPS.FLM_EKB_SUMMARY_UTIL dependencies on PO_DISTRIBUTIONS_ALL

Line 15: FROM po_distributions_all d,

11: Begin
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:

Line 23: FROM po_distributions_all d,

19:
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:

Line 65: FROM po_distributions_all d,

61: Begin
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:

Line 73: FROM po_distributions_all d,

69:
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: