APPS.SR_UWQ_INTEG dependencies on HZ_PARTIES

Line 1173: from csi_item_instances item, hz_parties hzp

1169: -- be passed as parameter.
1170: cursor tag_cursor is
1171: select item.instance_id, item.owner_party_id,
1172: hzp.party_type
1173: from csi_item_instances item, hz_parties hzp
1174: where item.external_reference = p_parameter_value
1175: and hzp.party_id = item.owner_party_id;
1176:
1177: -- Validate the Serial Number

Line 1181: from csi_item_instances item, hz_parties hzp

1177: -- Validate the Serial Number
1178: cursor serial_cursor is
1179: select item.instance_id, item.owner_party_id,
1180: hzp.party_type
1181: from csi_item_instances item, hz_parties hzp
1182: where item.serial_number = p_parameter_value
1183: and hzp.party_id = item.owner_party_id;
1184:
1185: -- Validate the Contract number.

Line 1190: from oks_ent_hdr_summary_v oks, hz_parties hzp

1186: -- When a Contract number is passed as an IVR it is converted
1187: -- to the Party Id. All Open SR for that party is queried.
1188: cursor contract_cursor is
1189: select oks.contract_id, oks.party_id,hzp.party_type
1190: from oks_ent_hdr_summary_v oks, hz_parties hzp
1191: where oks.contract_number = p_parameter_value
1192: and oks.party_id = hzp.party_id
1193: and oks.start_date_active <= sysdate
1194: order by oks.start_date_active DESC;

Line 1200: from hz_cust_accounts acc, hz_parties party

1196: --Validate the Account Number.
1197: cursor account_cursor is
1198: select acc.cust_account_id,acc.party_id,
1199: party.party_type
1200: from hz_cust_accounts acc, hz_parties party
1201: where acc.account_number = p_parameter_value
1202: and acc.status = 'A'
1203: and party.party_id = acc.party_id;
1204:

Line 1209: from hz_parties party

1205: --Validate the Party Number.
1206: cursor party_cursor is
1207: select party.party_id,party.party_id,
1208: party.party_type
1209: from hz_parties party
1210: where party_number = p_parameter_value;
1211:
1212: --Validate the Phone Number
1213:

Line 1226: from hz_contact_points hzc, hz_parties hzp

1222: --Validate the Phone Number on a CREATE_SR scenario
1223:
1224: cursor phone_cursor_create_sr is
1225: select hzc.owner_table_id,hzp.party_number,hzp.party_type
1226: from hz_contact_points hzc, hz_parties hzp
1227: where hzc.transposed_phone_number = v_transposed_phone_number
1228: and hzc.owner_table_id = hzp.party_id
1229: and hzc.owner_table_name = 'HZ_PARTIES';
1230:

Line 1229: and hzc.owner_table_name = 'HZ_PARTIES';

1225: select hzc.owner_table_id,hzp.party_number,hzp.party_type
1226: from hz_contact_points hzc, hz_parties hzp
1227: where hzc.transposed_phone_number = v_transposed_phone_number
1228: and hzc.owner_table_id = hzp.party_id
1229: and hzc.owner_table_name = 'HZ_PARTIES';
1230:
1231: begin
1232: -- This procedure validates the IVR data using sqls.
1233: -- It returns the Id value of the parameter if found.

Line 1430: from hz_parties

1426:
1427: --Retrieve the Party Number.
1428: cursor party_cursor is
1429: select party_number
1430: from hz_parties
1431: where party_id = p_cust_id;
1432:
1433: begin
1434: x_return_status := 'S';