DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on PO_HEADERS_ALL

Line 100: FROM po_distributions_all d, po_headers_all h

96: BEGIN
97: IF v_document_type_id = 1 THEN /* PO */
98: SELECT h.segment1
99: INTO v_document_header
100: FROM po_distributions_all d, po_headers_all h
101: WHERE d.po_distribution_id = v_document_detail_id
102: AND h.po_header_id = d.po_header_id;
103: ELSIF v_document_type_id = 2 THEN /* Blanket Release */
104: SELECT h.segment1

Line 106: FROM po_distributions_all d, po_headers_all h

102: AND h.po_header_id = d.po_header_id;
103: ELSIF v_document_type_id = 2 THEN /* Blanket Release */
104: SELECT h.segment1
105: INTO v_document_header
106: FROM po_distributions_all d, po_headers_all h
107: WHERE d.po_distribution_id = v_document_detail_id
108: AND h.po_header_id = d.po_header_id;
109: ELSIF v_document_type_id = 3 THEN /* Internal Req */
110: SELECT h.segment1