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 1563: FROM wip_entities WE, wip_discrete_jobs WDJ

1559:
1560: /* rkaza 10/21/2002. Bug 2635736 */
1561: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1562: SELECT WDJ.wip_entity_id
1563: FROM wip_entities WE, wip_discrete_jobs WDJ
1564: WHERE WDJ.status_type in (3,4) and
1565: WDJ.wip_entity_id = WE.wip_entity_id and
1566: WE.entity_type IN (6, 7) and
1567: WE.wip_entity_name = w_e_name

Line 1738: FROM wip_discrete_jobs_all_v

1734: id NUMBER;
1735:
1736: CURSOR c (w_e_name VARCHAR2, o_id NUMBER) IS
1737: SELECT wip_entity_id
1738: FROM wip_discrete_jobs_all_v
1739: WHERE wip_entity_name = w_e_name
1740: AND organization_id = o_id;
1741:
1742: BEGIN

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

2684: wild := value;
2685:
2686:
2687: -- #2382432
2688: -- Changed the view to WIP_DISCRETE_JOBS_ALL_V instead of
2689: -- earlier wip_open_discrete_jobs_val_v
2690: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2691:
2692: sql_string := 'SELECT wip_entity_name, description

Line 2693: FROM wip_discrete_jobs_all_v

2689: -- earlier wip_open_discrete_jobs_val_v
2690: -- rkunchal Sun Jun 30 22:59:11 PDT 2002
2691:
2692: sql_string := 'SELECT wip_entity_name, description
2693: FROM wip_discrete_jobs_all_v
2694: WHERE wip_entity_name like :1 AND
2695: organization_id = :2
2696: ORDER BY wip_entity_name';
2697: OPEN x_ref FOR sql_string USING wild, org_id;

Line 2721: from wip_entities WE, wip_discrete_jobs WDJ

2717: wild := value;
2718:
2719: /* rkaza 10/21/2002. Bug 2635736 */
2720: sql_string := 'select WE.wip_entity_name, WDJ.description
2721: from wip_entities WE, wip_discrete_jobs WDJ
2722: where WDJ.organization_id = :1 and
2723: WDJ.status_type in (3,4) and
2724: WDJ.wip_entity_id = WE.wip_entity_id and
2725: WE.entity_type IN (6, 7) and

Line 4187: FROM wip_discrete_jobs_all_v

4183: -- After Single Scan LOV
4184: wild := value;
4185:
4186: sql_string := 'SELECT wip_entity_name, description
4187: FROM wip_discrete_jobs_all_v
4188: WHERE wip_entity_name like :1 AND
4189: organization_id = :2
4190: ORDER BY wip_entity_name';
4191: OPEN x_ref FOR sql_string USING wild, org_id;