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.OKL_PARTY_MERGE_PUB dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 519: , OKL_LEASE_OPPORTUNITIES_B LOP

515: , ASS.INSTALL_SITE_ID
516: , HPS.PARTY_SITE_ID
517: FROM OKL_ASSETS_B ASS
518: , OKL_LEASE_QUOTES_B LSQ
519: , OKL_LEASE_OPPORTUNITIES_B LOP
520: , HZ_PARTY_SITE_USES HPSU
521: , HZ_PARTY_SITES HPS
522: WHERE ASS.PARENT_OBJECT_CODE = 'LEASEQUOTE'
523: AND LSQ.ID = ASS.PARENT_OBJECT_ID

Line 3391: | Account merge procedure for the table, OKL_LEASE_OPPORTUNITIES_B

3387: /*-------------------------------------------------------------
3388: | PROCEDURE
3389: | LOP_ACCOUNT_MERGE
3390: | DESCRIPTION :
3391: | Account merge procedure for the table, OKL_LEASE_OPPORTUNITIES_B
3392: |
3393: | NOTES:
3394: |--------------------------------------------------------------*/
3395: PROCEDURE LOP_ACCOUNT_MERGE (

Line 3411: TYPE ID_LIST_TYPE IS TABLE OF OKL_LEASE_OPPORTUNITIES_B.ID%TYPE

3407: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE
3408: INDEX BY BINARY_INTEGER;
3409: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
3410:
3411: TYPE ID_LIST_TYPE IS TABLE OF OKL_LEASE_OPPORTUNITIES_B.ID%TYPE
3412: INDEX BY BINARY_INTEGER;
3413: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
3414:
3415: TYPE CUST_ACCT_ID_LIST_TYPE IS TABLE OF OKL_LEASE_OPPORTUNITIES_B.CUST_ACCT_ID%TYPE

Line 3415: TYPE CUST_ACCT_ID_LIST_TYPE IS TABLE OF OKL_LEASE_OPPORTUNITIES_B.CUST_ACCT_ID%TYPE

3411: TYPE ID_LIST_TYPE IS TABLE OF OKL_LEASE_OPPORTUNITIES_B.ID%TYPE
3412: INDEX BY BINARY_INTEGER;
3413: PRIMARY_KEY_ID_LIST ID_LIST_TYPE;
3414:
3415: TYPE CUST_ACCT_ID_LIST_TYPE IS TABLE OF OKL_LEASE_OPPORTUNITIES_B.CUST_ACCT_ID%TYPE
3416: INDEX BY BINARY_INTEGER;
3417: NUM_COL1_ORIG_LIST CUST_ACCT_ID_LIST_TYPE;
3418: NUM_COL1_NEW_LIST CUST_ACCT_ID_LIST_TYPE;
3419:

Line 3421: OKL_LEASE_OPPORTUNITIES_B.PROSPECT_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;

3417: NUM_COL1_ORIG_LIST CUST_ACCT_ID_LIST_TYPE;
3418: NUM_COL1_NEW_LIST CUST_ACCT_ID_LIST_TYPE;
3419:
3420: TYPE PROSPECT_ADDRESS_ID_LIST_TYPE IS TABLE OF
3421: OKL_LEASE_OPPORTUNITIES_B.PROSPECT_ADDRESS_ID%TYPE INDEX BY BINARY_INTEGER;
3422: PROSPECT_ADDRESS_ID_LIST PROSPECT_ADDRESS_ID_LIST_TYPE;
3423: PROSPECT_ADD_OLD_ID_LIST PROSPECT_ADDRESS_ID_LIST_TYPE;
3424:
3425: TYPE PROSPECT_ID_LIST_TYPE IS TABLE OF

Line 3426: OKL_LEASE_OPPORTUNITIES_B.PROSPECT_ID%TYPE INDEX BY BINARY_INTEGER;

3422: PROSPECT_ADDRESS_ID_LIST PROSPECT_ADDRESS_ID_LIST_TYPE;
3423: PROSPECT_ADD_OLD_ID_LIST PROSPECT_ADDRESS_ID_LIST_TYPE;
3424:
3425: TYPE PROSPECT_ID_LIST_TYPE IS TABLE OF
3426: OKL_LEASE_OPPORTUNITIES_B.PROSPECT_ID%TYPE INDEX BY BINARY_INTEGER;
3427: PROSPECT_ID_LIST PROSPECT_ID_LIST_TYPE;
3428: PROSPECT_OLD_ID_LIST PROSPECT_ID_LIST_TYPE;
3429:
3430: TYPE IS_ID_LIST_TYPE IS TABLE OF

Line 3431: OKL_LEASE_OPPORTUNITIES_B.INSTALL_SITE_ID%TYPE INDEX BY BINARY_INTEGER;

3427: PROSPECT_ID_LIST PROSPECT_ID_LIST_TYPE;
3428: PROSPECT_OLD_ID_LIST PROSPECT_ID_LIST_TYPE;
3429:
3430: TYPE IS_ID_LIST_TYPE IS TABLE OF
3431: OKL_LEASE_OPPORTUNITIES_B.INSTALL_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
3432: IS_ID_LIST IS_ID_LIST_TYPE;
3433: IS_OLD_ID_LIST IS_ID_LIST_TYPE;
3434:
3435: TYPE UL_ID_LIST_TYPE IS TABLE OF

Line 3436: OKL_LEASE_OPPORTUNITIES_B.USAGE_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

3432: IS_ID_LIST IS_ID_LIST_TYPE;
3433: IS_OLD_ID_LIST IS_ID_LIST_TYPE;
3434:
3435: TYPE UL_ID_LIST_TYPE IS TABLE OF
3436: OKL_LEASE_OPPORTUNITIES_B.USAGE_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
3437: UL_ID_LIST UL_ID_LIST_TYPE;
3438: UL_OLD_ID_LIST UL_ID_LIST_TYPE;
3439:
3440: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

Line 3448: FROM OKL_LEASE_OPPORTUNITIES_B yt, ra_customer_merges m

3444: CURSOR merged_records IS
3445: SELECT distinct CUSTOMER_MERGE_HEADER_ID
3446: , ID
3447: , CUST_ACCT_ID
3448: FROM OKL_LEASE_OPPORTUNITIES_B yt, ra_customer_merges m
3449: WHERE (yt.CUST_ACCT_ID = m.DUPLICATE_ID)
3450: AND m.process_flag = 'N'
3451: AND m.request_id = req_id
3452: AND m.set_number = set_num;

Line 3486: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_LEASE_OPPORTUNITIES_B',FALSE);

3482: IF process_mode='LOCK' THEN
3483: NULL;
3484: ELSE
3485: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
3486: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKL_LEASE_OPPORTUNITIES_B',FALSE);
3487: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3488: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3489:
3490: OPEN merged_records;

Line 3520: FROM OKL_LEASE_OPPORTUNITIES_B

3516: INTO PROSPECT_OLD_ID_LIST(I)
3517: , PROSPECT_ADD_OLD_ID_LIST(I)
3518: , IS_OLD_ID_LIST(I)
3519: , UL_OLD_ID_LIST(I)
3520: FROM OKL_LEASE_OPPORTUNITIES_B
3521: WHERE ID = PRIMARY_KEY_ID_LIST(I);
3522:
3523: IF(PROSPECT_ADD_OLD_ID_LIST(I) IS NOT NULL)
3524: THEN

Line 3845: 'OKL_LEASE_OPPORTUNITIES_B',

3841: LAST_UPDATE_DATE,
3842: LAST_UPDATED_BY)
3843: VALUES(
3844: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3845: 'OKL_LEASE_OPPORTUNITIES_B',
3846: MERGE_HEADER_ID_LIST(I),
3847: PRIMARY_KEY_ID_LIST(I),
3848: NUM_COL1_ORIG_LIST(I),
3849: NUM_COL1_NEW_LIST(I),

Line 3868: UPDATE OKL_LEASE_OPPORTUNITIES_B yt SET

3864: hz_utility_pub.LAST_UPDATED_BY);
3865: END IF;
3866:
3867: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3868: UPDATE OKL_LEASE_OPPORTUNITIES_B yt SET
3869: CUST_ACCT_ID=NUM_COL1_NEW_LIST(I)
3870: , PROSPECT_ID = PROSPECT_ID_LIST(I)
3871: , PROSPECT_ADDRESS_ID = PROSPECT_ADDRESS_ID_LIST(I)
3872: , INSTALL_SITE_ID = IS_ID_LIST(I)