ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F994F65B6A924DF9A73956F4F0E1BC80Y select null action_, null status_, null message_, null modified_columns_, to_number(null) transaction_id, x.organization_code, to_char(null) sales_order, to_char(null) order_line, x.line, x.line_description, x.assembly, x.assembly_description, x.primary_uom, x.job, x.job_description, x.bill_revision, xxen_util.meaning(1,'WIP_MOVE_TRANSACTION_TYPE',700) transaction_type, x.from_seq, x.from_code, x.from_department, x.from_step, x.to_seq, x.to_code, x.to_department, to_char(null) to_step, to_char(null) overcompletion, x.primary_uom uom, x.available, to_number(null) quantity, sysdate transaction_date, to_char(null) scrap_account_alias, to_char(null) scrap_account_number, to_char(null) reason, cast(null as varchar2(240)) reference, to_char(null) move_attribute_category, to_char(null) move_attribute1, to_char(null) move_attribute2, to_char(null) move_attribute3, to_char(null) move_attribute4, to_char(null) move_attribute5, to_char(null) move_attribute6, to_char(null) move_attribute7, to_char(null) move_attribute8, to_char(null) move_attribute9, to_char(null) move_attribute10, to_char(null) move_attribute11, to_char(null) move_attribute12, to_char(null) move_attribute13, to_char(null) move_attribute14, to_char(null) move_attribute15, row_number() over (order by x.organization_code,x.job,x.line,x.assembly,x.from_seq,x.fm_step_type) upload_row from ( select y.organization_code, to_char(null) line, to_char(null) line_description, y.assembly, y.assembly_description, y.primary_uom, y.job, y.job_description, y.bill_revision, y.from_seq, y.from_code, y.from_department, xxen_util.meaning(y.fm_step_type,'WIP_INTRAOPERATION_STEP',700) from_step, y.fm_step_type, y.to_seq, bso_to.operation_code to_code, bd_to.department_code to_department, y.available, y.wip_entity_id from ( select /*+ cardinality(rowgen 3) */ mp.organization_code, msiv.concatenated_segments assembly, msiv.description assembly_description, msiv.primary_uom_code primary_uom, we.wip_entity_name job, we.description job_description, wdj.bom_revision bill_revision, wo.operation_seq_num from_seq, bso.operation_code from_code, bd.department_code from_department, rowgen.column_value fm_step_type, nvl((select min(wo_cp.operation_seq_num) from wip_operations wo_cp where wo.wip_entity_id=wo_cp.wip_entity_id and wo.operation_seq_num<wo_cp.operation_seq_num and wo_cp.count_point_type=1),wo.operation_seq_num) to_seq, decode(rowgen.column_value,1,wo.quantity_in_queue,2,wo.quantity_running,3,wo.quantity_waiting_to_move) available, wdj.wip_entity_id from mtl_parameters mp, wip_discrete_jobs wdj, wip_entities we, mtl_system_items_vl msiv, wip_operations wo, bom_standard_operations bso, bom_departments bd, table(xxen_util.rowgen(3)) rowgen where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=wdj.organization_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wdj.wip_entity_id=we.wip_entity_id and we.entity_type=1 and wdj.primary_item_id=msiv.inventory_item_id and wdj.organization_id=msiv.organization_id and wdj.wip_entity_id=wo.wip_entity_id and wo.standard_operation_id=bso.standard_operation_id(+) and nvl(bso.operation_type,1)=1 and bso.line_id is null and wo.department_id=bd.department_id ) y, wip_operations wo_to, bom_standard_operations bso_to, bom_departments bd_to where y.available>0 and y.wip_entity_id=wo_to.wip_entity_id and y.to_seq=wo_to.operation_seq_num and wo_to.standard_operation_id=bso_to.standard_operation_id(+) and wo_to.department_id=bd_to.department_id union all select z.organization_code, z.line, z.line_description, z.assembly, z.assembly_description, z.primary_uom, to_char(null) job, to_char(null) job_description, z.bill_revision, z.from_seq, z.from_code, z.from_department, xxen_util.meaning(z.fm_step_type,'WIP_INTRAOPERATION_STEP',700) from_step, z.fm_step_type, z.to_seq, bso_to.operation_code to_code, bd_to.department_code to_department, z.available, to_number(null) wip_entity_id from ( select y.*, nvl((select min(wo_cp.operation_seq_num) from wip_operations wo_cp where y.first_schedule_id=wo_cp.repetitive_schedule_id and y.from_seq<wo_cp.operation_seq_num and wo_cp.count_point_type=1),y.from_seq) to_seq from ( select /*+ cardinality(rowgen 3) */ mp.organization_code, wl.line_code line, wl.description line_description, msiv.concatenated_segments assembly, msiv.description assembly_description, msiv.primary_uom_code primary_uom, max(wrs.bom_revision) keep (dense_rank first order by wrs.first_unit_start_date) bill_revision, min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) first_schedule_id, wo.operation_seq_num from_seq, max(bso.operation_code) keep (dense_rank first order by wrs.first_unit_start_date) from_code, max(bd.department_code) keep (dense_rank first order by wrs.first_unit_start_date) from_department, rowgen.column_value fm_step_type, sum(decode(rowgen.column_value,1,wo.quantity_in_queue,2,wo.quantity_running,3,wo.quantity_waiting_to_move)) available from mtl_parameters mp, wip_repetitive_schedules wrs, wip_lines wl, wip_entities we, mtl_system_items_vl msiv, wip_operations wo, bom_standard_operations bso, bom_departments bd, table(xxen_util.rowgen(3)) rowgen where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=wrs.organization_id and wrs.status_type in (3,4) and wrs.line_id=wl.line_id and wrs.wip_entity_id=we.wip_entity_id and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id and wrs.wip_entity_id=wo.wip_entity_id and wrs.repetitive_schedule_id=wo.repetitive_schedule_id and wo.standard_operation_id=bso.standard_operation_id(+) and nvl(bso.operation_type,1)=1 and bso.line_id is null and wo.department_id=bd.department_id group by mp.organization_code, wl.line_code, wl.description, msiv.concatenated_segments, msiv.description, msiv.primary_uom_code, wo.operation_seq_num, rowgen.column_value ) y where y.available>0 ) z, wip_operations wo_to, bom_standard_operations bso_to, bom_departments bd_to where z.first_schedule_id=wo_to.repetitive_schedule_id and z.to_seq=wo_to.operation_seq_num and wo_to.standard_operation_id=bso_to.standard_operation_id(+) and wo_to.department_id=bd_to.department_id ) x where 1=1 New upload: Move, Move and completion and Return and move transactions for discrete jobs and repetitive schedules as in the Move Transactions form (WIPTXSFM), each row inserted into wip_move_txn_interface and processed by wip_movproc_pub.processinterface in its own transaction, with e-records as in the form. Create, Update downloads the Queue, Run and To move steps that hold a quantity as new move rows. U A xxen_wip_upload.upload_move_transaction xxen_wip_upload.validate_move_transaction(:$column$.organization_code,:$column$.line,:$column$.assembly,:$column$.job,:$column$.transaction_type,:$column$.from_seq,:$column$.from_step,:$column$.to_seq,:$column$.to_step,:$column$.uom,:$column$.quantity,:$column$.transaction_date,:$column$.scrap_account_number) US WIP Move Transaction Upload Creates move transactions as in the Move Transactions form: moves between operations and intraoperation steps, including moves into and out of Reject and Scrap, Move and completion transactions and Return and move transactions, for discrete jobs and for the repetitive schedules of a line and assembly. Each row is posted immediately, with backflush, completion, outside processing and autocharge resources as for a move entered in the form. Upload Mode Create opens an empty sheet. Create, Update downloads the Queue, Run and To move steps of the selected jobs and schedules that hold a quantity, with their Available quantity, as new move rows: enter To Step and Quantity on the rows to move, rows left unchanged are not uploaded. An existing move is never updated; correct it with another move, for example a backward move or a Return and move transaction. Completions, returns and overcompletions follow the Transaction Types and Allow Overcompletion parameters, not the function Move Transactions is launched from. A .csv or plain .xlsx file, and an add-in upload of a sheet another user downloaded, run with the parameter defaults of the template named in the upload, else with the parameter defaults. With E-Records and E-Signatures set to Yes, discrete job moves create e-records as in the Move Transactions form, also where the move or material processing profiles are set to background, where the form creates none. A move that needs an e-signature is refused and has to be entered in the form. With the parameter cleared, moves are posted without e-records, as through the WIP move interface. Not supported: operations added on the fly, manual resource transactions, serialized jobs and backflush lot and serial entry. A move fails when a backflush component is serial controlled, or lot controlled with a lot that cannot be derived; derived lots are not verified. Mandatory quality collection plans are not enforced, as by the WIP move interface, and No Move shop floor statuses always apply, also for users of the form function that overrides them. To enter descriptive flexfield values, add the Move Attribute Category and Move Attribute1-15 columns, which show the segment prompts, to a template of your own. Enginatics Upload 1=1 :allow_overcompletion :e_records_and_e_signatures :transaction_types 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode Create: an empty sheet for new moves. Create, Update: the Queue, Run and To move steps of the selected jobs and schedules that hold a quantity, as new move rows; an existing move is not updated. 2 20 1=1 x.organization_code=:organization_code LOV custom Y select oav.organization_code value, oav.organization_name description from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id in (select wp.organization_id from wip_parameters wp) order by value select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code Organization of the downloaded operation steps and default organization of new rows. 3 30 1=1 x.wip_entity_id in (select wrv.wip_entity_id from mtl_sales_orders_kfv msok, wip_reservations_v wrv where msok.concatenated_segments=:sales_order and msok.sales_order_id=wrv.demand_source_header_id) LOV custom Y select distinct msok.concatenated_segments value, null description from mtl_parameters mp, wip_reservations_v wrv, wip_discrete_jobs wdj, mtl_sales_orders_kfv msok where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=wrv.organization_id and wrv.wip_entity_id=wdj.wip_entity_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wrv.demand_source_header_id=msok.sales_order_id order by value US Sales Order Restricts the download to the jobs reserved to the sales order. 4 40 1=1 x.wip_entity_id in (select wrv.wip_entity_id from wip_reservations_v wrv where wrv.demand_source_line_id=:order_line_id) LOV custom Y select oola.line_id id, case when count(distinct msok.sales_order_id) over (partition by oola.line_number,oola.shipment_number)>1 then msok.concatenated_segments||' ' end||to_char(oola.line_number)||'.'||to_char(oola.shipment_number) value, msok.concatenated_segments||': '||we.wip_entity_name description from mtl_parameters mp, mtl_sales_orders_kfv msok, wip_reservations_v wrv, oe_order_lines_all oola, wip_discrete_jobs wdj, wip_entities we where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and xxen_util.contains(:$flex$.sales_order,msok.concatenated_segments)='Y' and mp.organization_id=wrv.organization_id and msok.sales_order_id=wrv.demand_source_header_id and wrv.demand_source_line_id=oola.line_id and wrv.wip_entity_id=wdj.wip_entity_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wdj.wip_entity_id=we.wip_entity_id order by oola.line_number, oola.shipment_number, msok.concatenated_segments US Order Line Restricts the download to the jobs reserved to the order line. 5 50 1=1 x.line=:line_code LOV custom Y select wl.line_code value, wl.description from mtl_parameters mp, wip_lines wl where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=wl.organization_id and nvl(wl.disable_date,sysdate+1)>sysdate and wl.line_id in (select wri.line_id from wip_repetitive_items wri) order by value US Line Restricts the download to the repetitive schedules of the production line. 6 60 1=1 x.assembly=:assembly LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Assembly Restricts the download to the jobs and repetitive schedules of the assembly. 7 70 1=1 x.job=:job LOV WIP Job 8E2FF36EDEC379D2E0530100007F1FF2 Y Y select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700)||' ('||ood.organization_code||')'||nvl2(we.description,': '||we.description,null) description from wip_entities we, org_organization_definitions ood where (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and ( :$flex$.organization_code is null and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' ) and we.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate and we.entity_type in (1,3,5,8) --(Discrete job, Closed discrete job, Lot based job, Closed lot based job) order by we.creation_date desc US Job Restricts the download to the job. 8 80 :transaction_types LOV custom Y select 'ALL' id, 'Move, Complete and Return' value, null description from dual union all select 'MOVE' id, 'Move only' value, null description from dual ALL Y US Transaction Types Move only refuses Move and completion and Return and move transactions; to apply it to users or responsibilities, lock it on a template copy shared as restricted with them. 9 90 :allow_overcompletion LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Allow Overcompletion No refuses rows with Overcompletion, as the Move Transactions form does without the Allow Overcompletions function; to apply it to users or responsibilities, lock No on a template copy shared as restricted with them. 10 100 :e_records_and_e_signatures LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual case when fnd_profile.value('EDR_ERES_ENABLED')='Y' then 'Y' end US E-Records and E-Signatures Creates e-records for discrete job moves and refuses moves that need an e-signature, as the Move Transactions form does when EDR: E-records and E-signatures is Yes; clear to post the moves without e-records, as the WIP move interface does. B3DF167A2710468B84694544C659B278 Move Moves, completions and returns with the main fields of the Move Transactions form, without the flexfields. Upload Mode Create opens an empty sheet, Create, Update downloads the Queue, Run and To move steps that hold a quantity. ENGINATICS 5 ASSEMBLY 6 ASSEMBLY_DESCRIPTION 18 AVAILABLE 11 FROM_DEPARTMENT 10 FROM_SEQ 12 FROM_STEP 7 JOB 8 JOB_DESCRIPTION 4 LINE 3 ORDER_LINE 1 ORGANIZATION_CODE 16 OVERCOMPLETION 19 QUANTITY 23 REASON 24 REFERENCE 2 SALES_ORDER 21 SCRAP_ACCOUNT_ALIAS 22 SCRAP_ACCOUNT_NUMBER 14 TO_DEPARTMENT 13 TO_SEQ 15 TO_STEP 20 TRANSACTION_DATE 9 TRANSACTION_TYPE Y 17 UOM Upload Mode C S Site C6FB627F98844804AD6FE33861F9446C Move Only Moves without completions and returns, with Transaction Types locked to Move only. To apply it to users or responsibilities, copy it, lock Transaction Types on the copy and share the copy as restricted with them. ENGINATICS 5 ASSEMBLY 6 ASSEMBLY_DESCRIPTION 18 AVAILABLE 11 FROM_DEPARTMENT 10 FROM_SEQ 12 FROM_STEP 7 JOB 8 JOB_DESCRIPTION 4 LINE 3 ORDER_LINE 1 ORGANIZATION_CODE 16 OVERCOMPLETION 19 QUANTITY 23 REASON 24 REFERENCE 2 SALES_ORDER 21 SCRAP_ACCOUNT_ALIAS 22 SCRAP_ACCOUNT_NUMBER 14 TO_DEPARTMENT 13 TO_SEQ 15 TO_STEP 20 TRANSACTION_DATE 9 TRANSACTION_TYPE Y 17 UOM Transaction Types MOVE Y Upload Mode C S Site B3DF167A2710468B84694544C659B278 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 TRANSACTION_ID Number number Y 6 ORGANIZATION_CODE LOV custom varchar2 Y select oav.organization_id id, oav.organization_code value, oav.organization_name description from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id in (select wp.organization_id from wip_parameters wp) order by value select oav.organization_code from org_access_view oav where oav.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id in (select wp.organization_id from wip_parameters wp) Y Y 7 SALES_ORDER LOV custom varchar2 Y select distinct msok.concatenated_segments value, null description from mtl_parameters mp, wip_reservations_v wrv, wip_discrete_jobs wdj, mtl_sales_orders_kfv msok where mp.organization_code=:$column$.organization_code and mp.organization_id=wrv.organization_id and wrv.wip_entity_id=wdj.wip_entity_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wrv.demand_source_header_id=msok.sales_order_id order by value Restricts Order Line and Job to the jobs reserved to the sales order; not stored with the move. 8 ORDER_LINE LOV custom varchar2 Y select to_char(oola.line_number)||'.'||to_char(oola.shipment_number) value, we.wip_entity_name description from mtl_parameters mp, mtl_sales_orders_kfv msok, wip_reservations_v wrv, oe_order_lines_all oola, wip_discrete_jobs wdj, wip_entities we where mp.organization_code=:$column$.organization_code and msok.concatenated_segments=:$column$.sales_order and mp.organization_id=wrv.organization_id and msok.sales_order_id=wrv.demand_source_header_id and wrv.demand_source_line_id=oola.line_id and wrv.wip_entity_id=wdj.wip_entity_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wdj.wip_entity_id=we.wip_entity_id order by oola.line_number, oola.shipment_number Chooses the job reserved to the order line; not stored with the move. 9 LINE LOV custom varchar2 Y select wl.line_id id, wl.line_code value, wl.description from mtl_parameters mp, wip_lines wl where mp.organization_code=:$column$.organization_code and mp.organization_id=wl.organization_id and nvl(wl.disable_date,sysdate+1)>sysdate and wl.line_id in (select wri.line_id from wip_repetitive_items wri) order by value 10 LINE_DESCRIPTION Char varchar2 select wl.description from mtl_parameters mp, wip_lines wl where mp.organization_code=:$column$.organization_code and mp.organization_id=wl.organization_id and wl.line_code=:$column$.line Y 11 ASSEMBLY LOV custom varchar2 Y Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.mtl_transactions_enabled_flag='Y' and ( :$column$.line is not null and msiv.inventory_item_id in (select wri.primary_item_id from wip_lines wl, wip_repetitive_items wri where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wri.line_id) or :$column$.line is null and msiv.inventory_item_id in ( select wdj.primary_item_id from wip_discrete_jobs wdj where mp.organization_id=wdj.organization_id and wdj.status_type in (3,4) union all select we.primary_item_id from wip_repetitive_schedules wrs, wip_entities we where mp.organization_id=wrs.organization_id and wrs.status_type in (3,4) and wrs.wip_entity_id=we.wip_entity_id ) ) order by value select msiv.concatenated_segments from mtl_parameters mp, wip_entities we, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and we.wip_entity_name=:$column$.job and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id 12 ASSEMBLY_DESCRIPTION Char varchar2 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly Y 13 PRIMARY_UOM Char varchar2 select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly Y 14 JOB LOV custom varchar2 Y select we.wip_entity_id id, we.wip_entity_name value, we.description from mtl_parameters mp, wip_discrete_jobs wdj, wip_entities we where mp.organization_code=:$column$.organization_code and mp.organization_id=wdj.organization_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wdj.wip_entity_id=we.wip_entity_id and we.entity_type=1 and ( :$column$.order_line is null or we.wip_entity_id in ( select wrv.wip_entity_id from mtl_sales_orders_kfv msok, wip_reservations_v wrv, oe_order_lines_all oola where msok.concatenated_segments=:$column$.sales_order and msok.sales_order_id=wrv.demand_source_header_id and mp.organization_id=wrv.organization_id and wrv.demand_source_line_id=oola.line_id and to_char(oola.line_number)||'.'||to_char(oola.shipment_number)=:$column$.order_line ) ) order by value select distinct we.wip_entity_name from mtl_parameters mp, mtl_sales_orders_kfv msok, wip_reservations_v wrv, oe_order_lines_all oola, wip_discrete_jobs wdj, wip_entities we where mp.organization_code=:$column$.organization_code and msok.concatenated_segments=:$column$.sales_order and mp.organization_id=wrv.organization_id and msok.sales_order_id=wrv.demand_source_header_id and wrv.demand_source_line_id=oola.line_id and to_char(oola.line_number)||'.'||to_char(oola.shipment_number)=:$column$.order_line and wrv.wip_entity_id=wdj.wip_entity_id and wdj.status_type in (3,4) and wdj.serialization_start_op is null and wdj.wip_entity_id=we.wip_entity_id and we.entity_type=1 15 JOB_DESCRIPTION Char varchar2 select we.description from mtl_parameters mp, wip_entities we where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and we.wip_entity_name=:$column$.job Y 16 BILL_REVISION Char varchar2 select coalesce( (select wdj.bom_revision from wip_entities we, wip_discrete_jobs wdj where mp.organization_id=we.organization_id and we.wip_entity_name=:$column$.job and we.wip_entity_id=wdj.wip_entity_id), ( select max(wrs.bom_revision) keep (dense_rank first order by wrs.first_unit_start_date) from mtl_system_items_vl msiv, wip_entities we, wip_lines wl, wip_repetitive_schedules wrs where :$column$.job is null and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly and msiv.organization_id=we.organization_id and msiv.inventory_item_id=we.primary_item_id and we.entity_type=2 and mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and we.wip_entity_id=wrs.wip_entity_id and wl.line_id=wrs.line_id and wrs.status_type in (3,4) ) ) bill_revision from mtl_parameters mp where mp.organization_code=:$column$.organization_code Y 17 TRANSACTION_TYPE LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_MOVE_TRANSACTION_TYPE' and (ml.lookup_code=1 or nvl(:$flex$.Transaction_Types,'ALL')='ALL') order by ml.lookup_code xxen_util.meaning(case when fnd_profile.value('WIP_MOVE_COMPLETION_DEFAULT')='1' and :$flex$.Transaction_Types='ALL' then 2 else 1 end,'WIP_MOVE_TRANSACTION_TYPE',700) Y 18 FROM_SEQ LOV custom number Y select wo.operation_seq_num id, wo.operation_seq_num value, bd.department_code description from mtl_parameters mp, wip_entities we, wip_operations wo, bom_departments bd, bom_standard_operations bso where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and we.wip_entity_name=:$column$.job and we.entity_type=1 and we.wip_entity_id=wo.wip_entity_id and wo.repetitive_schedule_id is null and wo.department_id=bd.department_id and wo.standard_operation_id=bso.standard_operation_id(+) and nvl(bso.operation_type,1)=1 and bso.line_id is null union all select distinct wo.operation_seq_num id, wo.operation_seq_num value, bd.department_code description from mtl_parameters mp, wip_lines wl, wip_repetitive_schedules wrs, wip_entities we, mtl_system_items_vl msiv, wip_operations wo, bom_departments bd, bom_standard_operations bso where :$column$.job is null and mp.organization_code=:$column$.organization_code and mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and wrs.status_type in (3,4) and wrs.wip_entity_id=we.wip_entity_id and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly and wrs.repetitive_schedule_id=wo.repetitive_schedule_id and wo.department_id=bd.department_id and wo.standard_operation_id=bso.standard_operation_id(+) and nvl(bso.operation_type,1)=1 and bso.line_id is null order by value select wo.operation_seq_num from mtl_parameters mp, wip_entities we, wip_operations wo where :$column$.transaction_type=xxen_util.meaning(3,'WIP_MOVE_TRANSACTION_TYPE',700) and mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and ( we.wip_entity_name=:$column$.job or :$column$.job is null and we.entity_type=2 and we.primary_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly) and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_lines wl, wip_repetitive_schedules wrs where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and we.wip_entity_id=wrs.wip_entity_id and wrs.status_type in (3,4)) ) and we.wip_entity_id=wo.wip_entity_id and wo.next_operation_seq_num is null Y 19 FROM_CODE Char varchar2 select bso.operation_code from mtl_parameters mp, wip_entities we, wip_operations wo, bom_standard_operations bso where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and ( we.wip_entity_name=:$column$.job or :$column$.job is null and we.entity_type=2 and we.primary_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly) and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_lines wl, wip_repetitive_schedules wrs where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and we.wip_entity_id=wrs.wip_entity_id and wrs.status_type in (3,4)) ) and we.wip_entity_id=wo.wip_entity_id and wo.operation_seq_num=:$column$.from_seq and wo.standard_operation_id=bso.standard_operation_id Y 20 FROM_DEPARTMENT Char varchar2 select bd.department_code from mtl_parameters mp, wip_entities we, wip_operations wo, bom_departments bd where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and ( we.wip_entity_name=:$column$.job or :$column$.job is null and we.entity_type=2 and we.primary_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly) and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_lines wl, wip_repetitive_schedules wrs where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and we.wip_entity_id=wrs.wip_entity_id and wrs.status_type in (3,4)) ) and we.wip_entity_id=wo.wip_entity_id and wo.operation_seq_num=:$column$.from_seq and wo.department_id=bd.department_id Y 21 FROM_STEP LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, null description from mtl_parameters mp, wip_valid_intraoperation_steps wvis, mfg_lookups ml where mp.organization_code=:$column$.organization_code and mp.organization_id=wvis.organization_id and ml.lookup_type='WIP_INTRAOPERATION_STEP' and wvis.step_lookup_type=ml.lookup_code order by ml.lookup_code select xxen_util.meaning(rowgen.column_value,'WIP_INTRAOPERATION_STEP',700) from table(xxen_util.rowgen(5)) rowgen where :$column$.transaction_type=xxen_util.meaning(3,'WIP_MOVE_TRANSACTION_TYPE',700) and rowgen.column_value=3 or nvl(:$column$.transaction_type,'x')<>xxen_util.meaning(3,'WIP_MOVE_TRANSACTION_TYPE',700) and xxen_wip_upload.available_quantity_dsp(:$column$.organization_code,:$column$.job,:$column$.line,:$column$.assembly,:$column$.transaction_type,:$column$.from_seq,xxen_util.meaning(rowgen.column_value,'WIP_INTRAOPERATION_STEP',700),null)>0 Y 22 TO_SEQ LOV custom number Y select wo.operation_seq_num id, wo.operation_seq_num value, bd.department_code description from mtl_parameters mp, wip_entities we, wip_operations wo, bom_departments bd, bom_standard_operations bso where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and we.wip_entity_name=:$column$.job and we.entity_type=1 and we.wip_entity_id=wo.wip_entity_id and wo.repetitive_schedule_id is null and wo.department_id=bd.department_id and wo.standard_operation_id=bso.standard_operation_id(+) and nvl(bso.operation_type,1)=1 and bso.line_id is null union all select distinct wo.operation_seq_num id, wo.operation_seq_num value, bd.department_code description from mtl_parameters mp, wip_lines wl, wip_repetitive_schedules wrs, wip_entities we, mtl_system_items_vl msiv, wip_operations wo, bom_departments bd, bom_standard_operations bso where :$column$.job is null and mp.organization_code=:$column$.organization_code and mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and wrs.status_type in (3,4) and wrs.wip_entity_id=we.wip_entity_id and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly and wrs.repetitive_schedule_id=wo.repetitive_schedule_id and wo.department_id=bd.department_id and wo.standard_operation_id=bso.standard_operation_id(+) and nvl(bso.operation_type,1)=1 and bso.line_id is null order by value select case when :$column$.transaction_type=xxen_util.meaning(1,'WIP_MOVE_TRANSACTION_TYPE',700) then nvl(min(case when x.operation_seq_num>:$column$.from_seq and x.count_point_type=1 then x.operation_seq_num end),:$column$.from_seq) when :$column$.transaction_type=xxen_util.meaning(2,'WIP_MOVE_TRANSACTION_TYPE',700) then max(case when x.next_operation_seq_num is null then x.operation_seq_num end) end to_seq from ( select wo.operation_seq_num, wo.count_point_type, wo.next_operation_seq_num from mtl_parameters mp, wip_entities we, wip_operations wo where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and we.wip_entity_name=:$column$.job and we.wip_entity_id=wo.wip_entity_id union all select wo.operation_seq_num, wo.count_point_type, wo.next_operation_seq_num from mtl_parameters mp, wip_lines wl, wip_entities we, mtl_system_items_vl msiv, wip_operations wo where :$column$.job is null and mp.organization_code=:$column$.organization_code and mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and mp.organization_id=we.organization_id and we.entity_type=2 and we.primary_item_id=msiv.inventory_item_id and we.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly and we.wip_entity_id=wo.wip_entity_id and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_repetitive_schedules wrs where we.wip_entity_id=wrs.wip_entity_id and wl.line_id=wrs.line_id and wrs.status_type in (3,4)) ) x Y 23 TO_CODE Char varchar2 select bso.operation_code from mtl_parameters mp, wip_entities we, wip_operations wo, bom_standard_operations bso where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and ( we.wip_entity_name=:$column$.job or :$column$.job is null and we.entity_type=2 and we.primary_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly) and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_lines wl, wip_repetitive_schedules wrs where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and we.wip_entity_id=wrs.wip_entity_id and wrs.status_type in (3,4)) ) and we.wip_entity_id=wo.wip_entity_id and wo.operation_seq_num=:$column$.to_seq and wo.standard_operation_id=bso.standard_operation_id Y 24 TO_DEPARTMENT Char varchar2 select bd.department_code from mtl_parameters mp, wip_entities we, wip_operations wo, bom_departments bd where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and ( we.wip_entity_name=:$column$.job or :$column$.job is null and we.entity_type=2 and we.primary_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly) and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_lines wl, wip_repetitive_schedules wrs where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and we.wip_entity_id=wrs.wip_entity_id and wrs.status_type in (3,4)) ) and we.wip_entity_id=wo.wip_entity_id and wo.operation_seq_num=:$column$.to_seq and wo.department_id=bd.department_id Y 25 TO_STEP LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, null description from mtl_parameters mp, wip_valid_intraoperation_steps wvis, mfg_lookups ml where mp.organization_code=:$column$.organization_code and mp.organization_id=wvis.organization_id and ml.lookup_type='WIP_INTRAOPERATION_STEP' and wvis.step_lookup_type=ml.lookup_code order by ml.lookup_code case when :$column$.transaction_type=xxen_util.meaning(2,'WIP_MOVE_TRANSACTION_TYPE',700) then xxen_util.meaning(3,'WIP_INTRAOPERATION_STEP',700) end Y 26 OVERCOMPLETION LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where nvl(:$flex$.Allow_Overcompletion,'Y')='Y' Quantity above Available is moved as overcompletion; offered when Allow Overcompletion is Yes. 27 UOM LOV custom varchar2 Y select miuv.uom_code value, miuv.description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_uoms_view miuv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly and msiv.organization_id=miuv.organization_id and msiv.inventory_item_id=miuv.inventory_item_id order by value select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly Y 28 AVAILABLE Number number xxen_wip_upload.available_quantity_dsp(:$column$.organization_code,:$column$.job,:$column$.line,:$column$.assembly,:$column$.transaction_type,:$column$.from_seq,:$column$.from_step,:$column$.uom) Y 29 QUANTITY Number number select case when x.quantity_default='3' then x.available when x.minimum_transfer_quantity>0 and x.available>0 then least(x.minimum_transfer_quantity,x.available) end quantity from ( select fnd_profile.value('WIP_MOVE_TXN_QTY_DEFAULT') quantity_default, xxen_wip_upload.available_quantity_dsp(:$column$.organization_code,:$column$.job,:$column$.line,:$column$.assembly,:$column$.transaction_type,:$column$.from_seq,:$column$.from_step,:$column$.uom) available, ( select wo.minimum_transfer_quantity from mtl_parameters mp, wip_entities we, wip_operations wo where mp.organization_code=:$column$.organization_code and mp.organization_id=we.organization_id and ( we.wip_entity_name=:$column$.job or :$column$.job is null and we.entity_type=2 and we.primary_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.assembly) and wo.repetitive_schedule_id=(select min(wrs.repetitive_schedule_id) keep (dense_rank first order by wrs.first_unit_start_date) from wip_lines wl, wip_repetitive_schedules wrs where mp.organization_id=wl.organization_id and wl.line_code=:$column$.line and wl.line_id=wrs.line_id and we.wip_entity_id=wrs.wip_entity_id and wrs.status_type in (3,4)) ) and we.wip_entity_id=wo.wip_entity_id and wo.operation_seq_num=:$column$.from_seq ) minimum_transfer_quantity from dual where fnd_profile.value('WIP_MOVE_TXN_QTY_DEFAULT') in ('2','3') ) x Y 30 TRANSACTION_DATE DateTime date sysdate Y 31 SCRAP_ACCOUNT_ALIAS LOV custom varchar2 Y select mgdk.concatenated_segments value, mgdk.description from mtl_parameters mp, org_organization_definitions ood, mtl_generic_dispositions_kfv mgdk where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and mp.organization_id=mgdk.organization_id and mgdk.enabled_flag='Y' and trunc(sysdate) between nvl(mgdk.start_date_active,trunc(sysdate)) and nvl(mgdk.end_date_active,trunc(sysdate)) and nvl(mgdk.effective_date,sysdate)<=sysdate+1 and nvl(mgdk.disable_date,sysdate+1)>sysdate and wip_utilities.validate_scrap_account_id(mgdk.distribution_account,ood.chart_of_accounts_id)='Y' order by value Fills the Scrap Account Number; not stored. 32 SCRAP_ACCOUNT_NUMBER LOV custom varchar2 Y Y select gcck.code_combination_id id, gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id)||' ('||flvv.description||')' description from mtl_parameters mp, org_organization_definitions ood, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and ood.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and nvl(gcck.start_date_active,:$column$.transaction_date)<=:$column$.transaction_date and nvl(gcck.end_date_active,:$column$.transaction_date)+1>:$column$.transaction_date and flvv.lookup_type='ACCOUNT TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0 and gcck.gl_account_type=flvv.lookup_code order by value select gcck.concatenated_segments from mtl_parameters mp, mtl_generic_dispositions_kfv mgdk, gl_code_combinations_kfv gcck where mp.organization_code=:$column$.organization_code and mp.organization_id=mgdk.organization_id and mgdk.concatenated_segments=:$column$.scrap_account_alias and mgdk.distribution_account=gcck.code_combination_id 33 REASON LOV custom varchar2 Y select mtr.reason_id id, mtr.reason_name value, mtr.description from mtl_transaction_reasons mtr where nvl(mtr.disable_date,sysdate+1)>sysdate order by value 34 REFERENCE Char varchar2 240 35 MOVE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=706 and fdfcv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by value 36 MOVE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 37 MOVE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 38 MOVE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 39 MOVE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 40 MOVE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 41 MOVE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 42 MOVE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 43 MOVE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 44 MOVE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 45 MOVE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 46 MOVE_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 47 MOVE_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 48 MOVE_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 49 MOVE_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 50 MOVE_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>706, p_descriptive_flexfield_name=>'WIP_MOVE_TRANSACTIONS', p_context_name=>:$column$.move_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.move_attribute1, p_attribute2=>:$column$.move_attribute2, p_attribute3=>:$column$.move_attribute3, p_attribute4=>:$column$.move_attribute4, p_attribute5=>:$column$.move_attribute5, p_attribute6=>:$column$.move_attribute6, p_attribute7=>:$column$.move_attribute7, p_attribute8=>:$column$.move_attribute8, p_attribute9=>:$column$.move_attribute9, p_attribute10=>:$column$.move_attribute10, p_attribute11=>:$column$.move_attribute11, p_attribute12=>:$column$.move_attribute12, p_attribute13=>:$column$.move_attribute13, p_attribute14=>:$column$.move_attribute14, p_attribute15=>:$column$.move_attribute15 ) ) lov order by value select distinct '('||decode(fdfc.descriptive_flex_context_code,'Global Data Elements','Global',fdfc.descriptive_flex_context_code)||') '||fdfcuv.form_left_prompt from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=706 and fdfv.descriptive_flexfield_name='WIP_MOVE_TRANSACTIONS' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 51 UPLOAD_ROW Number number Y U 1 p_transaction_id in Number Y TRANSACTION_ID U 2 p_organization_id in Number ORGANIZATION_CODE U 3 p_line_id in Number Y LINE U 4 p_assembly_id in Number Y ASSEMBLY U 5 p_wip_entity_id in Number Y JOB U 6 p_transaction_type in Number Y TRANSACTION_TYPE U 7 p_fm_operation_seq_num in Number Y FROM_SEQ U 8 p_fm_step in Number Y FROM_STEP U 9 p_to_operation_seq_num in Number Y TO_SEQ U 10 p_to_step in Number Y TO_STEP U 11 p_overcompletion in Char Y OVERCOMPLETION U 12 p_transaction_uom in Char Y UOM U 13 p_transaction_quantity in Number Y QUANTITY U 14 p_transaction_date in Date Y TRANSACTION_DATE U 15 p_scrap_account_id in Number Y SCRAP_ACCOUNT_NUMBER U 16 p_reason_id in Number Y REASON U 17 p_reference in Char Y REFERENCE U 18 p_attribute_category in Char Y MOVE_ATTRIBUTE_CATEGORY U 19 p_attribute1 in Char Y MOVE_ATTRIBUTE1 U 20 p_attribute2 in Char Y MOVE_ATTRIBUTE2 U 21 p_attribute3 in Char Y MOVE_ATTRIBUTE3 U 22 p_attribute4 in Char Y MOVE_ATTRIBUTE4 U 23 p_attribute5 in Char Y MOVE_ATTRIBUTE5 U 24 p_attribute6 in Char Y MOVE_ATTRIBUTE6 U 25 p_attribute7 in Char Y MOVE_ATTRIBUTE7 U 26 p_attribute8 in Char Y MOVE_ATTRIBUTE8 U 27 p_attribute9 in Char Y MOVE_ATTRIBUTE9 U 28 p_attribute10 in Char Y MOVE_ATTRIBUTE10 U 29 p_attribute11 in Char Y MOVE_ATTRIBUTE11 U 30 p_attribute12 in Char Y MOVE_ATTRIBUTE12 U 31 p_attribute13 in Char Y MOVE_ATTRIBUTE13 U 32 p_attribute14 in Char Y MOVE_ATTRIBUTE14 U 33 p_attribute15 in Char Y MOVE_ATTRIBUTE15 U 34 p_transaction_id_out out Number TRANSACTION_ID U 35 status_ out Char STATUS_CODE_ U 36 message_ out Char MESSAGE_ Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.transaction_id, nvl(mp.organization_code,xu.organization_code) organization_code, xu.sales_order, xu.order_line, nvl(wl.line_code,xu.line) line, nvl(wl.description,xu.line_description) line_description, nvl(msiv.concatenated_segments,xu.assembly) assembly, nvl(msiv.description,xu.assembly_description) assembly_description, nvl(msiv.primary_uom_code,xu.primary_uom) primary_uom, nvl(case when wmt.line_id is null then we.wip_entity_name end,xu.job) job, nvl(case when wmt.line_id is null then we.description end,xu.job_description) job_description, nvl(wdj.bom_revision,xu.bill_revision) bill_revision, nvl(case when wmt.transaction_id is not null then wip_move_validator.move_txn_type(wmt.transaction_id,wmt.organization_id,wmt.wip_entity_id,wmt.primary_item_id) end,xu.transaction_type) transaction_type, nvl(wmt.fm_operation_seq_num,xu.from_seq) from_seq, nvl(wmt.fm_operation_code,xu.from_code) from_code, nvl(bd_fm.department_code,xu.from_department) from_department, nvl(xxen_util.meaning(wmt.fm_intraoperation_step_type,'WIP_INTRAOPERATION_STEP',700),xu.from_step) from_step, nvl(wmt.to_operation_seq_num,xu.to_seq) to_seq, nvl(wmt.to_operation_code,xu.to_code) to_code, nvl(bd_to.department_code,xu.to_department) to_department, nvl(xxen_util.meaning(wmt.to_intraoperation_step_type,'WIP_INTRAOPERATION_STEP',700),xu.to_step) to_step, nvl(xxen_util.yes(case when wmt.overcompletion_transaction_qty>0 then 'Y' end),xu.overcompletion) overcompletion, nvl(wmt.transaction_uom,xu.uom) uom, xu.available, nvl(wmt.transaction_quantity,xu.quantity) quantity, nvl(wmt.transaction_date,xu.transaction_date) transaction_date, xu.scrap_account_alias, nvl(gcck.concatenated_segments,xu.scrap_account_number) scrap_account_number, nvl(mtr.reason_name,xu.reason) reason, nvl(wmt.reference,xu.reference) reference, nvl(xxen_util.display_flexfield_context(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category),xu.move_attribute_category) move_attribute_category, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE1',null,wmt.attribute1),xu.move_attribute1) move_attribute1, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE2',null,wmt.attribute2),xu.move_attribute2) move_attribute2, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE3',null,wmt.attribute3),xu.move_attribute3) move_attribute3, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE4',null,wmt.attribute4),xu.move_attribute4) move_attribute4, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE5',null,wmt.attribute5),xu.move_attribute5) move_attribute5, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE6',null,wmt.attribute6),xu.move_attribute6) move_attribute6, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE7',null,wmt.attribute7),xu.move_attribute7) move_attribute7, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE8',null,wmt.attribute8),xu.move_attribute8) move_attribute8, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE9',null,wmt.attribute9),xu.move_attribute9) move_attribute9, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE10',null,wmt.attribute10),xu.move_attribute10) move_attribute10, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE11',null,wmt.attribute11),xu.move_attribute11) move_attribute11, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE12',null,wmt.attribute12),xu.move_attribute12) move_attribute12, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE13',null,wmt.attribute13),xu.move_attribute13) move_attribute13, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE14',null,wmt.attribute14),xu.move_attribute14) move_attribute14, nvl(xxen_util.display_flexfield_value(706,'WIP_MOVE_TRANSACTIONS',wmt.attribute_category,'ATTRIBUTE15',null,wmt.attribute15),xu.move_attribute15) move_attribute15, xu.upload_row from xxen_wip_move_transacti_5945_u xu, wip_move_transactions wmt, mtl_parameters mp, wip_entities we, wip_discrete_jobs wdj, wip_lines wl, mtl_system_items_vl msiv, bom_departments bd_fm, bom_departments bd_to, gl_code_combinations_kfv gcck, mtl_transaction_reasons mtr where xu.status_code_=xxen_upload.status_success and xu.transaction_id=wmt.transaction_id(+) and wmt.organization_id=mp.organization_id(+) and wmt.wip_entity_id=we.wip_entity_id(+) and wmt.wip_entity_id=wdj.wip_entity_id(+) and wmt.line_id=wl.line_id(+) and wmt.primary_item_id=msiv.inventory_item_id(+) and wmt.organization_id=msiv.organization_id(+) and wmt.fm_department_id=bd_fm.department_id(+) and wmt.to_department_id=bd_to.department_id(+) and wmt.scrap_account_id=gcck.code_combination_id(+) and wmt.reason_id=mtr.reason_id(+)