APPS.QA_PLAN_ELEMENT_API dependencies on WIP_DISCRETE_JOBS

Line 1046: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of

1042:
1043: id NUMBER;
1044:
1045: -- #2382432
1046: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of
1047: -- earlier wip_open_discrete_jobs_val_v
1048: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
1049:
1050: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS

Line 1052: FROM wip_discrete_jobs_all_v

1048: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
1049:
1050: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1051: SELECT wip_entity_id
1052: FROM wip_discrete_jobs_all_v
1053: WHERE wip_entity_name = w_e_name
1054: AND organization_id = o_id;
1055:
1056: BEGIN

Line 1544: FROM wip_entities WE, wip_discrete_jobs WDJ

1540:
1541: /* rkaza 10/21/2002. Bug 2635736 */
1542: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1543: SELECT WDJ.wip_entity_id
1544: FROM wip_entities WE, wip_discrete_jobs WDJ
1545: WHERE WDJ.status_type in (3,4) and
1546: WDJ.wip_entity_id = WE.wip_entity_id and
1547: WE.entity_type IN (6, 7) and
1548: WE.wip_entity_name = w_e_name

Line 1719: FROM wip_discrete_jobs_all_v

1715: id NUMBER;
1716:
1717: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1718: SELECT wip_entity_id
1719: FROM wip_discrete_jobs_all_v
1720: WHERE wip_entity_name = w_e_name
1721: AND organization_id = o_id;
1722:
1723: BEGIN

Line 2664: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of

2660: wild := value;
2661:
2662:
2663: -- #2382432
2664: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of
2665: -- earlier wip_open_discrete_jobs_val_v
2666: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2667:
2668: sql_string := 'SELECT wip_entity_name, description

Line 2669: FROM wip_discrete_jobs_all_v

2665: -- earlier wip_open_discrete_jobs_val_v
2666: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2667:
2668: sql_string := 'SELECT wip_entity_name, description
2669: FROM wip_discrete_jobs_all_v
2670: WHERE wip_entity_name like :1 AND
2671: organization_id = :2
2672: ORDER BY wip_entity_name';
2673: OPEN x_ref FOR sql_string USING wild, org_id;

Line 2697: from wip_entities WE, wip_discrete_jobs WDJ

2693: wild := value;
2694:
2695: /* rkaza 10/21/2002. Bug 2635736 */
2696: sql_string := 'select WE.wip_entity_name, WDJ.description
2697: from wip_entities WE, wip_discrete_jobs WDJ
2698: where WDJ.organization_id = :1 and
2699: WDJ.status_type in (3,4) and
2700: WDJ.wip_entity_id = WE.wip_entity_id and
2701: WE.entity_type IN (6, 7) and

Line 3989: FROM wip_discrete_jobs_all_v

3985: -- After Single Scan LOV
3986: wild := value;
3987:
3988: sql_string := 'SELECT wip_entity_name, description
3989: FROM wip_discrete_jobs_all_v
3990: WHERE wip_entity_name like :1 AND
3991: organization_id = :2
3992: ORDER BY wip_entity_name';
3993: OPEN x_ref FOR sql_string USING wild, org_id;