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_ATTR_MAPPING dependencies on HZ_PARTIES

Line 92: WHERE owner_table_name = 'HZ_PARTIES'

88: SELECT 'HZ:'|| hccr.class_category || ':' || hccr.class_code AS code
89: FROM hz_class_code_relations hccr,
90: ( SELECT class_category, class_code, owner_table_id
91: FROM hz_code_assignments
92: WHERE owner_table_name = 'HZ_PARTIES'
93: AND owner_table_id = x_party_id
94: AND start_date_active <= SYSDATE
95: AND NVL(end_date_active, SYSDATE) >= SYSDATE
96: AND status = 'A' ) v

Line 105: WHERE owner_table_name = 'HZ_PARTIES'

101: SELECT 'HZ:'|| fnd.lookup_type || ':' || fnd.lookup_code
102: FROM fnd_lookup_values_vl fnd,
103: ( SELECT class_category, class_code, owner_table_id
104: FROM hz_code_assignments
105: WHERE owner_table_name = 'HZ_PARTIES'
106: AND owner_table_id = x_party_id
107: AND start_date_active <= SYSDATE
108: AND nvl(end_date_active, SYSDATE) >= SYSDATE
109: AND status = 'A' ) v

Line 385: , HZ_PARTIES HZ1

381: , l_vendor_site_id
382: , l_vendor_name
383: , l_evaluation_flag
384: FROM PON_BID_HEADERS PON
385: , HZ_PARTIES HZ1
386: , HZ_PARTIES HZ2
387: , AP_SUPPLIERS AP
388: WHERE PON.AUCTION_HEADER_ID = p_auction_header_id
389: AND PON.BID_NUMBER = p_bid_number

Line 386: , HZ_PARTIES HZ2

382: , l_vendor_name
383: , l_evaluation_flag
384: FROM PON_BID_HEADERS PON
385: , HZ_PARTIES HZ1
386: , HZ_PARTIES HZ2
387: , AP_SUPPLIERS AP
388: WHERE PON.AUCTION_HEADER_ID = p_auction_header_id
389: AND PON.BID_NUMBER = p_bid_number
390: AND HZ1.PARTY_ID (+) = PON.EVALUATOR_ID

Line 583: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');

579:
580: END LOOP; -- supp_mapping_setup_cursor
581:
582: IF (l_row_attrs_table.COUNT > 0) THEN
583: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');
584: l_object_name := 'HZ_PARTIES';
585: l_application_id := 177;
586: l_attr_group_type := 'POS_SUPP_PROFMGMT_GROUP';
587: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', l_party_id));

Line 584: l_object_name := 'HZ_PARTIES';

580: END LOOP; -- supp_mapping_setup_cursor
581:
582: IF (l_row_attrs_table.COUNT > 0) THEN
583: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');
584: l_object_name := 'HZ_PARTIES';
585: l_application_id := 177;
586: l_attr_group_type := 'POS_SUPP_PROFMGMT_GROUP';
587: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', l_party_id));
588: Get_Supp_Related_Class_Codes(l_vendor_id, l_party_id, l_object_id, l_data_level_name, supp_ag_dl_rec.attr_group_id, l_class_code_pairs);

Line 606: , p_object_name => l_object_name-- HZ_PARTIES/EGO_ITEM

602: /* call ego api to sync data */
603: ego_user_attrs_data_pvt.Process_Row(
604: p_api_version => 1.0
605: , p_object_id => l_object_id
606: , p_object_name => l_object_name-- HZ_PARTIES/EGO_ITEM
607: , p_attr_group_id => supp_ag_dl_rec.attr_group_id-- input
608: , p_application_id => l_application_id-- 177 for supplier, 431 for item
609: , p_attr_group_type => l_attr_group_type-- POS_SUPP_PROFMGMT_GROUP/EGO_ITEMMGMT_GROUP
610: , p_attr_group_name => l_attr_group_name-- input

Line 885: , p_object_name => l_object_name-- HZ_PARTIES/EGO_ITEM

881: /* call ego api to sync data */
882: ego_user_attrs_data_pvt.Process_Row(
883: p_api_version => 1.0
884: , p_object_id => l_object_id
885: , p_object_name => l_object_name-- HZ_PARTIES/EGO_ITEM
886: , p_attr_group_id => item_ag_dl_rec.attr_group_id-- input
887: , p_application_id => l_application_id-- 177 for supplier, 431 for item
888: , p_attr_group_type => l_attr_group_type-- POS_SUPP_PROFMGMT_GROUP/EGO_ITEMMGMT_GROUP
889: , p_attr_group_name => l_attr_group_name-- input