DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB dependencies on HZ_PARTIES

Line 98: -- Valid party id from HZ_PARTIES

94: -- can be specified only if you waNt to update an existing
95: -- record(when called from Update_ServiceRequest API)
96:
97: -- party_id REQUIRED
98: -- Valid party id from HZ_PARTIES
99:
100: -- contact_point_id OPTIONAL
101: -- VAlid contact_point_id from HZ_CONTACT_POINTS
102:

Line 625: Contact_Name hz_parties.party_name%TYPE ,

621: Created_By fnd_user.user_name%TYPE ,
622: Contact_Party_id cs_hz_sr_contact_points.party_id%TYPE ,
623: Contact_Type FND_LOOKUP_VALUES.meaning%TYPE ,
624: --special case
625: Contact_Name hz_parties.party_name%TYPE ,
626: Time_Zone_Id cs_incidents_all_b.time_zone_id%TYPE ,
627: Time_Zone_Name hz_timezones.global_timezone_name%TYPE ,
628: Customer_ID cs_incidents_all_b.customer_id%TYPE ,
629: Customer_Number hz_parties.party_number%TYPE ,

Line 629: Customer_Number hz_parties.party_number%TYPE ,

625: Contact_Name hz_parties.party_name%TYPE ,
626: Time_Zone_Id cs_incidents_all_b.time_zone_id%TYPE ,
627: Time_Zone_Name hz_timezones.global_timezone_name%TYPE ,
628: Customer_ID cs_incidents_all_b.customer_id%TYPE ,
629: Customer_Number hz_parties.party_number%TYPE ,
630: Customer_Name hz_parties.party_name%TYPE ,
631: Account_Id cs_incidents_all_b.account_id%TYPE ,
632: Account_Number hz_cust_accounts.account_number%TYPE ,
633: Inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE ,

Line 630: Customer_Name hz_parties.party_name%TYPE ,

626: Time_Zone_Id cs_incidents_all_b.time_zone_id%TYPE ,
627: Time_Zone_Name hz_timezones.global_timezone_name%TYPE ,
628: Customer_ID cs_incidents_all_b.customer_id%TYPE ,
629: Customer_Number hz_parties.party_number%TYPE ,
630: Customer_Name hz_parties.party_name%TYPE ,
631: Account_Id cs_incidents_all_b.account_id%TYPE ,
632: Account_Number hz_cust_accounts.account_number%TYPE ,
633: Inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE ,
634: Product mtl_system_items_b_kfv.concatenated_segments%TYPE ,

Line 652: customer_phone hz_parties.primary_phone_number%TYPE ,

648: Created_By_Id cs_incidents_all_b.created_by%TYPE ,
649: Customer_Product_Id cs_incidents_all_b.customer_product_id%TYPE ,
650: Organization_Id cs_incidents_all_b.org_id%TYPE ,
651: Inventory_Org_id cs_incidents_all_b.inv_organization_id%TYPE ,
652: customer_phone hz_parties.primary_phone_number%TYPE ,
653: Customer_Email hz_parties.email_address%TYPE ,
654: Contract_Number okc_k_headers_all_b.contract_number%TYPE ,
655: Contract_Service_Description mtl_system_items_b.description%TYPE ,
656: Contract_Coverage_Description okc_k_lines_tl.item_description%TYPE ,

Line 653: Customer_Email hz_parties.email_address%TYPE ,

649: Customer_Product_Id cs_incidents_all_b.customer_product_id%TYPE ,
650: Organization_Id cs_incidents_all_b.org_id%TYPE ,
651: Inventory_Org_id cs_incidents_all_b.inv_organization_id%TYPE ,
652: customer_phone hz_parties.primary_phone_number%TYPE ,
653: Customer_Email hz_parties.email_address%TYPE ,
654: Contract_Number okc_k_headers_all_b.contract_number%TYPE ,
655: Contract_Service_Description mtl_system_items_b.description%TYPE ,
656: Contract_Coverage_Description okc_k_lines_tl.item_description%TYPE ,
657: Customer_Type FND_LOOKUP_VALUES.meaning%TYPE ,