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.CSI_DIAGNOSTICS_PKG dependencies on HZ_PARTIES

Line 6711: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

6707: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6708: AND haou.organization_id = mssi.organization_id;
6709:
6710: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
6711: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
6712: l_parties_tbl(1).party_id := l_internal_party_id;
6713: l_parties_tbl(1).relationship_type_code := 'OWNER';
6714: l_parties_tbl(1).contact_flag := 'N';
6715: l_parties_tbl(1).object_version_number := 1.0;

Line 6836: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

6832: x_error_message => l_error_message);
6833: ELSE
6834:
6835: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
6836: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
6837: l_parties_tbl(1).party_id := p_diag_txn_rec.internal_party_id;
6838: l_parties_tbl(1).relationship_type_code := 'OWNER';
6839: l_parties_tbl(1).contact_flag := 'N';
6840: l_parties_tbl(1).object_version_number := 1.0;

Line 7080: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7076: x_error_message => l_error_message);
7077: ELSE
7078:
7079: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7080: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7081: l_parties_tbl(1).party_id := p_diag_txn_rec.internal_party_id;
7082: l_parties_tbl(1).relationship_type_code := 'OWNER';
7083: l_parties_tbl(1).contact_flag := 'N';
7084: l_parties_tbl(1).object_version_number := 1.0;

Line 7302: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7298: x_error_message => l_error_message);
7299: ELSE
7300:
7301: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7302: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7303: l_parties_tbl(1).party_id := p_diag_txn_rec.internal_party_id;
7304: l_parties_tbl(1).relationship_type_code := 'OWNER';
7305: l_parties_tbl(1).contact_flag := 'N';
7306: l_parties_tbl(1).object_version_number := 1.0;

Line 7472: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7468: x_error_message => l_error_message);
7469: ELSE
7470:
7471: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7472: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7473: l_parties_tbl(1).party_id := p_diag_txn_rec.internal_party_id;
7474: l_parties_tbl(1).relationship_type_code := 'OWNER';
7475: l_parties_tbl(1).contact_flag := 'N';
7476: l_parties_tbl(1).object_version_number := 1.0;

Line 7566: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7562: x_error_message => l_error_message);
7563: ELSE
7564:
7565: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7566: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7567: l_parties_tbl(1).party_id := p_diag_txn_rec.internal_party_id;
7568: l_parties_tbl(1).relationship_type_code := 'OWNER';
7569: l_parties_tbl(1).contact_flag := 'N';
7570: l_parties_tbl(1).object_version_number := 1.0;

Line 7683: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7679: x_error_message => l_error_message);
7680: ELSE
7681:
7682: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7683: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7684: l_parties_tbl(1).party_id := l_internal_party_id;
7685: l_parties_tbl(1).relationship_type_code := 'OWNER';
7686: l_parties_tbl(1).contact_flag := 'N';
7687: l_parties_tbl(1).object_version_number := 1.0;

Line 7788: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7784: l_instance_rec.lot_number := l_lot_number;
7785:
7786: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7787: l_parties_tbl(1).instance_id := fnd_api.g_miss_num;
7788: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7789: l_parties_tbl(1).party_id := l_internal_party_id;
7790: l_parties_tbl(1).relationship_type_code := 'OWNER';
7791: l_parties_tbl(1).contact_flag := 'N';
7792: l_parties_tbl(1).object_version_number := 1.0;

Line 7989: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

7985: x_error_message => l_error_message);
7986: ELSE
7987:
7988: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
7989: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
7990: l_parties_tbl(1).party_id := l_internal_party_id;
7991: l_parties_tbl(1).relationship_type_code := 'OWNER';
7992: l_parties_tbl(1).contact_flag := 'N';
7993: l_parties_tbl(1).object_version_number := 1.0;

Line 8103: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

8099: l_instance_rec.lot_number := null;
8100:
8101: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
8102: l_parties_tbl(1).instance_id := fnd_api.g_miss_num;
8103: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
8104: l_parties_tbl(1).party_id := l_internal_party_id;
8105: l_parties_tbl(1).relationship_type_code := 'OWNER';
8106: l_parties_tbl(1).contact_flag := 'N';
8107: l_parties_tbl(1).object_version_number := 1.0;

Line 8270: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

8266: x_error_message => l_error_message);
8267: ELSE
8268:
8269: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
8270: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
8271: l_parties_tbl(1).party_id := l_internal_party_id;
8272: l_parties_tbl(1).relationship_type_code := 'OWNER';
8273: l_parties_tbl(1).contact_flag := 'N';
8274: l_parties_tbl(1).object_version_number := 1.0;

Line 8392: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

8388: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
8389: AND haou.organization_id = mssi.organization_id;
8390:
8391: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
8392: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
8393: l_parties_tbl(1).party_id := l_internal_party_id;
8394: l_parties_tbl(1).relationship_type_code := 'OWNER';
8395: l_parties_tbl(1).contact_flag := 'N';
8396: l_parties_tbl(1).object_version_number := 1.0;

Line 9156: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

9152: log(' Owner Account ID: '||l_owner_account_id);
9153:
9154: IF l_change_owner_flag = 'Y' THEN
9155: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
9156: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
9157: l_parties_tbl(1).party_id := l_internal_party_id;
9158: l_parties_tbl(1).relationship_type_code := 'OWNER';
9159: l_parties_tbl(1).contact_flag := 'N';
9160: l_parties_tbl(1).object_version_number := 1.0;

Line 9163: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

9159: l_parties_tbl(1).contact_flag := 'N';
9160: l_parties_tbl(1).object_version_number := 1.0;
9161: ELSE
9162: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
9163: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
9164: l_parties_tbl(1).party_id := l_owner_party_id;
9165: l_parties_tbl(1).relationship_type_code := 'OWNER';
9166: l_parties_tbl(1).contact_flag := 'N';
9167: l_parties_tbl(1).object_version_number := 1.0;

Line 10534: OR owner_party_source_table not in ('HZ_PARTIES','PO_VENDORS','EMPLOYEE','TEAM','GROUP'));

10530: CURSOR CSI_INS_CUR IS
10531: SELECT instance_id,null
10532: FROM csi_item_instances
10533: WHERE (owner_party_source_table is null
10534: OR owner_party_source_table not in ('HZ_PARTIES','PO_VENDORS','EMPLOYEE','TEAM','GROUP'));
10535: --
10536: Type NumTabType is VARRAY(10000) of NUMBER;
10537: instance_id_mig NumTabType;
10538: --

Line 12568: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE

12564: ,-1 -- LAST_UPDATE_LOGIN
12565: ,1 -- OBJECT_VERSION_NUMBER
12566: ,NULL -- SECURITY_GROUP_ID
12567: ,'IN_INVENTORY' -- INSTANCE_USAGE_CODE
12568: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE
12569: ,v_party_id -- OWNER_PARTY_ID
12570: ,organization_id_mig(i) -- LAST_VLD_ORGANIZATION_ID
12571: );
12572: Exception

Line 12744: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE

12740: )
12741: VALUES(
12742: v_ins_party_id -- INSTANCE_PARTY_ID
12743: ,v_instance_id -- INSTANCE_ID
12744: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE
12745: ,v_party_id -- PARTY_ID
12746: ,'OWNER' -- RELATIONSHIP_TYPE_CODE
12747: ,'N' -- CONTACT_FLAG
12748: ,NULL -- CONTACT_IP_ID

Line 12806: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE

12802: v_ins_party_history_id -- INSTANCE_PARTY_HISTORY_ID
12803: ,v_ins_party_id -- INSTANCE_PARTY_ID
12804: ,v_txn_id -- TRANSACTION_ID
12805: ,NULL -- OLD_PARTY_SOURCE_TABLE
12806: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE
12807: ,NULL -- OLD_PARTY_ID
12808: ,v_party_id -- NEW_PARTY_ID
12809: ,NULL -- OLD_RELATIONSHIP_TYPE_CODE
12810: ,'OWNER' -- NEW_RELATIONSHIP_TYPE_CODE

Line 13054: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE

13050: ,-1 -- LAST_UPDATE_LOGIN
13051: ,1 -- OBJECT_VERSION_NUMBER
13052: ,NULL -- SECURITY_GROUP_ID
13053: ,'IN_INVENTORY' -- INSTANCE_USAGE_CODE
13054: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE
13055: ,v_party_id -- OWNER_PARTY_ID
13056: ,organization_id_mig(i) -- LAST_VLD_ORGANIZATION_ID
13057: );
13058: Exception

Line 13238: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE

13234: )
13235: VALUES(
13236: v_ins_party_id -- INSTANCE_PARTY_ID
13237: ,v_instance_id -- INSTANCE_ID
13238: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE
13239: ,v_party_id -- PARTY_ID
13240: ,'OWNER' -- RELATIONSHIP_TYPE_CODE
13241: ,'N' -- CONTACT_FLAG
13242: ,NULL -- CONTACT_IP_ID

Line 13300: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE

13296: v_ins_party_history_id -- INSTANCE_PARTY_HISTORY_ID
13297: ,v_ins_party_id -- INSTANCE_PARTY_ID
13298: ,v_txn_id -- TRANSACTION_ID
13299: ,NULL -- OLD_PARTY_SOURCE_TABLE
13300: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE
13301: ,NULL -- OLD_PARTY_ID
13302: ,v_party_id -- NEW_PARTY_ID
13303: ,NULL -- OLD_RELATIONSHIP_TYPE_CODE
13304: ,'OWNER' -- NEW_RELATIONSHIP_TYPE_CODE

Line 13527: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';

13523: l_instance_rec.active_end_date := sysdate;
13524:
13525: -- build internal party record
13526: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
13527: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
13528: l_parties_tbl(1).party_id := l_internal_party_id;
13529: l_parties_tbl(1).relationship_type_code := 'OWNER';
13530: l_parties_tbl(1).contact_flag := 'N';
13531: l_parties_tbl(1).object_version_number := 1.0;

Line 14079: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE

14075: ,-1 -- LAST_UPDATE_LOGIN
14076: ,1 -- OBJECT_VERSION_NUMBER
14077: ,NULL -- SECURITY_GROUP_ID
14078: ,'IN_INVENTORY' -- INSTANCE_USAGE_CODE
14079: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE
14080: ,v_party_id -- OWNER_PARTY_ID
14081: ,ORGANIZATION_ID_mig(i) -- LAST_VLD_ORGANIZATION_ID
14082: );
14083: Exception

Line 14287: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE

14283: )
14284: VALUES(
14285: v_ins_party_id -- INSTANCE_PARTY_ID
14286: ,v_instance_id -- INSTANCE_ID
14287: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE
14288: ,v_party_id -- PARTY_ID
14289: ,'OWNER' -- RELATIONSHIP_TYPE_CODE
14290: ,'N' -- CONTACT_FLAG
14291: ,NULL -- CONTACT_IP_ID

Line 14349: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE

14345: v_ins_party_history_id -- INSTANCE_PARTY_HISTORY_ID
14346: ,v_ins_party_id -- INSTANCE_PARTY_ID
14347: ,v_txn_id -- TRANSACTION_ID
14348: ,NULL -- OLD_PARTY_SOURCE_TABLE
14349: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE
14350: ,NULL -- OLD_PARTY_ID
14351: ,v_party_id -- NEW_PARTY_ID
14352: ,NULL -- OLD_RELATIONSHIP_TYPE_CODE
14353: ,'OWNER' -- NEW_RELATIONSHIP_TYPE_CODE

Line 15035: hz_parties

15031: inventory_revision ,
15032: owner_party_account_id account_id,
15033: owner_party_id party_id
15034: FROM csi_item_instances,
15035: hz_parties
15036: WHERE inventory_item_id = p_item_id
15037: AND owner_party_account_id = decode(p_chg_owner,'Y',owner_party_account_id,p_customer_id)
15038: AND instance_usage_code = 'OUT_OF_ENTERPRISE'
15039: AND nvl(lot_number,'$#$') = nvl(p_lot_number,'$#$')

Line 15072: hz_parties hp

15068: IF p_account_id is not null THEN
15069: SELECT hp.party_name
15070: INTO l_customer_name
15071: FROM hz_cust_accounts hca,
15072: hz_parties hp
15073: WHERE hca.cust_account_id = p_account_id
15074: AND hp.party_id = hca.party_id;
15075: ELSE
15076: IF p_party_id is not null THEN

Line 15079: FROM hz_parties

15075: ELSE
15076: IF p_party_id is not null THEN
15077: SELECT party_name
15078: INTO l_customer_name
15079: FROM hz_parties
15080: WHERE party_id = p_party_id;
15081: END IF;
15082: END IF;
15083:

Line 15536: l_pty_dtl_tbl(1).party_source_table := 'HZ_PARTIES';

15532:
15533: IF l_change_owner = 'Y' THEN
15534: l_pty_dtl_tbl(1).txn_party_detail_id := fnd_api.g_miss_num;
15535: l_pty_dtl_tbl(1).txn_line_detail_id := fnd_api.g_miss_num;
15536: l_pty_dtl_tbl(1).party_source_table := 'HZ_PARTIES';
15537: l_pty_dtl_tbl(1).party_source_id := l_internal_party_id;
15538: l_pty_dtl_tbl(1).relationship_type_code := 'OWNER';
15539: l_pty_dtl_tbl(1).contact_flag := 'N';
15540: l_pty_dtl_tbl(1).active_start_date := sysdate;