APPS.PO_UDA_TEMPLATES_UTIL dependencies on PON_BID_HEADERS

Line 1115: FROM PON_BID_HEADERS

1111: END IF;
1112: IF l_entity_code = 'PON_BID_HDRS_EXT_ATTRS' THEN
1113: SELECT count(*)
1114: INTO l_count
1115: FROM PON_BID_HEADERS
1116: WHERE UDA_TEMPLATE_ID = l_template_id;
1117: END IF;
1118: IF l_entity_code = 'PON_BID_PRICES_EXT_ATTRS' THEN
1119: SELECT count(*)

Line 3747: FROM PON_BID_HEADERS_EXT_VL pkt0 , PON_BID_HEADERS tbl

3743: Here we are constructng the query for the view. If the template is having 2 usages, the sample create view statement will be like
3744: CREATE OR REPLACE VIEW pon_bid_hdrs_ext_attrs_v ( bid_number, "SEQUENCE", descriptionsource, label, attachedfile, displaymode, translatablelabel)
3745: AS
3746: (SELECT tbl.bid_number, pkt0.N_EXT_ATTR1 , pkt0.C_EXT_ATTR1 , pkt0.C_EXT_ATTR2 , pkt0.C_EXT_ATTR3 , pkt0.C_EXT_ATTR4 , pkt0.TL_EXT_ATTR2
3747: FROM PON_BID_HEADERS_EXT_VL pkt0 , PON_BID_HEADERS tbl
3748: WHERE pkt0.attr_group_id (+) = 2 AND tbl.bid_number = pkt0.bid_number )
3749: */
3750: PROCEDURE get_query_for_entity_view(p_api_version IN NUMBER,
3751: p_entity_code IN VARCHAR2,