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

Line 314: mtl_serial_numbers msn

310: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
311: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
312: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
313: from wsm_serial_txn_interface wsti,
314: mtl_serial_numbers msn
315: where header_id = p_header_id
316: and transaction_type_id = 1
317: and wsti.serial_number = msn.serial_number (+)
318: and msn.inventory_item_id (+) = p_inventory_item_id

Line 866: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

862: l_qty_run NUMBER;
863: l_qty_tomove NUMBER;
864: l_qty NUMBER;
865: l_op_seq_num NUMBER;
866: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
867:
868: -- Logging variables.....
869: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
870: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 977: from mtl_serial_numbers

973: SELECT count(*)
974: into l_serial_num_count
975: -- ST : Fix for bug 4910758 (remove usage of wsm_job_serial_numbers_v)
976: -- from wsm_job_serial_numbers_v
977: from mtl_serial_numbers
978: where wip_entity_id = p_wip_entity_id
979: and inventory_item_id = p_item_id
980: and current_organization_id = p_organization_id;
981:

Line 1297: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

1293: x_error_count OUT NOCOPY NUMBER
1294: )
1295:
1296: IS
1297: l_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
1298:
1299: l_return_code NUMBER;
1300: l_quantity NUMBER;
1301:

Line 1404: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',

1400: IF (g_wms_installed=1 AND
1401: inv_lot_sel_attr.is_enabled( 'Serial Attributes',
1402: p_organization_id,
1403: p_inventory_item_id) >= 2) OR
1404: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',
1405: 'INV',
1406: p_organization_id,
1407: p_inventory_item_id) = 1 ) THEN
1408:

Line 1653: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',

1649: IF (g_wms_installed=1 AND
1650: inv_lot_sel_attr.is_enabled( 'Serial Attributes',
1651: p_organization_id,
1652: p_inventory_item_id) >= 2) OR
1653: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',
1654: 'INV',
1655: p_organization_id,
1656: p_inventory_item_id) = 1 ) THEN
1657:

Line 1851: from mtl_serial_numbers

1847: l_current_status,
1848: l_last_txn_srcid,
1849: l_last_txn_src_typid,
1850: l_gen_object_id
1851: from mtl_serial_numbers
1852: where inventory_item_id = p_assembly_item_id
1853: and current_organization_id = p_organization_id
1854: and serial_number = p_serial_number;
1855:

Line 1880: mtl_serial_numbers msn

1876:
1877: select count(1)
1878: into l_exists
1879: from mtl_object_genealogy mog,
1880: mtl_serial_numbers msn
1881: where mog.object_id = l_gen_object_id
1882: and mog.parent_object_type = 2
1883: and mog.parent_object_id = msn.gen_object_id
1884: and msn.inventory_item_id = p_assembly_item_id

Line 2039: l_ser_context MTL_SERIAL_NUMBERS.serial_attribute_category%type;

2035:
2036: l_update_serial_attr NUMBER;
2037: l_update_desc_attr NUMBER;
2038:
2039: l_ser_context MTL_SERIAL_NUMBERS.serial_attribute_category%type;
2040:
2041:
2042: -- Logging variables.....
2043: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

Line 2460: l_context_value MTL_SERIAL_NUMBERS.serial_attribute_category%type;

2456: l_validation_status varchar2(10);
2457: l_update_serial_attr NUMBER;
2458: l_update_desc_attr NUMBER;
2459:
2460: l_context_value MTL_SERIAL_NUMBERS.serial_attribute_category%type;
2461:
2462: -- Logging variables.....
2463: l_msg_tokens WSM_Log_PVT.token_rec_tbl;
2464: l_log_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2822: FROM mtl_serial_numbers

2818: l_last_txn_source_type_id,
2819: l_last_txn_source_name,
2820: l_parent_item_id,
2821: l_parent_serial_number
2822: FROM mtl_serial_numbers
2823: WHERE serial_number = p_serial_number
2824: AND inventory_item_id = p_inventory_item_id
2825: AND current_organization_id = p_organization_id
2826: FOR UPDATE NOWAIT;

Line 3057: mtl_serial_numbers msn

3053: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
3054: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
3055: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
3056: from wsm_serial_txn_interface wsti,
3057: mtl_serial_numbers msn
3058: where wsti.header_id = p_header_id
3059: and wsti.transaction_type_id = 2
3060: and (wsti.action_flag >= 5 AND wsti.action_flag <= 6) -- select the move/scrap
3061: and wsti.serial_number = msn.serial_number (+)

Line 3151: mtl_serial_numbers msn

3147: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
3148: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
3149: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
3150: from wsm_serial_txn_interface wsti,
3151: mtl_serial_numbers msn
3152: where wsti.header_id = p_header_id
3153: and wsti.transaction_type_id = 2
3154: and (nvl(wsti.action_flag,wsti.generate_serial_number) >= 1 AND nvl(wsti.action_flag,wsti.generate_serial_number) <= 3) -- select the move/scrap
3155: and wsti.serial_number = msn.serial_number (+)

Line 3359: FROM MTL_SERIAL_NUMBERS MSN

3355: where wsti.header_id = p_header_id
3356: and wsti.transaction_type_id = 2
3357: and wsti.action_flag in (5,6)
3358: and not exists( SELECT MSN.serial_number
3359: FROM MTL_SERIAL_NUMBERS MSN
3360: WHERE MSN.SERIAL_NUMBER = wsti.serial_number
3361: AND MSN.wip_entity_id = p_wip_entity_id
3362: AND MSN.current_organization_id = p_organization_id
3363: AND MSN.inventory_item_id = p_inventory_item_id

Line 3819: type t_serial_tbl is table of number index by mtl_serial_numbers.serial_number%type;

3815: x_error_count OUT NOCOPY NUMBER
3816: )
3817: IS
3818:
3819: type t_serial_tbl is table of number index by mtl_serial_numbers.serial_number%type;
3820:
3821: l_move_serial_qty NUMBER;
3822: l_scrap_serial_qty NUMBER;
3823:

Line 3832: l_context_value MTL_SERIAL_NUMBERS.serial_attribute_category%type;

3828: l_count NUMBER;
3829: l_cntr NUMBER;
3830:
3831: l_update_serial_attr NUMBER;
3832: l_context_value MTL_SERIAL_NUMBERS.serial_attribute_category%type;
3833:
3834: l_wip_serial_nums_tbl t_wip_intf_tbl_type;
3835: l_serial_list t_serial_tbl;
3836:

Line 3842: FROM mtl_serial_numbers msn

3838: l_job_serial_count NUMBER;
3839: l_gen_object_id NUMBER;
3840:
3841: CURSOR c_job_serials is SELECT serial_number
3842: FROM mtl_serial_numbers msn
3843: where msn.inventory_item_id = p_inventory_item_id
3844: and msn.current_organization_id = p_organization_id
3845: and msn.wip_entity_id = p_wip_entity_id;
3846:

Line 3976: FROM mtl_serial_numbers MSN

3972: l_stmt_num := 60;
3973: -- get the count of serial numbers present
3974: SELECT count(*)
3975: INTO l_job_serial_count
3976: FROM mtl_serial_numbers MSN
3977: where MSN.wip_entity_id = p_wip_entity_id
3978: AND MSN.current_organization_id = p_organization_id
3979: AND MSN.inventory_item_id = p_inventory_item_id
3980: AND nvl(MSN.intraoperation_step_type,-1) <> WIP_CONSTANTS.SCRAP;

Line 4143: from mtl_serial_numbers

4139: IF l_gen_object_id IS NULL THEN
4140: -- could be NULL when passed from MES..
4141: select gen_object_id
4142: into l_gen_object_id
4143: from mtl_serial_numbers
4144: where serial_number = p_serial_num_tbl(l_count).serial_number
4145: and inventory_item_id = p_inventory_item_id
4146: and current_organization_id = p_organization_id;
4147: END IF;

Line 4217: FROM MTL_SERIAL_NUMBERS MSN

4213: g_request_id,
4214: g_program_appl_id,
4215: g_program_id,
4216: sysdate
4217: FROM MTL_SERIAL_NUMBERS MSN
4218: WHERE MSN.wip_entity_id = p_wip_entity_id
4219: AND MSN.current_organization_id = p_organization_id
4220: AND MSN.inventory_item_id = p_inventory_item_id
4221: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

Line 4275: from mtl_serial_numbers

4271: IF l_gen_object_id IS NULL THEN
4272: -- could be NULL when passed from MES..
4273: select gen_object_id
4274: into l_gen_object_id
4275: from mtl_serial_numbers
4276: where serial_number = p_serial_num_tbl(l_count).serial_number
4277: and inventory_item_id = p_inventory_item_id
4278: and current_organization_id = p_organization_id;
4279: END IF;

Line 4349: FROM MTL_SERIAL_NUMBERS MSN

4345: g_request_id,
4346: g_program_appl_id,
4347: g_program_id,
4348: sysdate
4349: FROM MTL_SERIAL_NUMBERS MSN
4350: WHERE MSN.wip_entity_id = p_wip_entity_id
4351: AND MSN.current_organization_id = p_organization_id
4352: AND MSN.inventory_item_id = p_inventory_item_id
4353: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

Line 4422: FROM MTL_SERIAL_NUMBERS MSN

4418: g_request_id,
4419: g_program_appl_id,
4420: g_program_id,
4421: sysdate
4422: FROM MTL_SERIAL_NUMBERS MSN
4423: WHERE MSN.wip_entity_id = p_wip_entity_id
4424: AND MSN.current_organization_id = p_organization_id
4425: AND MSN.inventory_item_id = p_inventory_item_id
4426: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

Line 4480: FROM MTL_SERIAL_NUMBERS MSN

4476: g_request_id,
4477: g_program_appl_id,
4478: g_program_id,
4479: sysdate
4480: FROM MTL_SERIAL_NUMBERS MSN
4481: WHERE MSN.wip_entity_id = p_wip_entity_id
4482: AND MSN.current_organization_id = p_organization_id
4483: AND MSN.inventory_item_id = p_inventory_item_id
4484: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

Line 4547: from mtl_serial_numbers

4543: IF l_gen_object_id IS NULL THEN
4544: -- could be NULL when passed from MES..
4545: select gen_object_id
4546: into l_gen_object_id
4547: from mtl_serial_numbers
4548: where serial_number = p_serial_num_tbl(l_count).serial_number
4549: and inventory_item_id = p_inventory_item_id
4550: and current_organization_id = p_organization_id;
4551: END IF;

Line 4745: FROM MTL_SERIAL_NUMBERS MSN

4741:
4742: cursor c_ret_serial_num(v_txn_id IN NUMBER) IS
4743: SELECT MSN.serial_number,
4744: MSN.gen_object_id
4745: FROM MTL_SERIAL_NUMBERS MSN
4746: WHERE MSN.SERIAL_NUMBER IN (select wsmt.assembly_serial_number
4747: FROM WIP_SERIAL_MOVE_TRANSACTIONS WSMT
4748: WHERE WSMT.transaction_id = v_txn_id
4749: )

Line 4758: FROM MTL_SERIAL_NUMBERS MSN

4754:
4755: cursor c_undo_serial_num(v_txn_id IN NUMBER) IS
4756: SELECT MSN.serial_number,
4757: MSN.gen_object_id
4758: FROM MTL_SERIAL_NUMBERS MSN
4759: WHERE MSN.SERIAL_NUMBER IN (select wsmt.assembly_serial_number
4760: FROM WIP_SERIAL_MOVE_TRANSACTIONS WSMT
4761: WHERE WSMT.transaction_id = v_txn_id
4762: )

Line 4770: ( serial_number MTL_SERIAL_NUMBERS.serial_number%TYPE,

4766: AND MSN.wip_entity_id = p_wip_entity_id
4767: FOR UPDATE NOWAIT;
4768:
4769: type t_serial_txn_info_rec is RECORD
4770: ( serial_number MTL_SERIAL_NUMBERS.serial_number%TYPE,
4771: gen_object_id MTL_SERIAL_NUMBERS.gen_object_id%TYPE
4772: );
4773:
4774: type t_serial_txn_info_tbl IS table of t_serial_txn_info_rec INDEX BY BINARY_INTEGER;

Line 4771: gen_object_id MTL_SERIAL_NUMBERS.gen_object_id%TYPE

4767: FOR UPDATE NOWAIT;
4768:
4769: type t_serial_txn_info_rec is RECORD
4770: ( serial_number MTL_SERIAL_NUMBERS.serial_number%TYPE,
4771: gen_object_id MTL_SERIAL_NUMBERS.gen_object_id%TYPE
4772: );
4773:
4774: type t_serial_txn_info_tbl IS table of t_serial_txn_info_rec INDEX BY BINARY_INTEGER;
4775:

Line 5149: mtl_serial_numbers msn

5145: decode(wsti.attribute13 , l_null_char ,l_miss_char , wsti.attribute13 ),
5146: decode(wsti.attribute14 , l_null_char ,l_miss_char , wsti.attribute14 ),
5147: decode(wsti.attribute15 , l_null_char ,l_miss_char , wsti.attribute15 )
5148: from wsm_serial_txn_interface wsti,
5149: mtl_serial_numbers msn
5150: where header_id = p_header_id
5151: and transaction_type_id = 3
5152: and wsti.serial_number = msn.serial_number (+)
5153: and msn.inventory_item_id (+) = l_inventory_item_id

Line 5302: FROM MTL_SERIAL_NUMBERS MSN

5298: set wsti.process_status = wip_constants.error
5299: where wsti.header_id = p_header_id
5300: and wsti.transaction_type_id = 3
5301: and serial_number not in ( SELECT MSN.serial_number
5302: FROM MTL_SERIAL_NUMBERS MSN
5303: WHERE MSN.wip_entity_id = l_wip_entity_id
5304: AND MSN.current_organization_id = p_organization_id
5305: AND MSN.inventory_item_id = l_inventory_item_id
5306: -- AND MSN.current_status = WIP_CONSTANTS.IN_STORES

Line 5421: from mtl_serial_numbers MSN,

5417: IS
5418:
5419: CURSOR c_job_serials IS
5420: select serial_number
5421: from mtl_serial_numbers MSN,
5422: wip_discrete_jobs WDJ
5423: where MSN.inventory_item_id = WDJ.primary_item_id
5424: and MSN.wip_entity_id = p_split_txn_job_id
5425: and MSN.current_organization_id = WDJ.organization_id

Line 5430: type t_serial_tbl IS table of number INDEX by MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;

5426: and WDJ.wip_entity_id = p_split_txn_job_id
5427: and nvl(MSN.intraoperation_step_type,-1) <> 5;
5428:
5429:
5430: type t_serial_tbl IS table of number INDEX by MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE;
5431: l_serial_list t_serial_tbl;
5432:
5433: l_job_serials t_varchar2;
5434: l_index NUMBER;

Line 5616: from mtl_serial_numbers MSN

5612: g_program_appl_id ,
5613: g_program_id ,
5614: sysdate ,
5615: null
5616: from mtl_serial_numbers MSN
5617: where MSN.current_organization_id = p_organization_id
5618: and MSN.inventory_item_id = p_item_id
5619: and MSN.wip_entity_id = p_wip_entity_id
5620: and nvl(MSN.intraoperation_step_type,-1) <> 5;

Line 5696: l_parent_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;

5692: l_serial_ctrl_code NUMBER;
5693: l_first_serial_txn_id NUMBER;
5694: l_start_quantity NUMBER;
5695:
5696: l_parent_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5697: l_child_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5698: l_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5699:
5700: l_temp_rec WSM_Serial_Support_GRP.WSM_SERIAL_NUM_REC;

Line 5697: l_child_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;

5693: l_first_serial_txn_id NUMBER;
5694: l_start_quantity NUMBER;
5695:
5696: l_parent_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5697: l_child_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5698: l_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5699:
5700: l_temp_rec WSM_Serial_Support_GRP.WSM_SERIAL_NUM_REC;
5701: l_start_as_res_job NUMBER;

Line 5698: l_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;

5694: l_start_quantity NUMBER;
5695:
5696: l_parent_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5697: l_child_job_ser_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5698: l_context MTL_SERIAL_NUMBERS.SERIAL_ATTRIBUTE_CATEGORY%type;
5699:
5700: l_temp_rec WSM_Serial_Support_GRP.WSM_SERIAL_NUM_REC;
5701: l_start_as_res_job NUMBER;
5702: l_serial_start_op NUMBER;

Line 5725: FROM MTL_SERIAL_NUMBERS MSN

5721: l_curr_job_name WIP_ENTITIES.wip_entity_name%TYPE;
5722:
5723: CURSOR c_job_serials(v_wip_entity_id IN NUMBER,v_item_id IN NUMBER)
5724: IS SELECT msn.serial_number
5725: FROM MTL_SERIAL_NUMBERS MSN
5726: WHERE msn.wip_entity_id = v_wip_entity_id
5727: AND msn.inventory_item_id = v_item_id
5728: AND nvl(msn.INTRAOPERATION_STEP_TYPE,-1) <> WIP_CONSTANTS.SCRAP
5729: AND msn.current_organization_id = p_organization_id;

Line 5909: from mtl_serial_numbers

5905: select count(*)
5906: into l_serial_num_count
5907: -- ST : Fix for bug 4910758 (remove usage of wsm_job_serial_numbers_v)
5908: -- from wsm_job_serial_numbers_v
5909: from mtl_serial_numbers
5910: where inventory_item_id = l_inventory_item_id
5911: and wip_entity_id = l_wip_entity_id
5912: and nvl(intraoperation_step_type,-1) <> 5;
5913:

Line 6777: from mtl_serial_numbers MSN ,

6773: g_program_appl_id ,
6774: g_program_id ,
6775: sysdate ,
6776: null
6777: from mtl_serial_numbers MSN ,
6778: wsm_sm_starting_jobs WSSJ ,
6779: wsm_sm_resulting_jobs WSRJ
6780: where MSN.current_organization_id = p_organization_id
6781: and MSN.inventory_item_id = WSRJ.primary_item_id

Line 6877: from mtl_serial_numbers MSN ,

6873: g_program_appl_id ,
6874: g_program_id ,
6875: sysdate ,
6876: null
6877: from mtl_serial_numbers MSN ,
6878: wsm_sm_starting_jobs WSSJ ,
6879: wsm_sm_resulting_jobs WSRJ
6880: where MSN.current_organization_id = p_organization_id
6881: and MSN.inventory_item_id = WSSJ.primary_item_id

Line 7321: from mtl_serial_numbers

7317: select count(*)
7318: into l_serial_num_count
7319: -- ST : Fix for bug 4910758 (remove usage of wsm_job_serial_numbers_v)
7320: -- from wsm_job_serial_numbers_v
7321: from mtl_serial_numbers
7322: where inventory_item_id = l_inventory_item_id
7323: and wip_entity_id = l_wip_entity_id
7324: and nvl(intraoperation_step_type,-1) <> 5;
7325:

Line 7392: from mtl_serial_numbers

7388: g_program_appl_id ,
7389: g_program_id ,
7390: sysdate ,
7391: null
7392: from mtl_serial_numbers
7393: where serial_number = l_serial_tbl(l_cntr)
7394: and inventory_item_id = l_inventory_item_id
7395: and current_organization_id = p_organization_id;
7396: END IF;

Line 7440: from mtl_serial_numbers

7436: g_program_appl_id ,
7437: g_program_id ,
7438: sysdate ,
7439: null
7440: from mtl_serial_numbers
7441: where inventory_item_id = l_inventory_item_id
7442: and current_organization_id = p_organization_id
7443: and wip_entity_id = l_wip_entity_id
7444: and nvl(intraoperation_step_type,-1) <> 5

Line 7931: mtl_serial_numbers MSN,

7927: g_program_id ,
7928: sysdate ,
7929: null
7930: from wip_serial_move_interface WSMI,
7931: mtl_serial_numbers MSN,
7932: wip_move_txn_interface WMTI
7933: where WMTI.group_id = p_group_id
7934: and WMTI.transaction_id = WSMI.transaction_id
7935: and MSN.serial_number = WSMI.assembly_serial_number

Line 8145: mtl_serial_numbers MSN,

8141: g_program_id ,
8142: sysdate ,
8143: null
8144: from wip_serial_move_interface WSMI,
8145: mtl_serial_numbers MSN,
8146: wip_move_txn_interface WMTI
8147: where WMTI.transaction_id in (p_move_txn_id,p_scrap_txn_id)
8148: and WMTI.transaction_id = WSMI.transaction_id
8149: and MSN.serial_number = WSMI.assembly_serial_number

Line 8194: from mtl_serial_numbers msn,

8190: select msn.serial_number,
8191: msn.inventory_item_id,
8192: msn.current_organization_id,
8193: wmt.wip_entity_id
8194: from mtl_serial_numbers msn,
8195: wip_move_transactions wmt,
8196: wsm_lot_move_txn_interface wlmti,
8197: wsm_lot_based_jobs wlbj
8198: where wlmti.group_id = p_group_id

Line 8216: from mtl_serial_numbers msn,

8212: select msn.serial_number,
8213: msn.inventory_item_id,
8214: msn.current_organization_id,
8215: wdj.wip_entity_id
8216: from mtl_serial_numbers msn,
8217: wsm_lot_move_txn_interface wlmti,
8218: wip_discrete_jobs wdj,
8219: wsm_lot_based_jobs wlbj
8220: where wlmti.group_id = p_group_id

Line 8239: from mtl_serial_numbers msn,

8235: select msn.serial_number,
8236: msn.inventory_item_id,
8237: msn.current_organization_id,
8238: wmt.wip_entity_id
8239: from mtl_serial_numbers msn,
8240: wip_move_transactions wmt,
8241: wsm_lot_based_jobs wlbj
8242: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)
8243: and wmt.wip_entity_id = wlbj.wip_entity_id

Line 8256: from mtl_serial_numbers msn,

8252: select msn.serial_number,
8253: msn.inventory_item_id,
8254: msn.current_organization_id,
8255: wmt.wip_entity_id
8256: from mtl_serial_numbers msn,
8257: wip_move_transactions wmt,
8258: wip_serial_move_transactions wsmt,
8259: wsm_lot_based_jobs wlbj
8260: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)

Line 8457: serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE,

8453:
8454:
8455: type t_serial_op_info_rec is record
8456: (
8457: serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE,
8458: inventory_item_id NUMBER,
8459: organization_id NUMBER,
8460: wip_entity_id NUMBER
8461: );