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.

[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1057: p_srl_nmbrs_interface_rec IN mtl_serial_numbers_interface%ROWTYPE,

1053:
1054:
1055: PROCEDURE insert_upd_serial_numbers
1056: (
1057: p_srl_nmbrs_interface_rec IN mtl_serial_numbers_interface%ROWTYPE,
1058: x_return_status OUT NOCOPY VARCHAR2
1059: )
1060: IS
1061:

Line 1087: Select count(*) into l_row_exists from mtl_serial_numbers_interface

1083: END IF;
1084:
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: Select count(*) into l_row_exists from mtl_serial_numbers_interface
1088: where transaction_interface_id =
1089: p_srl_nmbrs_interface_rec.transaction_interface_id;
1090:
1091: IF l_row_exists = 1 THEN

Line 1095: UPDATE mtl_serial_numbers_interface

1091: IF l_row_exists = 1 THEN
1092:
1093: BEGIN
1094:
1095: UPDATE mtl_serial_numbers_interface
1096: SET
1097: fm_serial_number = p_srl_nmbrs_interface_rec.fm_serial_number
1098: where transaction_interface_id =
1099: p_srl_nmbrs_interface_rec.transaction_interface_id;

Line 1123: INSERT INTO mtl_serial_numbers_interface

1119:
1120: --insert into table mtl_transactions_interface
1121: BEGIN
1122:
1123: INSERT INTO mtl_serial_numbers_interface
1124: ( last_updated_by,
1125: last_update_date,
1126: last_update_login,
1127: created_by,

Line 2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;

2862: -- Records to hold the Job header,details
2863: -- and mtl_transactions_interface data
2864:
2865: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2867: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2868: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2869:
2870:

Line 3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;

3935:
3936: -- Records to hold mtl_transactions_interface data
3937: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
3938: l_txn_lots_interface_rec mtl_transaction_lots_interface%ROWTYPE;
3939: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
3940:
3941: CURSOR get_mtl_header_id IS
3942: SELECT mtl_material_transactions_s.nextval from dual;
3943:

Line 6382: select current_status, current_subinventory_code from mtl_serial_numbers

6378: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
6379:
6380:
6381: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is
6382: select current_status, current_subinventory_code from mtl_serial_numbers
6383: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
6384:
6385:
6386: -- Cursor c_get_min_operation_seq(p_wip_entity_id number) is

Line 7192: select current_status, current_subinventory_code from mtl_serial_numbers

7188: WHERE organization_id = p_org_id AND inventory_item_id = p_item_id;
7189:
7190:
7191: Cursor c_get_serial_info(p_item_id number, p_serial_number varchar2, p_org_id number) is
7192: select current_status, current_subinventory_code from mtl_serial_numbers
7193: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
7194:
7195:
7196: Cursor c_get_min_operation_seq(p_wip_entity_id number) is

Line 8064: MTL_SERIAL_NUMBERS MSN,

8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,
8062: WIP_DISCRETE_JOBS WDJ,
8063: WIP_OPERATIONS WO,
8064: MTL_SERIAL_NUMBERS MSN,
8065: MTL_TRANSACTION_REASONS MTR
8066: WHERE
8067: CRJX.wip_entity_id = p_wip_entity_id
8068: AND WO.operation_seq_num = p_operation_seq_num