APPS.PO_HEADERS_SV1 dependencies on PO_HEADERS_ALL

Line 365: FROM PO_HEADERS_ALL poh /*Bug6632095: using base table instead of view */

361:
362: /* Retrieve PO row_id */
363: SELECT poh.rowid
364: INTO X_rowid
365: FROM PO_HEADERS_ALL poh /*Bug6632095: using base table instead of view */
366: WHERE poh.po_header_id = X_po_header_id;
367:
368: --
369: -- If the calling source is HTML then we need not do the validations as we

Line 393: FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */

389: /*po_notifications_sv1.delete_po_notif (x_type_lookup_code,
390: x_po_header_id); */
391: SELECT wf_item_type,wf_item_key
392: INTO x_item_type,x_item_key
393: FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */
394: WHERE po_header_id = x_po_header_id;
395:
396: if ((x_item_type is null) and (x_item_key is null)) then
397: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,

Line 833: SELECT org_id INTO l_org_id FROM po_headers_all WHERE po_header_id = p_doc_id;

829: IF ( p_doc_entity = 'RELEASE' ) THEN
830: SELECT org_id INTO l_org_id FROM po_releases_all WHERE po_release_id = p_doc_id;
831: l_doc_type := g_doc_type_RELEASE;
832: ELSIF(p_doc_entity ='PURCHASE_ORDER' ) THEN
833: SELECT org_id INTO l_org_id FROM po_headers_all WHERE po_header_id = p_doc_id;
834: l_doc_type := g_doc_type_PO;
835: ELSE /*p_doc_entity = 'REQUISITION' */
836: SELECT org_id INTO l_org_id FROM po_requisition_headers_all WHERE requisition_header_id = p_doc_id;
837: l_doc_type := g_doc_type_REQUISITION;