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 12563: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE

12559: ,-1 -- LAST_UPDATE_LOGIN
12560: ,1 -- OBJECT_VERSION_NUMBER
12561: ,NULL -- SECURITY_GROUP_ID
12562: ,'IN_INVENTORY' -- INSTANCE_USAGE_CODE
12563: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE
12564: ,v_party_id -- OWNER_PARTY_ID
12565: ,organization_id_mig(i) -- LAST_VLD_ORGANIZATION_ID
12566: );
12567: Exception

Line 12739: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE

12735: )
12736: VALUES(
12737: v_ins_party_id -- INSTANCE_PARTY_ID
12738: ,v_instance_id -- INSTANCE_ID
12739: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE
12740: ,v_party_id -- PARTY_ID
12741: ,'OWNER' -- RELATIONSHIP_TYPE_CODE
12742: ,'N' -- CONTACT_FLAG
12743: ,NULL -- CONTACT_IP_ID

Line 12801: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE

12797: v_ins_party_history_id -- INSTANCE_PARTY_HISTORY_ID
12798: ,v_ins_party_id -- INSTANCE_PARTY_ID
12799: ,v_txn_id -- TRANSACTION_ID
12800: ,NULL -- OLD_PARTY_SOURCE_TABLE
12801: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE
12802: ,NULL -- OLD_PARTY_ID
12803: ,v_party_id -- NEW_PARTY_ID
12804: ,NULL -- OLD_RELATIONSHIP_TYPE_CODE
12805: ,'OWNER' -- NEW_RELATIONSHIP_TYPE_CODE

Line 13049: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE

13045: ,-1 -- LAST_UPDATE_LOGIN
13046: ,1 -- OBJECT_VERSION_NUMBER
13047: ,NULL -- SECURITY_GROUP_ID
13048: ,'IN_INVENTORY' -- INSTANCE_USAGE_CODE
13049: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE
13050: ,v_party_id -- OWNER_PARTY_ID
13051: ,organization_id_mig(i) -- LAST_VLD_ORGANIZATION_ID
13052: );
13053: Exception

Line 13233: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE

13229: )
13230: VALUES(
13231: v_ins_party_id -- INSTANCE_PARTY_ID
13232: ,v_instance_id -- INSTANCE_ID
13233: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE
13234: ,v_party_id -- PARTY_ID
13235: ,'OWNER' -- RELATIONSHIP_TYPE_CODE
13236: ,'N' -- CONTACT_FLAG
13237: ,NULL -- CONTACT_IP_ID

Line 13295: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE

13291: v_ins_party_history_id -- INSTANCE_PARTY_HISTORY_ID
13292: ,v_ins_party_id -- INSTANCE_PARTY_ID
13293: ,v_txn_id -- TRANSACTION_ID
13294: ,NULL -- OLD_PARTY_SOURCE_TABLE
13295: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE
13296: ,NULL -- OLD_PARTY_ID
13297: ,v_party_id -- NEW_PARTY_ID
13298: ,NULL -- OLD_RELATIONSHIP_TYPE_CODE
13299: ,'OWNER' -- NEW_RELATIONSHIP_TYPE_CODE

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

13518: l_instance_rec.active_end_date := sysdate;
13519:
13520: -- build internal party record
13521: l_parties_tbl(1).instance_party_id := fnd_api.g_miss_num;
13522: l_parties_tbl(1).party_source_table := 'HZ_PARTIES';
13523: l_parties_tbl(1).party_id := l_internal_party_id;
13524: l_parties_tbl(1).relationship_type_code := 'OWNER';
13525: l_parties_tbl(1).contact_flag := 'N';
13526: l_parties_tbl(1).object_version_number := 1.0;

Line 14074: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE

14070: ,-1 -- LAST_UPDATE_LOGIN
14071: ,1 -- OBJECT_VERSION_NUMBER
14072: ,NULL -- SECURITY_GROUP_ID
14073: ,'IN_INVENTORY' -- INSTANCE_USAGE_CODE
14074: ,'HZ_PARTIES' -- OWNER_PARTY_SOURCE_TABLE
14075: ,v_party_id -- OWNER_PARTY_ID
14076: ,ORGANIZATION_ID_mig(i) -- LAST_VLD_ORGANIZATION_ID
14077: );
14078: Exception

Line 14282: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE

14278: )
14279: VALUES(
14280: v_ins_party_id -- INSTANCE_PARTY_ID
14281: ,v_instance_id -- INSTANCE_ID
14282: ,'HZ_PARTIES' -- PARTY_SOURCE_TABLE
14283: ,v_party_id -- PARTY_ID
14284: ,'OWNER' -- RELATIONSHIP_TYPE_CODE
14285: ,'N' -- CONTACT_FLAG
14286: ,NULL -- CONTACT_IP_ID

Line 14344: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE

14340: v_ins_party_history_id -- INSTANCE_PARTY_HISTORY_ID
14341: ,v_ins_party_id -- INSTANCE_PARTY_ID
14342: ,v_txn_id -- TRANSACTION_ID
14343: ,NULL -- OLD_PARTY_SOURCE_TABLE
14344: ,'HZ_PARTIES' -- NEW_PARTY_SOURCE_TABLE
14345: ,NULL -- OLD_PARTY_ID
14346: ,v_party_id -- NEW_PARTY_ID
14347: ,NULL -- OLD_RELATIONSHIP_TYPE_CODE
14348: ,'OWNER' -- NEW_RELATIONSHIP_TYPE_CODE

Line 15024: hz_parties

15020: inventory_revision ,
15021: owner_party_account_id account_id,
15022: owner_party_id party_id
15023: FROM csi_item_instances,
15024: hz_parties
15025: WHERE inventory_item_id = p_item_id
15026: AND owner_party_account_id = decode(p_chg_owner,'Y',owner_party_account_id,p_customer_id)
15027: AND instance_usage_code = 'OUT_OF_ENTERPRISE'
15028: AND nvl(lot_number,'$#$') = nvl(p_lot_number,'$#$')

Line 15061: hz_parties hp

15057: IF p_account_id is not null THEN
15058: SELECT hp.party_name
15059: INTO l_customer_name
15060: FROM hz_cust_accounts hca,
15061: hz_parties hp
15062: WHERE hca.cust_account_id = p_account_id
15063: AND hp.party_id = hca.party_id;
15064: ELSE
15065: IF p_party_id is not null THEN

Line 15068: FROM hz_parties

15064: ELSE
15065: IF p_party_id is not null THEN
15066: SELECT party_name
15067: INTO l_customer_name
15068: FROM hz_parties
15069: WHERE party_id = p_party_id;
15070: END IF;
15071: END IF;
15072:

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

15521:
15522: IF l_change_owner = 'Y' THEN
15523: l_pty_dtl_tbl(1).txn_party_detail_id := fnd_api.g_miss_num;
15524: l_pty_dtl_tbl(1).txn_line_detail_id := fnd_api.g_miss_num;
15525: l_pty_dtl_tbl(1).party_source_table := 'HZ_PARTIES';
15526: l_pty_dtl_tbl(1).party_source_id := l_internal_party_id;
15527: l_pty_dtl_tbl(1).relationship_type_code := 'OWNER';
15528: l_pty_dtl_tbl(1).contact_flag := 'N';
15529: l_pty_dtl_tbl(1).active_start_date := sysdate;