eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_PRINTING_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 35: from pon_auc_doctypes d , pon_auction_headers_all pah

31: l_message_suffix varchar2(2);
32: BEGIN
33:
34: select d.MESSAGE_SUFFIX into l_message_suffix
35: from pon_auc_doctypes d , pon_auction_headers_all pah
36: where pah.auction_header_id = p_auction_header_id
37: and pah.DOCTYPE_ID = d.DOCTYPE_ID;
38:
39: l_message_suffix := '_'||l_message_suffix;

Line 176: p_outcome IN pon_auction_headers_all.contract_type%TYPE,

172: FUNCTION get_supplier_bid_total
173: (p_auction_header_id IN NUMBER,
174: p_bid_number IN NUMBER,
175: p_buyer_bid_total IN NUMBER,
176: p_outcome IN pon_auction_headers_all.contract_type%TYPE,
177: p_doctype_group_name IN VARCHAR2,
178: p_bid_status IN VARCHAR2
179: ) RETURN NUMBER
180:

Line 709: from pon_auction_headers_all

705: --java/schema/server/ScoringTeamPriceVisibilityVVO, java/schema/server/STMemberAccessVVO
706:
707: select has_scoring_teams_flag
708: into l_has_scoring_teams_flag
709: from pon_auction_headers_all
710: where auction_header_id = p_auction_header_id;
711:
712: if l_has_scoring_teams_flag = 'Y' then
713: BEGIN

Line 979: FROM pon_auction_headers_all pah

975: 'PON_CREATED_BY', 'PON_EMD_REPORT_HEADING' --Added by Chaoqun on 16-Apr-2009 for UI Change
976: )
977: and application_id = 396
978: and language_code = l_printing_language) as GENERIC_MESSAGES
979: FROM pon_auction_headers_all pah
980: , fnd_lookup_values flv
981: -- , FND_USER fu
982: WHERE pah.auction_header_id = p_auction_header_id --Using the variable p_auction_header_id
983: and flv.lookup_type(+) = 'PON_AUCTION_EMD_TYPE'

Line 1164: from pon_auction_headers_all paha,

1160: 'PON_EMD_CREATED_BY', 'PON_EMD_SUPPLIER_HEADING' --Added by Chaoqun on 15-Mar-2009 for UI Change
1161: )
1162: and application_id = 396
1163: and language_code = l_printing_language) as GENERIC_MESSAGES
1164: from pon_auction_headers_all paha,
1165: pon_bidding_parties pbp,
1166: fnd_lookup_values fl,
1167: fnd_lookups fl1,
1168: pon_auc_doctypes doc,

Line 1411: from pon_auction_headers_all paha,

1407: ---------------------------------
1408: )
1409: and application_id = 396
1410: and language_code = l_printing_language) as GENERIC_MESSAGES
1411: from pon_auction_headers_all paha,
1412: pon_emd_transactions petr,
1413: pon_bidding_parties pbp,
1414: fnd_lookup_values fl,
1415: fnd_lookups fl1,

Line 1629: from pon_auction_headers_all paha,

1625: 'PON_EMD_RECEIPT_HEADING' --Added by Chaoqun on 16-Apr-2009 for UI Change
1626: )
1627: and application_id = 396
1628: and language_code = l_printing_language) as GENERIC_MESSAGES
1629: from pon_auction_headers_all paha,
1630: pon_emd_transactions petr,
1631: pon_bidding_parties pbp,
1632: fnd_lookup_values flv,
1633: HR_ALL_ORGANIZATION_UNITS_TL ou,

Line 1781: l_neg_tp_id pon_auction_headers_all.trading_partner_id%type;

1777:
1778: res CLOB;
1779:
1780: xml_stmt varchar2(500);
1781: l_neg_tp_id pon_auction_headers_all.trading_partner_id%type;
1782: l_doc_type_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
1783: l_doc_type VARCHAR2(50);
1784: l_currency_code pon_auction_headers_all.currency_code%type;
1785: l_price_precision pon_auction_headers_all.number_price_decimals%type;

Line 1782: l_doc_type_id pon_auction_headers_all.DOCTYPE_ID%TYPE;

1778: res CLOB;
1779:
1780: xml_stmt varchar2(500);
1781: l_neg_tp_id pon_auction_headers_all.trading_partner_id%type;
1782: l_doc_type_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
1783: l_doc_type VARCHAR2(50);
1784: l_currency_code pon_auction_headers_all.currency_code%type;
1785: l_price_precision pon_auction_headers_all.number_price_decimals%type;
1786: l_price_mask varchar2(80); -- mask based on the negotiation price precision

Line 1784: l_currency_code pon_auction_headers_all.currency_code%type;

1780: xml_stmt varchar2(500);
1781: l_neg_tp_id pon_auction_headers_all.trading_partner_id%type;
1782: l_doc_type_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
1783: l_doc_type VARCHAR2(50);
1784: l_currency_code pon_auction_headers_all.currency_code%type;
1785: l_price_precision pon_auction_headers_all.number_price_decimals%type;
1786: l_price_mask varchar2(80); -- mask based on the negotiation price precision
1787: l_amount_mask varchar2(80); -- mask based on the negotiation currency precision
1788:

Line 1785: l_price_precision pon_auction_headers_all.number_price_decimals%type;

1781: l_neg_tp_id pon_auction_headers_all.trading_partner_id%type;
1782: l_doc_type_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
1783: l_doc_type VARCHAR2(50);
1784: l_currency_code pon_auction_headers_all.currency_code%type;
1785: l_price_precision pon_auction_headers_all.number_price_decimals%type;
1786: l_price_mask varchar2(80); -- mask based on the negotiation price precision
1787: l_amount_mask varchar2(80); -- mask based on the negotiation currency precision
1788:
1789: l_contracts_installed VARCHAR2(1);

Line 1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;

1800: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1801: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';
1802:
1803:
1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
1806: l_start_price_from_prev_rnd VARCHAR2(1);
1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;

Line 1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;

1801: l_module_name VARCHAR2(80) := 'pon.plsql.PON_PRINTING_PKG.GENERATE_AUCTION_XML';
1802:
1803:
1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
1806: l_start_price_from_prev_rnd VARCHAR2(1);
1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1809: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

Line 1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;

1804: l_enfrc_prevrnd_bid_price_flag pon_auction_headers_all.enforce_prevrnd_bid_price_flag%TYPE;
1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
1806: l_start_price_from_prev_rnd VARCHAR2(1);
1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1809: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
1810: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
1811:
1812: --bidpdf:

Line 1809: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

1805: l_auction_header_id_prev_round pon_auction_headers_all.auction_header_id_prev_round%TYPE;
1806: l_start_price_from_prev_rnd VARCHAR2(1);
1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1809: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
1810: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
1811:
1812: --bidpdf:
1813: l_is_bidpdf VARCHAR2(1) := 'Y';

Line 1810: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

1806: l_start_price_from_prev_rnd VARCHAR2(1);
1807: l_prev_rnd_bid_number pon_bid_headers.bid_number%TYPE;
1808: l_contract_type pon_auction_headers_all.contract_type%TYPE;
1809: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
1810: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
1811:
1812: --bidpdf:
1813: l_is_bidpdf VARCHAR2(1) := 'Y';
1814: l_is_supplier_bidpdf VARCHAR2(1) := 'N';

Line 1846: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag

1842: -- control "enforce supplie's previous round price as bid start price"
1843: l_prev_rnd_doctype pon_auc_doctypes.internal_name%TYPE;
1844: -- two-part RFQ
1845: l_hide_comm_part VARCHAR2(1) := 'N';
1846: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag
1847: -- commercial lock status
1848: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%TYPE;
1849: -- technical shortlist status
1850: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;

Line 1848: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%TYPE;

1844: -- two-part RFQ
1845: l_hide_comm_part VARCHAR2(1) := 'N';
1846: l_two_part_flag pon_auction_headers_all.two_part_flag%TYPE; -- two-part flag
1847: -- commercial lock status
1848: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%TYPE;
1849: -- technical shortlist status
1850: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;
1851: --added by Allen Yang for Surrogate Bid 2008/09/04
1852: ---------------------------------------------------------------

Line 1853: l_tech_evaluation_status PON_AUCTION_HEADERS_ALL.Technical_Evaluation_Status%TYPE;

1849: -- technical shortlist status
1850: l_tech_shortlist_flag pon_bid_headers.technical_shortlist_flag%type;
1851: --added by Allen Yang for Surrogate Bid 2008/09/04
1852: ---------------------------------------------------------------
1853: l_tech_evaluation_status PON_AUCTION_HEADERS_ALL.Technical_Evaluation_Status%TYPE;
1854: l_surrogate_bid_flag PON_BID_HEADERS.Surrog_Bid_Flag%TYPE;
1855: CURSOR tech_surrogate_bid_cur IS
1856: SELECT
1857: paha.Technical_Evaluation_Status

Line 1860: pon_auction_headers_all paha, pon_bid_headers pbh

1856: SELECT
1857: paha.Technical_Evaluation_Status
1858: , pbh.SURROG_BID_FLAG
1859: FROM
1860: pon_auction_headers_all paha, pon_bid_headers pbh
1861: WHERE paha.auction_header_id=pbh.auction_header_id
1862: AND paha.auction_header_id=p_auction_header_id
1863: AND pbh.bid_number = p_bid_number;
1864: ----------------------------------------------------------------

Line 1943: from pon_auction_headers_all

1939: l_supplier_view_type,
1940: l_pf_type_allowed,
1941: l_two_part_flag,
1942: l_commercial_lock_status
1943: from pon_auction_headers_all
1944: where auction_header_id = p_auction_header_id;
1945:
1946: IF l_auction_header_id_prev_round IS NOT NULL
1947: THEN

Line 1951: FROM pon_auction_headers_all pah, pon_auc_doctypes doctypes

1947: THEN
1948: BEGIN
1949: SELECT doctypes.internal_name
1950: INTO l_prev_rnd_doctype
1951: FROM pon_auction_headers_all pah, pon_auc_doctypes doctypes
1952: WHERE pah.auction_header_id = l_auction_header_id_prev_round
1953: and pah.doctype_id = doctypes.doctype_id;
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND

Line 1990: FROM pon_neg_team_members pntm, pon_auction_headers_all pah

1986: --As in ViewBidCO, hasScoringTeamsFlag !isScoringLocked isScorer
1987: BEGIN
1988: SELECT 'Y'
1989: INTO l_is_section_restricted
1990: FROM pon_neg_team_members pntm, pon_auction_headers_all pah
1991: WHERE pah.auction_header_id = p_auction_header_id
1992: AND pntm.menu_name = 'PON_SOURCING_SCORENEG'
1993: AND pntm.auction_header_id = pah.auction_header_id
1994: AND pntm.user_id = p_user_id

Line 2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr

2023: -- get supplier site address/contact, reference from java/poplist/server/VendorSitesAllVO.xml
2024: SELECT pvsa.address_line1,pvsa.address_line2,pvsa.address_line3,pvsa.city,pvsa.state,pvsa.zip,pvsa.country, nvl(entity_terr.territory_short_name,pvsa.country),
2025: decode(pbp.trading_partner_contact_id, null, pbp.requested_supp_contact_name, PON_LOCALE_PKG.get_party_display_name(pbp.trading_partner_contact_id)) contact_name
2026: into l_supplier_address_line1,l_supplier_address_line2,l_supplier_address_line3,l_supplier_address_city,l_supplier_address_state,l_supplier_postal_code,l_supplier_country_code,l_supplier_country,l_contact_details_name
2027: FROM PO_VENDOR_SITES_ALL pvsa, pon_auction_headers_all pah, pon_bidding_parties pbp, fnd_territories_tl entity_terr
2028: WHERE
2029: pah.auction_header_id = p_auction_header_id
2030: AND pvsa.org_id = pah.org_id
2031: AND PURCHASING_SITE_FLAG = 'Y'

Line 2550: pon_auction_headers_all pah ,

2546: pah.INT_ATTRIBUTE15,
2547: pah.NEGOTIATION_REQUESTER_ID
2548: ------------End: Added as part of bug 8771921 ---------------
2549: from
2550: pon_auction_headers_all pah ,
2551: fnd_lookups fl,
2552: fnd_lookups fl2,
2553: fnd_lookups flbr ,
2554: fnd_lookups fl_rank_ind,

Line 3115: pon_auction_headers_all pah,

3111: pas.score,
3112: pas.sequence_number,
3113: get_acceptable_value(pah.show_bidder_scores,pas.attribute_sequence_number,paa.datatype,pas.from_range,pas.to_range,pas.value,pas.score, p_client_time_zone, p_server_time_zone, p_date_format, l_is_buyer_negpdf) display_score
3114: FROM
3115: pon_auction_headers_all pah,
3116: pon_attribute_scores pas,
3117: pon_auction_attributes paa
3118: where
3119: pah.auction_header_id = p_auction_header_id

Line 3208: pon_auction_headers_all pah,

3204: decode(pe.display_to_suppliers_flag,
3205: 'N', 'N',
3206: PON_TRANSFORM_BIDDING_PKG.has_pf_values_defined(pe.auction_header_id, pe.line_number, pe.sequence_number, p_trading_partner_id, p_vendor_site_id, p_requested_supplier_id)))) can_view_pf_flag
3207: FROM
3208: pon_auction_headers_all pah,
3209: pon_price_elements pe,
3210: pon_price_element_types_tl pet,
3211: pon_auction_item_prices_all itm,
3212: fnd_lookup_values flv,

Line 3521: PON_AUCTION_HEADERS_ALL PAH,

3517: p_client_time_zone,
3518: p_server_time_zone,
3519: p_date_format, 'N') target_date
3520: FROM
3521: PON_AUCTION_HEADERS_ALL PAH,
3522: PON_NEG_TEAM_MEMBERS TM,
3523: FND_USER U,
3524: PER_ALL_PEOPLE_F P,
3525: PER_ALL_ASSIGNMENTS_F A,

Line 3579: FROM pon_auction_headers_all pah,

3575: SELECT sctm.team_id
3576: ,sctm.team_name
3577: ,sctm.price_visible_flag
3578: ,sctm.instruction_text
3579: FROM pon_auction_headers_all pah,
3580: pon_scoring_teams sctm
3581: WHERE pah.auction_header_id = p_auction_header_id
3582: AND sctm.auction_header_id = pah.auction_header_id
3583: AND pah.has_scoring_teams_flag = 'Y' -- teams present only if flag present

Line 3609: FROM pon_auction_headers_all pah

3605: -- multipler user ids resulting in more rows being returned
3606: stmem.team_id
3607: ,stmem.user_id
3608: ,per.full_name member_name
3609: FROM pon_auction_headers_all pah
3610: ,pon_scoring_team_members stmem
3611: ,fnd_user fuser
3612: ,per_all_people_f per
3613: WHERE pah.auction_header_id = p_auction_header_id

Line 3643: FROM pon_auction_headers_all pah,

3639: SELECT team_sections.section_id
3640: ,sections.section_name
3641: ,team_sections.auction_header_id
3642: ,team_sections.team_id
3643: FROM pon_auction_headers_all pah,
3644: pon_scoring_team_sections team_sections
3645: ,pon_auction_sections sections
3646: WHERE pah.auction_header_id = p_auction_header_id
3647: AND team_sections.auction_header_id = pah.auction_header_id

Line 3682: form_instances.entity_code = 'PON_AUCTION_HEADERS_ALL'

3678: pon_forms_instances form_instances,
3679: pon_forms_sections forms,
3680: pon_forms_sections_tl forms_tl
3681: WHERE
3682: form_instances.entity_code = 'PON_AUCTION_HEADERS_ALL'
3683: AND form_instances.entity_pk1 = TO_CHAR(p_auction_header_id)
3684: AND l_is_buyer_negpdf = 'Y'
3685: AND forms_tl.language = l_printing_language
3686: AND form_instances.form_id = forms.form_id

Line 3717: pon_auction_headers_all pah,

3713: -- bug 8667493 following column added to display EMD amount, if enabled, in different currencies
3714: to_char((Nvl(pah.emd_amount,0) * pacr.rate),'FM999G999G999G999G999G999G999G999G999G999D00') emd_resp_curr_amount,
3715: pon_printing_pkg.get_display_rate(pacr.rate_dsp,pah.rate_type,pah.rate_date,pah.currency_code,bid_currency_code) display_rate
3716: FROM
3717: pon_auction_headers_all pah,
3718: pon_auction_currency_rates pacr ,
3719: fnd_currencies_tl ftl
3720: where
3721: pah.auction_header_id = p_auction_header_id

Line 3753: pon_auction_headers_all pah,

3749: -- bug 8667493 following column added to display EMD amount, if enabled, in different currencies
3750: to_char((Nvl(pah.emd_amount,0) * pbp.rate),'FM999G999G999G999G999G999G999G999G999G999D00') emd_resp_curr_amount,
3751: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate
3752: FROM
3753: pon_auction_headers_all pah,
3754: pon_bidding_parties pbp,
3755: fnd_currencies_tl ftl
3756: WHERE pah.auction_header_id = p_auction_header_id
3757: AND pbp.auction_header_id = pah.auction_header_id

Line 3826: pon_auction_headers_all pah,

3822: pas.score,
3823: pas.sequence_number,
3824: pon_printing_pkg.get_acceptable_value(pah.HDR_ATTR_DISPLAY_SCORE,pas.attribute_sequence_number,pa.datatype,pas.from_range,pas.to_range,pas.value,pas.score, p_client_time_zone, p_server_time_zone, p_date_format, l_is_buyer_negpdf) display_score
3825: from
3826: pon_auction_headers_all pah,
3827: pon_attribute_scores pas
3828: where
3829: pah.auction_header_id = p_auction_header_id
3830: AND pas.auction_header_id = pa.auction_header_id

Line 3986: pon_auction_headers_all pah,

3982: pfs.price_element_type_id,
3983: pfs.pricing_basis,
3984: Decode(Nvl(pfs.negative_cost_factor_flag,'N'),'Y','Yes','No') negative_cost_factor_flag
3985: FROM
3986: pon_auction_headers_all pah,
3987: pon_price_elements pfs,
3988: pon_pf_supplier_values pf_values
3989: WHERE pah.auction_header_id = p_auction_header_id
3990: and pf_values.auction_header_id = pah.auction_header_id

Line 4024: pon_auction_headers_all pah,

4020: Decode(Nvl(ppe.negative_cost_factor_flag,'N'),'Y','Yes','No') negative_cost_factor_flag,
4021: ppett.name,
4022: fl.meaning as pricing_basis_meaning
4023: FROM
4024: pon_auction_headers_all pah,
4025: pon_price_elements ppe,
4026: pon_price_element_types_tl ppett,
4027: fnd_lookups fl
4028: WHERE pah.auction_header_id = p_auction_header_id

Line 4063: pon_auction_headers_all pah,

4059: pon_large_neg_pf_values.supplier_seq_number,
4060: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
4061: pon_large_neg_pf_values.value
4062: from
4063: pon_auction_headers_all pah,
4064: pon_large_neg_pf_values pon_large_neg_pf_values,
4065: pon_price_element_types_vl priceelementtypesvl,
4066: fnd_lookups lookuptable
4067: WHERE pah.auction_header_id = p_auction_header_id

Line 4228: from pon_auction_headers_all pah,

4224: to_char(paip.auction_header_id) pk1_value,
4225: to_char(paip.line_number) pk2_value,
4226: ad.pk3_value,
4227: categories_tl.user_name category_name
4228: from pon_auction_headers_all pah,
4229: fnd_documents_vl d,
4230: fnd_attached_documents ad,
4231: fnd_document_categories categories,
4232: fnd_document_categories_tl categories_tl,

Line 4266: 'PON_AUCTION_HEADERS_ALL')

4262: fnd_document_categories_tl categories_tl
4263: where d.document_id = ad.document_id
4264: and
4265: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',
4266: 'PON_AUCTION_HEADERS_ALL')
4267: and ad.pk1_value = to_char(p_auction_header_id)
4268: and (l_is_buyer_negpdf = 'Y' or categories.name='Vendor')
4269: and categories.category_id = d.category_id
4270: and categories.category_id = categories_tl.category_id

Line 4383: pon_auction_headers_all pah

4379: OPEN doc_rules_cursor FOR
4380: select
4381: bizrules.name
4382: FROM
4383: pon_auction_headers_all pah
4384: , pon_auc_doctype_rules doctype_rules
4385: , pon_auc_bizrules bizrules
4386: WHERE pah.auction_header_id = p_auction_header_id
4387: AND doctype_rules.bizrule_id = bizrules.bizrule_id

Line 4790: pon_auction_headers_all pah,

4786: OPEN doc_msgs_cursor FOR
4787: select substr(message_name,1,length(message_name)-2) message_name,
4788: message_text
4789: FROM
4790: pon_auction_headers_all pah,
4791: pon_auc_doctypes doctypes,
4792: fnd_new_messages msgs
4793: where pah.auction_header_id = p_auction_header_id
4794: AND doctypes.doctype_id = pah.doctype_id