APPS.M4R_3B2IN_PKG dependencies on PO_HEADERS_ALL

Line 54: po_headers_all poh,

50: if ((p_release_num is null) OR (p_release_num = 0)) then
51: SELECT min(poh.ORG_ID)
52: INTO p_org_id
53: FROM
54: po_headers_all poh,
55: po_lines_all pol,
56: po_line_locations_all pll,
57: Mtl_system_items_kfv msi
58: WHERE

Line 72: po_headers_all poh,

68: else
69: SELECT min(poh.ORG_ID)
70: INTO p_org_id
71: FROM
72: po_headers_all poh,
73: po_lines_all pol,
74: po_line_locations_all pll,
75: po_releases_all prl,
76: Mtl_system_items_kfv msi

Line 95: from po_headers_all

91: cln_debug_pub.Add(' p_org_id:' || p_org_id, 1);
92: END IF;
93: select min(po_header_id)
94: into p_po_header_id
95: from po_headers_all
96: where segment1 = p_po_number
97: and org_id = p_org_id;
98: IF (l_Debug_Level <= 1) THEN
99: cln_debug_pub.Add(' p_po_header_id' || p_po_header_id, 1);

Line 107: po_headers_all poh,

103: min(pll.ship_to_organization_id)
104: into
105: p_ship_to_org_id
106: from
107: po_headers_all poh,
108: po_lines_all pol,
109: po_line_locations_all pll
110: where
111: poh.po_header_id = p_po_header_id and

Line 122: po_headers_all poh,

118: min(pll.ship_to_organization_id)
119: into
120: p_ship_to_org_id
121: from
122: po_headers_all poh,
123: po_lines_all pol,
124: po_line_locations_all pll,
125: po_releases_all prl
126: where

Line 143: po_headers_all poh

139: select
140: poh.vendor_site_id,poh.vendor_id
141: into p_vendor_site_id, p_vendor_id
142: from
143: po_headers_all poh
144: where
145: poh.po_header_id = p_po_header_id and
146: poh.segment1 =p_po_number;
147: IF (l_Debug_Level <= 1) THEN

Line 231: select segment1 into x_po_num from po_headers_all where po_header_id=p_po_header_id;

227: p_error_code := 0;
228: /* save the inbound value for ship_to_location_id for matching */
229: x_ship_to_location_id := p_ship_to_location_id;
230:
231: select segment1 into x_po_num from po_headers_all where po_header_id=p_po_header_id;
232:
233: if ((p_release_num is null) OR (p_release_num = 0)) then
234:
235: SELECT

Line 254: po_headers_all poh,

250: p_po_line_id,
251: p_line_location_id,
252: p_ship_to_org_id
253: FROM
254: po_headers_all poh,
255: po_lines_all pol,
256: po_line_locations_all pll,
257: MTL_SYSTEM_ITEMS_KFV MSI
258: WHERE

Line 288: po_headers_all poh,

284: p_line_location_id,
285: p_ship_to_org_id,
286: p_po_release_id
287: FROM
288: po_headers_all poh,
289: po_lines_all pol,
290: po_line_locations_all pll,
291: po_releases_all prl,
292: MTL_SYSTEM_ITEMS_KFV MSI