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.OZF_RESALE_COMMON_PVT dependencies on DUAL

Line 2286: FROM dual

2282: WHERE resale_batch_id = p_resale_batch_id;
2283:
2284: CURSOR count_cust_acctid_csr(p_id NUMBER) IS
2285: SELECT 1
2286: FROM dual
2287: WHERE EXISTS (SELECT hca.cust_account_id
2288: FROM hz_cust_accounts hca
2289: WHERE hca.cust_account_id = p_id);
2290: --

Line 6808: FROM DUAL

6804: fund_id;
6805:
6806: CURSOR c_get_deal_accrual_flag(p_qp_list_header_id IN NUMBER, p_product_type IN VARCHAR2, p_product_id IN NUMBER) IS
6807: SELECT 1
6808: FROM DUAL
6809: WHERE EXISTS (SELECT 1
6810: FROM qp_list_lines line, qp_pricing_attributes attr
6811: WHERE attr.list_header_id = p_qp_list_header_id
6812: AND line.list_line_id = attr.list_line_id

Line 6834: FROM DUAL

6830:
6831:
6832: CURSOR ozf_vol_int_exists_csr IS
6833: SELECT 'Y'
6834: FROM DUAL
6835: WHERE EXISTS (SELECT 'Y' FROM
6836: OZF_VOLUME_SUMMARY_INT
6837: WHERE BATCH_TYPE='TP_ACCRUAL');
6838:

Line 6842: FROM DUAL

6838:
6839:
6840: CURSOR ozf_vol_int_exists_wp_csr(p_batch_id IN NUMBER) IS
6841: SELECT 'Y'
6842: FROM DUAL
6843: WHERE EXISTS (SELECT 'Y' FROM OZF_VOLUME_SUMMARY_INT
6844: WHERE BATCH_TYPE='TP_ACCRUAL'
6845: AND RESALE_BATCH_ID=p_batch_id );
6846:

Line 7217: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,

7213: );
7214:
7215:
7216: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7217: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7218: OFFER_ID,
7219: INDIVIDUAL_TYPE,
7220: PBH_LINE_ID
7221: FROM OZF_VOLUME_SUMMARY_INT

Line 7219: INDIVIDUAL_TYPE,

7215:
7216: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7217: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7218: OFFER_ID,
7219: INDIVIDUAL_TYPE,
7220: PBH_LINE_ID
7221: FROM OZF_VOLUME_SUMMARY_INT
7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint

Line 7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL

7218: OFFER_ID,
7219: INDIVIDUAL_TYPE,
7220: PBH_LINE_ID
7221: FROM OZF_VOLUME_SUMMARY_INT
7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7224: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7225: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7226: AND ovolsum.INDIVIDUAL_ID IS NULL

Line 7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint

7219: INDIVIDUAL_TYPE,
7220: PBH_LINE_ID
7221: FROM OZF_VOLUME_SUMMARY_INT
7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7224: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7225: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7226: AND ovolsum.INDIVIDUAL_ID IS NULL
7227: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)

Line 7225: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE

7221: FROM OZF_VOLUME_SUMMARY_INT
7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7224: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7225: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7226: AND ovolsum.INDIVIDUAL_ID IS NULL
7227: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7228: WHEN MATCHED THEN
7229: UPDATE

Line 7226: AND ovolsum.INDIVIDUAL_ID IS NULL

7222: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7223: GROUP BY OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7224: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7225: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7226: AND ovolsum.INDIVIDUAL_ID IS NULL
7227: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7228: WHEN MATCHED THEN
7229: UPDATE
7230: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),

Line 7230: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),

7226: AND ovolsum.INDIVIDUAL_ID IS NULL
7227: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7228: WHEN MATCHED THEN
7229: UPDATE
7230: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7231: LAST_UPDATE_DATE = SYSDATE,
7232: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7233: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7234: WHEN NOT MATCHED THEN

Line 7244: ,ovolsum.individual_type

7240: ,ovolsum.last_update_date
7241: ,ovolsum.last_updated_by
7242: ,ovolsum.last_update_login
7243: ,ovolsum.offer_id
7244: ,ovolsum.individual_type
7245: ,ovolsum.individual_volume
7246: ,ovolsum.pbh_line_id
7247: )
7248: VALUES

Line 7245: ,ovolsum.individual_volume

7241: ,ovolsum.last_updated_by
7242: ,ovolsum.last_update_login
7243: ,ovolsum.offer_id
7244: ,ovolsum.individual_type
7245: ,ovolsum.individual_volume
7246: ,ovolsum.pbh_line_id
7247: )
7248: VALUES
7249: (

Line 7257: ,ovolindint.INDIVIDUAL_TYPE

7253: ,SYSDATE
7254: ,FND_GLOBAL.user_id
7255: ,FND_GLOBAL.conc_login_id
7256: ,ovolindint.OFFER_ID
7257: ,ovolindint.INDIVIDUAL_TYPE
7258: ,ovolindint.INDIVIDUAL_VOLUME
7259: ,ovolindint.PBH_LINE_ID
7260: );
7261:

Line 7258: ,ovolindint.INDIVIDUAL_VOLUME

7254: ,FND_GLOBAL.user_id
7255: ,FND_GLOBAL.conc_login_id
7256: ,ovolindint.OFFER_ID
7257: ,ovolindint.INDIVIDUAL_TYPE
7258: ,ovolindint.INDIVIDUAL_VOLUME
7259: ,ovolindint.PBH_LINE_ID
7260: );
7261:
7262: MERGE INTO OZF_VOLUME_SUMMARY ovolsum

Line 7263: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,

7259: ,ovolindint.PBH_LINE_ID
7260: );
7261:
7262: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7263: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7264: OFFER_ID,
7265: INDIVIDUAL_TYPE,
7266: INDIVIDUAL_ID,
7267: PBH_LINE_ID

Line 7265: INDIVIDUAL_TYPE,

7261:
7262: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7263: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7264: OFFER_ID,
7265: INDIVIDUAL_TYPE,
7266: INDIVIDUAL_ID,
7267: PBH_LINE_ID
7268: FROM OZF_VOLUME_SUMMARY_INT
7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL

Line 7266: INDIVIDUAL_ID,

7262: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7263: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7264: OFFER_ID,
7265: INDIVIDUAL_TYPE,
7266: INDIVIDUAL_ID,
7267: PBH_LINE_ID
7268: FROM OZF_VOLUME_SUMMARY_INT
7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint

Line 7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL

7265: INDIVIDUAL_TYPE,
7266: INDIVIDUAL_ID,
7267: PBH_LINE_ID
7268: FROM OZF_VOLUME_SUMMARY_INT
7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7271: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7272: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7273: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID

Line 7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint

7266: INDIVIDUAL_ID,
7267: PBH_LINE_ID
7268: FROM OZF_VOLUME_SUMMARY_INT
7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7271: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7272: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7273: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7274: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)

Line 7272: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE

7268: FROM OZF_VOLUME_SUMMARY_INT
7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7271: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7272: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7273: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7274: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7275: WHEN MATCHED THEN
7276: UPDATE

Line 7273: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID

7269: WHERE INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7270: GROUP BY OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7271: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7272: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7273: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7274: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7275: WHEN MATCHED THEN
7276: UPDATE
7277: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),

Line 7277: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),

7273: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7274: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7275: WHEN MATCHED THEN
7276: UPDATE
7277: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7278: LAST_UPDATE_DATE = SYSDATE,
7279: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7280: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7281: WHEN NOT MATCHED THEN

Line 7291: ,ovolsum.individual_type

7287: ,ovolsum.last_update_date
7288: ,ovolsum.last_updated_by
7289: ,ovolsum.last_update_login
7290: ,ovolsum.offer_id
7291: ,ovolsum.individual_type
7292: ,ovolsum.individual_id
7293: ,ovolsum.individual_volume
7294: ,ovolsum.pbh_line_id
7295: )

Line 7292: ,ovolsum.individual_id

7288: ,ovolsum.last_updated_by
7289: ,ovolsum.last_update_login
7290: ,ovolsum.offer_id
7291: ,ovolsum.individual_type
7292: ,ovolsum.individual_id
7293: ,ovolsum.individual_volume
7294: ,ovolsum.pbh_line_id
7295: )
7296: VALUES

Line 7293: ,ovolsum.individual_volume

7289: ,ovolsum.last_update_login
7290: ,ovolsum.offer_id
7291: ,ovolsum.individual_type
7292: ,ovolsum.individual_id
7293: ,ovolsum.individual_volume
7294: ,ovolsum.pbh_line_id
7295: )
7296: VALUES
7297: (

Line 7305: ,ovolindint.INDIVIDUAL_TYPE

7301: ,SYSDATE
7302: ,FND_GLOBAL.user_id
7303: ,FND_GLOBAL.conc_login_id
7304: ,ovolindint.OFFER_ID
7305: ,ovolindint.INDIVIDUAL_TYPE
7306: ,ovolindint.INDIVIDUAL_ID
7307: ,ovolindint.INDIVIDUAL_VOLUME
7308: ,ovolindint.PBH_LINE_ID
7309: );

Line 7306: ,ovolindint.INDIVIDUAL_ID

7302: ,FND_GLOBAL.user_id
7303: ,FND_GLOBAL.conc_login_id
7304: ,ovolindint.OFFER_ID
7305: ,ovolindint.INDIVIDUAL_TYPE
7306: ,ovolindint.INDIVIDUAL_ID
7307: ,ovolindint.INDIVIDUAL_VOLUME
7308: ,ovolindint.PBH_LINE_ID
7309: );
7310:

Line 7307: ,ovolindint.INDIVIDUAL_VOLUME

7303: ,FND_GLOBAL.conc_login_id
7304: ,ovolindint.OFFER_ID
7305: ,ovolindint.INDIVIDUAL_TYPE
7306: ,ovolindint.INDIVIDUAL_ID
7307: ,ovolindint.INDIVIDUAL_VOLUME
7308: ,ovolindint.PBH_LINE_ID
7309: );
7310:
7311:

Line 7720: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,

7716:
7717:
7718:
7719: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7720: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7721: OFFER_ID,
7722: INDIVIDUAL_TYPE,
7723: PBH_LINE_ID ,
7724: RESALE_BATCH_ID

Line 7722: INDIVIDUAL_TYPE,

7718:
7719: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7720: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7721: OFFER_ID,
7722: INDIVIDUAL_TYPE,
7723: PBH_LINE_ID ,
7724: RESALE_BATCH_ID
7725: FROM OZF_VOLUME_SUMMARY_INT
7726: WHERE RESALE_BATCH_ID=p_batch_id

Line 7727: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL

7723: PBH_LINE_ID ,
7724: RESALE_BATCH_ID
7725: FROM OZF_VOLUME_SUMMARY_INT
7726: WHERE RESALE_BATCH_ID=p_batch_id
7727: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7728: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7729: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7730: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7731: AND ovolsum.INDIVIDUAL_ID IS NULL

Line 7728: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint

7724: RESALE_BATCH_ID
7725: FROM OZF_VOLUME_SUMMARY_INT
7726: WHERE RESALE_BATCH_ID=p_batch_id
7727: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7728: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7729: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7730: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7731: AND ovolsum.INDIVIDUAL_ID IS NULL
7732: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)

Line 7730: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE

7726: WHERE RESALE_BATCH_ID=p_batch_id
7727: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7728: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7729: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7730: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7731: AND ovolsum.INDIVIDUAL_ID IS NULL
7732: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7733: WHEN MATCHED THEN
7734: UPDATE

Line 7731: AND ovolsum.INDIVIDUAL_ID IS NULL

7727: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NULL
7728: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE, PBH_LINE_ID) ovolindint
7729: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7730: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7731: AND ovolsum.INDIVIDUAL_ID IS NULL
7732: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7733: WHEN MATCHED THEN
7734: UPDATE
7735: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),

Line 7735: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),

7731: AND ovolsum.INDIVIDUAL_ID IS NULL
7732: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7733: WHEN MATCHED THEN
7734: UPDATE
7735: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME + nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7736: LAST_UPDATE_DATE = SYSDATE,
7737: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7738: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7739: WHEN NOT MATCHED THEN

Line 7749: ,ovolsum.individual_type

7745: ,ovolsum.last_update_date
7746: ,ovolsum.last_updated_by
7747: ,ovolsum.last_update_login
7748: ,ovolsum.offer_id
7749: ,ovolsum.individual_type
7750: ,ovolsum.individual_volume
7751: ,ovolsum.pbh_line_id
7752: )
7753: VALUES

Line 7750: ,ovolsum.individual_volume

7746: ,ovolsum.last_updated_by
7747: ,ovolsum.last_update_login
7748: ,ovolsum.offer_id
7749: ,ovolsum.individual_type
7750: ,ovolsum.individual_volume
7751: ,ovolsum.pbh_line_id
7752: )
7753: VALUES
7754: (

Line 7762: ,ovolindint.INDIVIDUAL_TYPE

7758: ,SYSDATE
7759: ,FND_GLOBAL.user_id
7760: ,FND_GLOBAL.conc_login_id
7761: ,ovolindint.OFFER_ID
7762: ,ovolindint.INDIVIDUAL_TYPE
7763: ,ovolindint.INDIVIDUAL_VOLUME
7764: ,ovolindint.PBH_LINE_ID
7765: );
7766:

Line 7763: ,ovolindint.INDIVIDUAL_VOLUME

7759: ,FND_GLOBAL.user_id
7760: ,FND_GLOBAL.conc_login_id
7761: ,ovolindint.OFFER_ID
7762: ,ovolindint.INDIVIDUAL_TYPE
7763: ,ovolindint.INDIVIDUAL_VOLUME
7764: ,ovolindint.PBH_LINE_ID
7765: );
7766:
7767:

Line 7769: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,

7765: );
7766:
7767:
7768: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7769: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7770: OFFER_ID,
7771: INDIVIDUAL_TYPE,
7772: INDIVIDUAL_ID,
7773: PBH_LINE_ID ,

Line 7771: INDIVIDUAL_TYPE,

7767:
7768: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7769: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7770: OFFER_ID,
7771: INDIVIDUAL_TYPE,
7772: INDIVIDUAL_ID,
7773: PBH_LINE_ID ,
7774: RESALE_BATCH_ID
7775: FROM OZF_VOLUME_SUMMARY_INT

Line 7772: INDIVIDUAL_ID,

7768: MERGE INTO OZF_VOLUME_SUMMARY ovolsum
7769: USING (SELECT SUM (INDIVIDUAL_VOLUME) INDIVIDUAL_VOLUME ,
7770: OFFER_ID,
7771: INDIVIDUAL_TYPE,
7772: INDIVIDUAL_ID,
7773: PBH_LINE_ID ,
7774: RESALE_BATCH_ID
7775: FROM OZF_VOLUME_SUMMARY_INT
7776: WHERE RESALE_BATCH_ID=p_batch_id

Line 7777: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL

7773: PBH_LINE_ID ,
7774: RESALE_BATCH_ID
7775: FROM OZF_VOLUME_SUMMARY_INT
7776: WHERE RESALE_BATCH_ID=p_batch_id
7777: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7778: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7779: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7780: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7781: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID

Line 7778: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint

7774: RESALE_BATCH_ID
7775: FROM OZF_VOLUME_SUMMARY_INT
7776: WHERE RESALE_BATCH_ID=p_batch_id
7777: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7778: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7779: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7780: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7781: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7782: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)

Line 7780: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE

7776: WHERE RESALE_BATCH_ID=p_batch_id
7777: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7778: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7779: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7780: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7781: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7782: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7783: WHEN MATCHED THEN
7784: UPDATE

Line 7781: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID

7777: AND INDIVIDUAL_TYPE IS NOT NULL AND INDIVIDUAL_ID IS NOT NULL
7778: GROUP BY RESALE_BATCH_ID, OFFER_ID, INDIVIDUAL_TYPE,INDIVIDUAL_ID, PBH_LINE_ID) ovolindint
7779: ON (ovolsum.OFFER_ID= ovolindint.OFFER_ID
7780: AND ovolsum.INDIVIDUAL_TYPE = ovolindint.INDIVIDUAL_TYPE
7781: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7782: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7783: WHEN MATCHED THEN
7784: UPDATE
7785: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),

Line 7785: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),

7781: AND ovolsum.INDIVIDUAL_ID = ovolindint.INDIVIDUAL_ID
7782: AND ovolsum.PBH_LINE_ID= ovolindint.PBH_LINE_ID)
7783: WHEN MATCHED THEN
7784: UPDATE
7785: SET ovolsum.INDIVIDUAL_VOLUME = ovolsum.INDIVIDUAL_VOLUME+ nvl(ovolindint.INDIVIDUAL_VOLUME,0),
7786: LAST_UPDATE_DATE = SYSDATE,
7787: LAST_UPDATED_BY = FND_GLOBAL.user_id,
7788: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id
7789: WHEN NOT MATCHED THEN

Line 7799: ,ovolsum.individual_type

7795: ,ovolsum.last_update_date
7796: ,ovolsum.last_updated_by
7797: ,ovolsum.last_update_login
7798: ,ovolsum.offer_id
7799: ,ovolsum.individual_type
7800: ,ovolsum.individual_id
7801: ,ovolsum.individual_volume
7802: ,ovolsum.pbh_line_id
7803: )

Line 7800: ,ovolsum.individual_id

7796: ,ovolsum.last_updated_by
7797: ,ovolsum.last_update_login
7798: ,ovolsum.offer_id
7799: ,ovolsum.individual_type
7800: ,ovolsum.individual_id
7801: ,ovolsum.individual_volume
7802: ,ovolsum.pbh_line_id
7803: )
7804: VALUES

Line 7801: ,ovolsum.individual_volume

7797: ,ovolsum.last_update_login
7798: ,ovolsum.offer_id
7799: ,ovolsum.individual_type
7800: ,ovolsum.individual_id
7801: ,ovolsum.individual_volume
7802: ,ovolsum.pbh_line_id
7803: )
7804: VALUES
7805: (

Line 7813: ,ovolindint.INDIVIDUAL_TYPE

7809: ,SYSDATE
7810: ,FND_GLOBAL.user_id
7811: ,FND_GLOBAL.conc_login_id
7812: ,ovolindint.OFFER_ID
7813: ,ovolindint.INDIVIDUAL_TYPE
7814: ,ovolindint.INDIVIDUAL_ID
7815: ,ovolindint.INDIVIDUAL_VOLUME
7816: ,ovolindint.PBH_LINE_ID
7817: );

Line 7814: ,ovolindint.INDIVIDUAL_ID

7810: ,FND_GLOBAL.user_id
7811: ,FND_GLOBAL.conc_login_id
7812: ,ovolindint.OFFER_ID
7813: ,ovolindint.INDIVIDUAL_TYPE
7814: ,ovolindint.INDIVIDUAL_ID
7815: ,ovolindint.INDIVIDUAL_VOLUME
7816: ,ovolindint.PBH_LINE_ID
7817: );
7818:

Line 7815: ,ovolindint.INDIVIDUAL_VOLUME

7811: ,FND_GLOBAL.conc_login_id
7812: ,ovolindint.OFFER_ID
7813: ,ovolindint.INDIVIDUAL_TYPE
7814: ,ovolindint.INDIVIDUAL_ID
7815: ,ovolindint.INDIVIDUAL_VOLUME
7816: ,ovolindint.PBH_LINE_ID
7817: );
7818:
7819:

Line 7941: SELECT OZF_FUNDS_UTILIZED_DRAFT_ALL_S.NEXTVAL FROM DUAL;

7937: WHERE org.set_of_books_id = gs.set_of_books_id
7938: AND org.org_id = p_org_id;
7939:
7940: CURSOR draft_utilization_id_csr IS
7941: SELECT OZF_FUNDS_UTILIZED_DRAFT_ALL_S.NEXTVAL FROM DUAL;
7942:
7943: l_acctd_amount NUMBER ;
7944: l_mrc_sob_type_code VARCHAR2(50); -- not populating in draft table
7945: l_fc_currency_code VARCHAR2(50); -- functional currency code -- not populating in draft table