APPS.QA_PLAN_ELEMENT_API dependencies on QA_FLEX_UTIL

Line 3345: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3341:
3342: -- After Single Scan LOV
3343: wild := value;
3344:
3345: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3346:
3347: sql_string := 'SELECT uom_code, description
3348: FROM mtl_item_uoms_view
3349: WHERE inventory_item_id = :1

Line 3380: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3376:
3377: -- After Single Scan LOV
3378: wild := value;
3379:
3380: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3381:
3382: -- Bug 3595553. Modified the below query to join with msi to fetch
3383: -- revisions only if the item is revision controlled. All the items
3384: -- will have a base revision by default. But we want this sql to

Line 3420: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3416:
3417: -- After Single Scan LOV
3418: wild := value;
3419:
3420: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3421:
3422: sql_string := 'select lot_number, description
3423: from mtl_lot_numbers
3424: where inventory_item_id = :1

Line 3447: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

3443: BEGIN
3444:
3445: wild := value;
3446:
3447: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3448:
3449: -- Undoing Bug 3364660. Not needed after sync up with Bug 3773298
3450: -- l_trans_string := fnd_message.get_string('QA','QA_MOBILE_SERIAL_LOV_TXT');
3451: --

Line 4027: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

4023:
4024: -- After Single Scan LOV
4025: wild := value;
4026:
4027: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
4028:
4029: sql_string := 'SELECT cii.instance_number, cii.serial_number
4030: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
4031: WHERE cii.inventory_item_id = msik.inventory_item_id

Line 4060: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

4056:
4057: -- After Single Scan LOV
4058: wild := value;
4059:
4060: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
4061:
4062: sql_string := 'SELECT cii.serial_number, msik.concatenated_segments
4063: FROM qa_csi_item_instances cii, mtl_system_items_kfv msik
4064: WHERE cii.inventory_item_id = msik.inventory_item_id

Line 4339: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

4335:
4336: -- After Single Scan LOV
4337: wild := value;
4338:
4339: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
4340:
4341: -- Added the organization_id condition in the following select statement.
4342: -- Bug 2686970. suramasw Wed Nov 27 04:45:34 PST 2002.
4343:

Line 4402: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);

4398:
4399: -- After Single Scan LOV
4400: wild := value;
4401:
4402: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
4403:
4404: sql_string := 'SELECT mms.status_code, mms.description
4405: FROM mtl_serial_numbers msn, mtl_material_statuses mms
4406: WHERE msn.inventory_item_id = :1

Line 4690: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);

4686:
4687: BEGIN
4688:
4689: IF p_item_name IS NOT NULL THEN
4690: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
4691: END IF;
4692:
4693: IF p_job_name IS NOT NULL THEN
4694: l_job_id := get_job_id(p_org_id, p_job_name);

Line 5077: x_item_name := QA_FLEX_UTIL.item(l_org_id, l_item_id);

5073: OPEN c;
5074: FETCH c INTO l_org_id, l_item_id;
5075: CLOSE c;
5076:
5077: x_item_name := QA_FLEX_UTIL.item(l_org_id, l_item_id);
5078:
5079: END get_item_name;
5080:
5081: