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_COPY_UDAS_GRP dependencies on EGO_ATTR_GROUPS_V

Line 185: SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

181: select lookup_code from po_lookup_codes where lookup_type = 'SOL_UDA_ADDRESS_TYPES';
182:
183:
184: cursor attr_groups_cur(p_template_id Number) is
185: SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
186: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
187: WHERE template_id = p_template_id and ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING');
188: BEGIN
189:

Line 375: ,ego_attr_groups_v eagv

371: FROM
372: po_uda_ag_templates puat
373: ,po_uda_ag_template_usages puatu
374: ,pon_bid_item_prices pbip
375: ,ego_attr_groups_v eagv
376:
377: WHERE puat.template_id = p_bid_template_id
378: AND puatu.template_id = puat.template_id
379: AND pbip.bid_number = p_bid_number

Line 656: FROM po_uda_ag_template_usages tu, ego_attr_groups_v ag

652: log_message('get_attribute_groups','Entered PROCEDURE');
653:
654: SELECT DISTINCT ag.attr_group_name
655: BULK COLLECT INTO x_attr_group_tbl
656: FROM po_uda_ag_template_usages tu, ego_attr_groups_v ag
657: WHERE tu.template_id = p_uda_template_id
658: AND ag.attr_group_id = tu.attribute_group_id
659: AND tu.attribute_category NOT IN ('PRICING','DOCUMENT_NUMBERING','ADDRESS'); --12611018 Document numbering added
660:

Line 766: FROM ego_attr_groups_v ag_v, po_uda_ag_template_usages ag, pon_bid_item_prices bid_lines

762: l_clm_idc_type po_lines_all.CLM_IDC_TYPE%TYPE;
763:
764: CURSOR attr_groups_cursor(p_bid_number NUMBER,p_bid_line_number NUMBER) is
765: select distinct(ATTR_GROUP_NAME) ATTR_GROUP_NAME
766: FROM ego_attr_groups_v ag_v, po_uda_ag_template_usages ag, pon_bid_item_prices bid_lines
767: where bid_lines.bid_number = p_bid_number
768: and bid_lines.line_number = p_bid_line_number
769: and bid_lines.uda_template_id = ag.template_id
770: and Nvl(ag.attribute1,'A') = Decode(ag.attribute1,NULL,'A',bid_lines.clm_idc_type)

Line 869: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE (attr_group_id IN

865: BEGIN
866: attrGrpCur := NULL;
867: if ( p_src_doc_type = 'PO' ) THEN
868: if ( p_tar_doc_level = 'HEADER' ) THEN
869: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE (attr_group_id IN
870: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
871: WHERE template_id = p_tar_template_id and ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING' and ATTRIBUTE_CATEGORY <> 'ADDRESS')
872: AND ATTR_GROUP_NAME <> 'AQ_PLAN1');
873: elsif ( p_tar_doc_level = 'LINE' and p_src_doc_level = 'LINE' ) THEN

Line 874: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

870: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
871: WHERE template_id = p_tar_template_id and ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING' and ATTRIBUTE_CATEGORY <> 'ADDRESS')
872: AND ATTR_GROUP_NAME <> 'AQ_PLAN1');
873: elsif ( p_tar_doc_level = 'LINE' and p_src_doc_level = 'LINE' ) THEN
874: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
875: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
876: WHERE template_id = p_tar_template_id and attribute_category <> 'FED_FIELDS');
877: elsif ( p_tar_doc_level = 'LINE' and p_src_doc_level = 'SHIP' ) THEN
878: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

Line 878: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

874: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
875: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
876: WHERE template_id = p_tar_template_id and attribute_category <> 'FED_FIELDS');
877: elsif ( p_tar_doc_level = 'LINE' and p_src_doc_level = 'SHIP' ) THEN
878: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
879: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
880: WHERE template_id = p_tar_template_id and attribute_category = 'FED_FIELDS');
881: end if;
882: elsif ( p_src_doc_type = 'REQ' ) THEN

Line 884: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

880: WHERE template_id = p_tar_template_id and attribute_category = 'FED_FIELDS');
881: end if;
882: elsif ( p_src_doc_type = 'REQ' ) THEN
883: if ( p_tar_doc_level = 'HEADER' ) THEN
884: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
885: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
886: WHERE template_id = p_tar_template_id and ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING' and ATTRIBUTE_CATEGORY <> 'ADDRESS');
887: elsif ( p_tar_doc_level = 'LINE' ) THEN
888: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

Line 888: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN

884: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
885: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
886: WHERE template_id = p_tar_template_id and ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING' and ATTRIBUTE_CATEGORY <> 'ADDRESS');
887: elsif ( p_tar_doc_level = 'LINE' ) THEN
888: open attrGrpCur for SELECT ATTR_GROUP_NAME FROM ego_attr_groups_v WHERE attr_group_id IN
889: (SELECT DISTINCT(ATTRIBUTE_GROUP_ID) FROM po_uda_ag_template_usages
890: WHERE template_id = p_src_template_id);
891: end if;
892: end if;