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.INV_MWB_TREE dependencies on MTL_SERIAL_NUMBERS

Line 428: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

424: AND p_serial_attr_query IS NOT NULL THEN
425: query_str :=
426: query_str
427: || ' SELECT organization_id from'
428: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
429: || p_serial_attr_query
430: || ') msn, '
431: || table_required;
432: query_str := query_str || ' WHERE msn.serial_num = serial_number ';

Line 451: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

447: || ' SELECT organization_id from'
448: || ' (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
449: || p_lot_attr_query
450: || ' ) mln, '
451: || ' (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
452: || p_serial_attr_query
453: || ' ) msn, '
454: || table_required;
455: query_str := query_str || ' WHERE mln.lot_num = lot_number ';

Line 1119: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

1115: query_str := query_str || 'WHERE 1=1 ';
1116: ELSIF p_lot_attr_query IS NULL
1117: AND p_serial_attr_query IS NOT NULL THEN
1118: query_str :=
1119: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
1120: || ') msn ';
1121: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
1122: ELSIF p_lot_attr_query IS NOT NULL
1123: AND p_serial_attr_query IS NULL THEN

Line 1133: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

1129: query_str
1130: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
1131: || p_lot_attr_query
1132: || ') mln '
1133: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
1134: || p_serial_attr_query
1135: || ') msn ';
1136: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
1137: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 1632: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

1628: AND p_serial_attr_query IS NOT NULL THEN
1629: query_str :=
1630: query_str
1631: || 'SELECT organization_id from'
1632: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
1633: || p_serial_attr_query
1634: || ') msn, mtl_onhand_serial_v mos ';
1635: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
1636: ELSIF p_lot_attr_query IS NOT NULL

Line 1653: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

1649: || 'SELECT organization_id from'
1650: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
1651: || p_lot_attr_query
1652: || ') mln, '
1653: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
1654: || p_serial_attr_query
1655: || ') msn, mtl_onhand_serial_v mos ';
1656: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
1657: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 2269: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

2265: query_str := query_str || 'WHERE 1=1 ';
2266: ELSIF p_lot_attr_query IS NULL
2267: AND p_serial_attr_query IS NOT NULL THEN
2268: query_str :=
2269: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
2270: || ') msn ';
2271: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
2272: ELSIF p_lot_attr_query IS NOT NULL
2273: AND p_serial_attr_query IS NULL THEN

Line 2283: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2279: query_str
2280: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2281: || p_lot_attr_query
2282: || ') mln '
2283: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2284: || p_serial_attr_query
2285: || ') msn ';
2286: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
2287: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 2936: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2932: AND p_serial_attr_query IS NOT NULL THEN
2933: query_str :=
2934: query_str
2935: || 'SELECT subinventory_code from'
2936: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2937: || p_serial_attr_query
2938: || ') msn, '
2939: || table_required;
2940: query_str := query_str || 'WHERE msn.serial_num = serial_number ';

Line 2959: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

2955: || 'SELECT subinventory_code from'
2956: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
2957: || p_lot_attr_query
2958: || ') mln, '
2959: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
2960: || p_serial_attr_query
2961: || ') msn, '
2962: || table_required;
2963: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 3367: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

3363: query_str := query_str || 'WHERE 1=1 ';
3364: ELSIF p_lot_attr_query IS NULL
3365: AND p_serial_attr_query IS NOT NULL THEN
3366: query_str :=
3367: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
3368: || ') msn ';
3369: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
3370: ELSIF p_lot_attr_query IS NOT NULL
3371: AND p_serial_attr_query IS NULL THEN

Line 3381: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

3377: query_str
3378: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3379: || p_lot_attr_query
3380: || ') mln '
3381: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3382: || p_serial_attr_query
3383: || ') msn ';
3384: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
3385: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 3969: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

3965: AND p_serial_attr_query IS NOT NULL THEN
3966: query_str :=
3967: query_str
3968: || 'SELECT locator_id, locator from'
3969: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3970: || p_serial_attr_query
3971: || ') msn, '
3972: || table_required;
3973: query_str := query_str || 'WHERE msn.serial_num = serial_number ';

Line 3992: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

3988: || 'SELECT locator_id, locator from'
3989: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
3990: || p_lot_attr_query
3991: || ') mln, '
3992: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
3993: || p_serial_attr_query
3994: || ') msn, '
3995: || table_required;
3996: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 4366: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

4362: query_str := query_str || 'WHERE 1=1 ';
4363: ELSIF p_lot_attr_query IS NULL
4364: AND p_serial_attr_query IS NOT NULL THEN
4365: query_str :=
4366: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
4367: || ') msn ';
4368: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
4369: ELSIF p_lot_attr_query IS NOT NULL
4370: AND p_serial_attr_query IS NULL THEN

Line 4380: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

4376: query_str
4377: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4378: || p_lot_attr_query
4379: || ') mln '
4380: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4381: || p_serial_attr_query
4382: || ') msn ';
4383: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
4384: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 4933: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

4929: AND p_serial_attr_query IS NOT NULL THEN
4930: query_str :=
4931: query_str
4932: || 'SELECT DISTINCT mos.cost_group_id, ccg.cost_group from'
4933: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4934: || p_serial_attr_query
4935: || ') msn, cst_cost_groups ccg, '
4936: || table_required;
4937: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';

Line 4958: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

4954: || 'SELECT DISTINCT mos.cost_group_id, ccg.cost_group from'
4955: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
4956: || p_lot_attr_query
4957: || ') mln, '
4958: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
4959: || p_serial_attr_query
4960: || ') msn, cst_cost_groups ccg, '
4961: || table_required;
4962: query_str := query_str || 'WHERE ccg.cost_group_id = mos.cost_group_id ';

Line 5518: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

5514: query_str := query_str || 'WHERE 1=1 ';
5515: ELSIF p_lot_attr_query IS NULL
5516: AND p_serial_attr_query IS NOT NULL THEN
5517: query_str :=
5518: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
5519: || ') msn ';
5520: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
5521: ELSIF p_lot_attr_query IS NOT NULL
5522: AND p_serial_attr_query IS NULL THEN

Line 5532: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

5528: query_str
5529: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
5530: || p_lot_attr_query
5531: || ') mln '
5532: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
5533: || p_serial_attr_query
5534: || ') msn ';
5535: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
5536: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 6262: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

6258: query_str := query_str || 'WHERE 1=1 ';
6259: ELSIF p_lot_attr_query IS NULL
6260: AND p_serial_attr_query IS NOT NULL THEN
6261: query_str :=
6262: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
6263: || ') msn ';
6264: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
6265: ELSIF p_lot_attr_query IS NOT NULL
6266: AND p_serial_attr_query IS NULL THEN

Line 6276: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

6272: query_str
6273: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
6274: || p_lot_attr_query
6275: || ') mln '
6276: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6277: || p_serial_attr_query
6278: || ') msn ';
6279: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
6280: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 6974: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

6970: AND p_serial_attr_query IS NOT NULL THEN
6971: query_str :=
6972: query_str
6973: || 'SELECT DISTINCT inventory_item_id, item from'
6974: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6975: || p_serial_attr_query
6976: || ') msn, '
6977: || table_required;
6978: query_str := query_str || 'WHERE msn.serial_num = serial_number ';

Line 6997: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

6993: || 'SELECT DISTINCT inventory_item_id, item from'
6994: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
6995: || p_lot_attr_query
6996: || ') mln, '
6997: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
6998: || p_serial_attr_query
6999: || ') msn, '
7000: || table_required;
7001: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 7703: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

7699: query_str := query_str || 'WHERE 1=1 ';
7700: ELSIF p_lot_attr_query IS NULL
7701: AND p_serial_attr_query IS NOT NULL THEN
7702: query_str :=
7703: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
7704: || ') msn ';
7705: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
7706: ELSIF p_lot_attr_query IS NOT NULL
7707: AND p_serial_attr_query IS NULL THEN

Line 7717: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

7713: query_str
7714: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
7715: || p_lot_attr_query
7716: || ') mln '
7717: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
7718: || p_serial_attr_query
7719: || ') msn ';
7720: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
7721: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 8387: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

8383: AND p_serial_attr_query IS NOT NULL THEN
8384: query_str :=
8385: query_str
8386: || 'SELECT item, revision from'
8387: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8388: || p_serial_attr_query
8389: || ') msn, mtl_onhand_serial_v ';
8390: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
8391: ELSIF p_lot_attr_query IS NOT NULL

Line 8408: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

8404: || 'SELECT item, revision from'
8405: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8406: || p_lot_attr_query
8407: || ') mln, '
8408: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8409: || p_serial_attr_query
8410: || ') msn, mtl_onhand_serial_v ';
8411: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8412: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 8940: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

8936: query_str := query_str || 'WHERE 1=1 ';
8937: ELSIF p_lot_attr_query IS NULL
8938: AND p_serial_attr_query IS NOT NULL THEN
8939: query_str :=
8940: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
8941: || ') msn ';
8942: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
8943: ELSIF p_lot_attr_query IS NOT NULL
8944: AND p_serial_attr_query IS NULL THEN

Line 8954: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

8950: query_str
8951: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
8952: || p_lot_attr_query
8953: || ') mln '
8954: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
8955: || p_serial_attr_query
8956: || ') msn ';
8957: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
8958: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 9547: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

9543: AND p_serial_attr_query IS NOT NULL THEN
9544: query_str :=
9545: query_str
9546: || 'SELECT lot_number from'
9547: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9548: || p_serial_attr_query
9549: || ') msn, '
9550: || table_required;
9551: query_str := query_str || 'WHERE msn.serial_num = serial_number ';

Line 9570: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

9566: || 'SELECT lot_number from'
9567: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
9568: || p_lot_attr_query
9569: || ') mln, '
9570: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
9571: || p_serial_attr_query
9572: || ') msn, '
9573: || table_required;
9574: query_str := query_str || 'WHERE mln.lot_num = lot_number ';

Line 10066: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

10062: query_str := query_str || 'WHERE 1=1 ';
10063: ELSIF p_lot_attr_query IS NULL
10064: AND p_serial_attr_query IS NOT NULL THEN
10065: query_str :=
10066: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
10067: || ') msn ';
10068: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10069: ELSIF p_lot_attr_query IS NOT NULL
10070: AND p_serial_attr_query IS NULL THEN

Line 10080: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

10076: query_str
10077: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10078: || p_lot_attr_query
10079: || ') mln '
10080: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10081: || p_serial_attr_query
10082: || ') msn ';
10083: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10084: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 10463: serial mtl_serial_numbers.serial_number%TYPE;

10459: ) IS
10460: query_str VARCHAR2(10000);
10461: query_hdl NUMBER;
10462: rows_processed NUMBER;
10463: serial mtl_serial_numbers.serial_number%TYPE;
10464: serial_control NUMBER;
10465: i NUMBER := x_tbl_index;
10466: j NUMBER := x_node_value;
10467: table_required VARCHAR2(300);

Line 10515: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

10511: AND p_serial_attr_query IS NOT NULL THEN
10512: query_str :=
10513: query_str
10514: || 'SELECT serial_number from'
10515: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10516: || p_serial_attr_query
10517: || ') msn, '
10518: || table_required;
10519: query_str := query_str || 'WHERE msn.serial_num = serial_number ';

Line 10537: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

10533: || 'SELECT serial_number from'
10534: || '(SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10535: || p_lot_attr_query
10536: || ') mln, '
10537: || '(SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10538: || p_serial_attr_query
10539: || ') msn, mtl_onhand_serial_v ';
10540: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10541: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 10781: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query

10777: query_str := query_str || 'WHERE 1=1 ';
10778: ELSIF p_lot_attr_query IS NULL
10779: AND p_serial_attr_query IS NOT NULL THEN
10780: query_str :=
10781: query_str || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 ' || p_serial_attr_query
10782: || ') msn ';
10783: query_str := query_str || 'WHERE msn.serial_num = serial_number ';
10784: ELSIF p_lot_attr_query IS NOT NULL
10785: AND p_serial_attr_query IS NULL THEN

Line 10795: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '

10791: query_str
10792: || ', (SELECT lot_number lot_num FROM mtl_lot_numbers WHERE 1=1 '
10793: || p_lot_attr_query
10794: || ') mln '
10795: || ', (SELECT serial_number serial_num FROM mtl_serial_numbers WHERE 1=1 '
10796: || p_serial_attr_query
10797: || ') msn ';
10798: query_str := query_str || 'WHERE mln.lot_num = lot_number ';
10799: query_str := query_str || 'AND msn.serial_num = serial_number ';

Line 11793: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

11789: , fdfcu.application_column_name
11790: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
11791: WHERE fdfcu.application_id = fa.application_id
11792: AND fa.application_short_name = 'INV'
11793: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
11794: AND(
11795: fdfcu.descriptive_flex_context_code IN(
11796: SELECT fdfc.descriptive_flex_context_code
11797: FROM fnd_descr_flex_contexts_vl fdfc

Line 11799: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

11795: fdfcu.descriptive_flex_context_code IN(
11796: SELECT fdfc.descriptive_flex_context_code
11797: FROM fnd_descr_flex_contexts_vl fdfc
11798: WHERE fdfc.global_flag = 'Y'
11799: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
11800: AND fdfc.application_id = fa.application_id)
11801: OR fdfcu.descriptive_flex_context_code = p_msn_context_code
11802: )
11803: AND fdfcu.enabled_flag = 'Y'

Line 11819: -- Procedure to get the values populated in MTL_SERIAL_NUMBERS of the enabled segments

11815:
11816: x_return_status := fnd_api.g_ret_sts_success;
11817: END get_msn_attributes_structure;
11818:
11819: -- Procedure to get the values populated in MTL_SERIAL_NUMBERS of the enabled segments
11820: -- This procedure appends the entries to a table that has
11821: -- already been populated
11822: PROCEDURE get_msn_attributes(
11823: x_attribute_values IN OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

Line 11841: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

11837: , fdfcu.application_column_name
11838: FROM fnd_descr_flex_col_usage_vl fdfcu, fnd_application_vl fa
11839: WHERE fdfcu.application_id = fa.application_id
11840: AND fa.application_short_name = 'INV'
11841: AND fdfcu.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
11842: AND(
11843: fdfcu.descriptive_flex_context_code IN(
11844: SELECT fdfc.descriptive_flex_context_code
11845: FROM fnd_descr_flex_contexts_vl fdfc

Line 11847: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'

11843: fdfcu.descriptive_flex_context_code IN(
11844: SELECT fdfc.descriptive_flex_context_code
11845: FROM fnd_descr_flex_contexts_vl fdfc
11846: WHERE fdfc.global_flag = 'Y'
11847: AND fdfc.descriptive_flexfield_name = 'MTL_SERIAL_NUMBERS'
11848: AND fdfc.application_id = fa.application_id)
11849: OR fdfcu.descriptive_flex_context_code = p_msn_context_code
11850: )
11851: AND fdfcu.enabled_flag = 'Y'

Line 11854: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE

11850: )
11851: AND fdfcu.enabled_flag = 'Y'
11852: ORDER BY fdfcu.column_seq_num;
11853:
11854: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE
11855: INDEX BY BINARY_INTEGER;
11856:
11857: l_attribute l_attribute_type;
11858: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;

Line 11858: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;

11854: TYPE l_attribute_type IS TABLE OF mtl_serial_numbers.attribute1%TYPE
11855: INDEX BY BINARY_INTEGER;
11856:
11857: l_attribute l_attribute_type;
11858: l_msn_context_code mtl_serial_numbers.attribute_category%TYPE;
11859: BEGIN
11860: x_return_status := fnd_api.g_ret_sts_unexp_error;
11861:
11862: SELECT attribute1

Line 11894: FROM mtl_serial_numbers

11890: , l_attribute(13)
11891: , l_attribute(14)
11892: , l_attribute(15)
11893: , l_msn_context_code
11894: FROM mtl_serial_numbers
11895: WHERE inventory_item_id = p_inventory_item_id
11896: AND current_organization_id = p_organization_id
11897: AND serial_number = p_serial_number;
11898: