APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on IEX_DLN_UWQ_SUMMARY_S

Line 1643: IEX_DLN_UWQ_SUMMARY sum

1639: wkitem.escalated_yn --Added for bug#6981126 by schekuri on 27-Jul-2008
1640: from iex_strategies strat,
1641: iex_strategy_work_items wkitem,
1642: iex_stry_temp_work_items_b stry_temp_wkitem,
1643: IEX_DLN_UWQ_SUMMARY sum
1644: where strat.jtf_object_type = decode(p_level, 'CUSTOMER', 'PARTY', 'ACCOUNT', 'IEX_ACCOUNT', 'BILL_TO', 'IEX_BILLTO')
1645: AND strat.status_code IN('OPEN', 'ONHOLD')
1646: AND wkitem.strategy_id = strat.strategy_id
1647: AND wkitem.status_code IN('OPEN', 'ONHOLD')

Line 2804: (IEX_DLN_UWQ_SUMMARY_S.nextval,

2800: ,ACTIVE_PROMISES
2801: ,COMPLETE_PROMISES
2802: ,PENDING_PROMISES)
2803: VALUES
2804: (IEX_DLN_UWQ_SUMMARY_S.nextval,
2805: L_ORG_ID(i),
2806: L_COLLECTOR_ID(i),
2807: L_COLLECTOR_RESOURCE_ID(i),
2808: L_COLLECTOR_RES_TYPE(i),

Line 4066: (IEX_DLN_UWQ_SUMMARY_S.nextval,

4062: ,NUMBER_OF_DELINQUENCIES
4063: ,NUMBER_OF_PROMISES
4064: ,NUMBER_OF_BANKRUPTCIES)
4065: VALUES
4066: (IEX_DLN_UWQ_SUMMARY_S.nextval,
4067: L_ORG_ID(i),
4068: L_IEU_OBJECT_FUNCTION(i),
4069: L_IEU_OBJECT_PARAMETERS(i),
4070: L_IEU_MEDIA_TYPE_UUID(i),

Line 5292: (IEX_DLN_UWQ_SUMMARY_S.nextval,

5288: ,NUMBER_OF_DELINQUENCIES
5289: ,NUMBER_OF_PROMISES
5290: ,NUMBER_OF_BANKRUPTCIES)
5291: VALUES
5292: (IEX_DLN_UWQ_SUMMARY_S.nextval,
5293: L_ORG_ID(i),
5294: L_IEU_OBJECT_FUNCTION(i),
5295: L_IEU_OBJECT_PARAMETERS(i),
5296: L_IEU_MEDIA_TYPE_UUID(i),

Line 6513: (IEX_DLN_UWQ_SUMMARY_S.nextval,

6509: ,NUMBER_OF_DELINQUENCIES
6510: ,NUMBER_OF_PROMISES
6511: ,NUMBER_OF_BANKRUPTCIES)
6512: VALUES
6513: (IEX_DLN_UWQ_SUMMARY_S.nextval,
6514: L_ORG_ID(i),
6515: L_IEU_OBJECT_FUNCTION(i),
6516: L_IEU_OBJECT_PARAMETERS(i),
6517: L_IEU_MEDIA_TYPE_UUID(i),