APPS.PO_DOC_NUMBERING_PKG dependencies on PO_REQ_HEADERS_EXT_B

Line 337: FROM po_req_headers_ext_b

333: --Now get the document number generated
334: IF p_caller = 'REQ' THEN
335:
336: SELECT c_ext_attr40 INTO x_doc_number
337: FROM po_req_headers_ext_b
338: WHERE requisition_header_id = p_doc_header_id
339: AND attr_group_id = l_attrb_grp_id;
340:
341: ELSIF p_caller = 'PO' OR p_caller = 'PO_MOD' THEN

Line 597: ' PO_REQ_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||

593: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
594: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
595: ' minus '||
596: ' SELECT distinct plc.lookup_code FROM '||
597: ' PO_REQ_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
598: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
599: ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
600: ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
601: ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||

Line 622: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

618: AND language = userenv ('LANG')
619: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
620:
621: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
622: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
623: ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
624: ' AND prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
625: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
626: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||

Line 771: from po_req_headers_ext_b

767: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
768:
769: ELSE
770: select count(*) INTO l_cnt
771: from po_req_headers_ext_b
772: WHERE C_EXT_ATTR40 = x_document_number
773: AND requisition_header_id <> x_requisition_header_id;
774:
775: IF l_cnt > 0 THEN

Line 875: ' PO_REQ_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||

871: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
872: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
873: ' minus '||
874: ' SELECT distinct plc.lookup_code FROM '||
875: ' PO_REQ_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
876: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
877: ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
878: ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
879: ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||

Line 902: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

898: AND language = userenv ('LANG')
899: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
900:
901: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
902: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
903: ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
904: ' AND prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
905: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
906: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||