[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT attribute7, attribute8, attribute9, attribute10, attribute11,
attribute12, attribute13, attribute14, attribute15, request_id,
program_application_id, program_id, program_update_date,
approval_status_type, approval_date, approval_list_id,
change_order_type_id, responsible_organization_id,
approval_request_date, requestor_user_name, assignee_name,
change_notice, organization_id, last_update_date, last_updated_by,
creation_date, created_by, last_update_login, description,
status_type, initiation_date, implementation_date,
cancellation_date, cancellation_comments, priority_code,
reason_code, estimated_eng_cost, estimated_mfg_cost, requestor_id,
attribute_category, attribute1, attribute2, attribute3,
attribute4, attribute5, attribute6, process_flag,
transaction_id, APPROVAL_LIST_NAME, CHANGE_ORDER_TYPE,
change_mgmt_type_name, project_name, task_number, ORGANIZATION_CODE,
RESPONSIBLE_ORG_CODE, transaction_type, ENG_CHANGES_IFCE_KEY, change_name ,status_name, --Bug 2908248
pk1_name ,pk2_name , pk3_name ,plm_or_erp_change --11.5.10
, Approval_status_name -- bug 3587304
,ORGANIZATION_HIERARCHY -- 4967902
, employee_number -- 4402842
, source_type_name
, source_name
, need_by_date
, eco_department_name
FROM eng_eng_changes_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT attribute11, attribute12, attribute13, attribute14,
attribute15, program_application_id, program_id, program_update_date,
request_id, revision_id, change_notice, organization_id, revision,
last_update_date, last_updated_by, creation_date,created_by,
last_update_login, comments,attribute_category, attribute1,
attribute2, attribute3, attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9, attribute10, new_revision,
process_flag, transaction_id,transaction_type, ORGANIZATION_CODE,
eng_changes_ifce_key
FROM eng_eco_revisions_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key
AND process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM eng_eco_revisions_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT attribute11, attribute12, attribute13, attribute14,
attribute15, program_application_id, program_id, program_update_date,
request_id, revision_id, change_notice, organization_id, revision,
last_update_date, last_updated_by, creation_date,created_by,
last_update_login, comments,attribute_category, attribute1,
attribute2, attribute3, attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9, attribute10, new_revision,
process_flag, transaction_id,transaction_type, ORGANIZATION_CODE,
eng_changes_ifce_key, eng_eco_revisions_ifce_key
FROM eng_eco_revisions_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT change_notice ,
organization_id ,
revised_item_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
implementation_date ,
cancellation_date ,
cancel_comments ,
disposition_type ,
new_item_revision ,
early_schedule_date ,
attribute_category ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
status_type ,
scheduled_date ,
bill_sequence_id ,
mrp_active ,
request_id ,
program_application_id ,
program_id ,
program_update_date ,
update_wip ,
use_up ,
use_up_item_id ,
revised_item_sequence_id ,
use_up_plan_name ,
descriptive_text ,
auto_implement_date ,
attribute1 ,
attribute6 ,
attribute10 ,
requestor_id ,
comments ,
process_flag ,
transaction_id ,
organization_code ,
revised_item_number ,
new_rtg_revision ,
use_up_item_number ,
alternate_bom_designator ,
transaction_type ,
ENG_REVISED_ITEMS_IFCE_KEY,
eng_changes_ifce_key ,
parent_revised_item_name ,
parent_alternate_name ,
updated_item_revision ,
New_scheduled_date -- Bug 3432944
,
from_item_revision -- 11.5.10E
,
new_revision_label ,
New_Revised_Item_Rev_Desc ,
new_revision_reason ,
from_end_item_unit_number
/*Bug 6377841*/
FROM eng_revised_items_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key
AND process_flag = 1
AND (g_all_org = 1
OR (g_all_org = 2
AND organization_id = g_org_id))
ORDER BY parent_revised_item_name desc ;
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM eng_revised_items_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT change_notice ,
organization_id ,
revised_item_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
implementation_date ,
cancellation_date ,
cancel_comments ,
disposition_type ,
new_item_revision ,
early_schedule_date ,
attribute_category ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
status_type ,
scheduled_date ,
bill_sequence_id ,
mrp_active ,
request_id ,
program_application_id ,
program_id ,
program_update_date ,
update_wip ,
use_up ,
use_up_item_id ,
revised_item_sequence_id ,
use_up_plan_name ,
descriptive_text ,
auto_implement_date ,
attribute1 ,
attribute6 ,
attribute10 ,
requestor_id ,
comments ,
process_flag ,
transaction_id ,
organization_code ,
revised_item_number ,
new_rtg_revision ,
use_up_item_number ,
alternate_bom_designator ,
transaction_type ,
ENG_REVISED_ITEMS_IFCE_KEY,
eng_changes_ifce_key ,
parent_revised_item_name ,
parent_alternate_name ,
updated_item_revision ,
New_scheduled_date -- Bug 3432944
,
from_item_revision -- 11.5.10E
,
new_revision_label ,
New_Revised_Item_Rev_Desc ,
new_revision_reason ,
from_end_item_unit_number
/*Bug 6377841*/
FROM eng_revised_items_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR (g_all_org = 2
AND organization_id = g_org_id))
ORDER BY parent_revised_item_name desc ;
SELECT supply_subinventory ,
operation_lead_time_percent ,
revised_item_sequence_id ,
cost_factor ,
required_for_revenue ,
high_quantity ,
component_sequence_id ,
program_application_id ,
wip_supply_type ,
supply_locator_id ,
bom_item_type ,
operation_seq_num ,
component_item_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
item_num ,
component_quantity ,
component_yield_factor ,
component_remarks ,
revised_item_number ,
effectivity_date ,
change_notice ,
implementation_date ,
disable_date ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
planning_factor ,
quantity_related ,
so_basis ,
optional ,
mutually_exclusive_options ,
include_in_cost_rollup ,
check_atp ,
shipping_allowed ,
required_to_ship ,
include_on_ship_docs ,
include_on_bill_docs ,
low_quantity ,
acd_type ,
old_component_sequence_id ,
bill_sequence_id ,
request_id ,
program_id ,
program_update_date ,
pick_components ,
assembly_type ,
interface_entity_type ,
reference_designator ,
new_effectivity_date ,
old_effectivity_date ,
substitute_comp_id ,
new_operation_seq_num ,
old_operation_seq_num ,
process_flag ,
transaction_id ,
SUBSTITUTE_COMP_NUMBER ,
ORGANIZATION_CODE ,
ASSEMBLY_ITEM_NUMBER ,
COMPONENT_ITEM_NUMBER ,
LOCATION_NAME ,
ORGANIZATION_ID ,
ASSEMBLY_ITEM_ID ,
ALTERNATE_BOM_DESIGNATOR ,
transaction_type ,
BOM_INVENTORY_COMPS_IFCE_KEY,
eng_changes_ifce_key ,
eng_revised_items_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
,
New_revised_Item_Revision,
basis_type ,
from_end_item_unit_number, /*Bug 6377841*/
to_end_item_unit_number
/*Bug 6377841*/
/*BUG 9374069 revert 8414408,old_from_end_item_unit_number 8414408*/
FROM bom_inventory_comps_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key
AND interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR (g_all_org = 2
AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM bom_inventory_comps_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT supply_subinventory ,
operation_lead_time_percent ,
revised_item_sequence_id ,
cost_factor ,
required_for_revenue ,
high_quantity ,
component_sequence_id ,
program_application_id ,
wip_supply_type ,
supply_locator_id ,
bom_item_type ,
operation_seq_num ,
component_item_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
item_num ,
component_quantity ,
component_yield_factor ,
component_remarks ,
effectivity_date ,
change_notice ,
implementation_date ,
disable_date ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
planning_factor ,
quantity_related ,
so_basis ,
optional ,
mutually_exclusive_options ,
include_in_cost_rollup ,
check_atp ,
shipping_allowed ,
required_to_ship ,
include_on_ship_docs ,
include_on_bill_docs ,
low_quantity ,
acd_type ,
old_component_sequence_id ,
bill_sequence_id ,
request_id ,
program_id ,
program_update_date ,
pick_components ,
assembly_type ,
interface_entity_type ,
reference_designator ,
new_effectivity_date ,
old_effectivity_date ,
substitute_comp_id ,
new_operation_seq_num ,
old_operation_seq_num ,
process_flag ,
transaction_id ,
SUBSTITUTE_COMP_NUMBER ,
ORGANIZATION_CODE ,
ASSEMBLY_ITEM_NUMBER ,
COMPONENT_ITEM_NUMBER ,
LOCATION_NAME ,
ORGANIZATION_ID ,
ASSEMBLY_ITEM_ID ,
ALTERNATE_BOM_DESIGNATOR ,
transaction_type ,
BOM_INVENTORY_COMPS_IFCE_KEY,
eng_changes_ifce_key ,
eng_revised_items_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
,
New_revised_Item_Revision,
basis_type ,
from_end_item_unit_number,
/*Bug 6377841*/
to_end_item_unit_number
/*Bug 6377841*/
/*BUG 9374069 revert 8414408,old_from_end_item_unit_number*/
FROM bom_inventory_comps_interface
WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
AND interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR (g_all_org = 2
AND organization_id = g_org_id));
SELECT DISTINCT(ENG_REVISED_ITEMS_IFCE_KEY) item_ifce_key
FROM bom_inventory_comps_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT supply_subinventory ,
operation_lead_time_percent ,
revised_item_sequence_id ,
revised_item_number , --added for OM ER 9946990
cost_factor ,
required_for_revenue ,
high_quantity ,
component_sequence_id ,
program_application_id ,
wip_supply_type ,
supply_locator_id ,
bom_item_type ,
operation_seq_num ,
component_item_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
item_num ,
component_quantity ,
component_yield_factor ,
component_remarks ,
effectivity_date ,
change_notice ,
implementation_date ,
disable_date ,
attribute_category ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
planning_factor ,
quantity_related ,
so_basis ,
optional ,
mutually_exclusive_options ,
include_in_cost_rollup ,
check_atp ,
shipping_allowed ,
required_to_ship ,
include_on_ship_docs ,
include_on_bill_docs ,
low_quantity ,
acd_type ,
old_component_sequence_id ,
bill_sequence_id ,
request_id ,
program_id ,
program_update_date ,
pick_components ,
assembly_type ,
interface_entity_type ,
reference_designator ,
new_effectivity_date ,
old_effectivity_date ,
substitute_comp_id ,
new_operation_seq_num ,
old_operation_seq_num ,
process_flag ,
transaction_id ,
SUBSTITUTE_COMP_NUMBER ,
ORGANIZATION_CODE ,
ASSEMBLY_ITEM_NUMBER ,
COMPONENT_ITEM_NUMBER ,
LOCATION_NAME ,
ORGANIZATION_ID ,
ASSEMBLY_ITEM_ID ,
ALTERNATE_BOM_DESIGNATOR ,
transaction_type ,
BOM_INVENTORY_COMPS_IFCE_KEY,
eng_changes_ifce_key ,
eng_revised_items_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
,
New_revised_Item_Revision,
basis_type ,
from_end_item_unit_number, /*Bug 6377841*/
to_end_item_unit_number
/*Bug 6377841*/
/*BUG 9374069 revert 8414408,old_from_end_item_unit_number */
FROM bom_inventory_comps_interface
WHERE interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR (g_all_org = 2
AND organization_id = g_org_id));
SELECT COMPONENT_REFERENCE_DESIGNATOR,last_update_date,last_update_login,
ref_designator_comment, change_notice, component_sequence_id,acd_type,
request_id, program_application_id, program_id, program_update_date,
attribute_category, attribute1, attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15,
new_designator, process_flag, transaction_id, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, ORGANIZATION_CODE, ORGANIZATION_ID,last_updated_by,
creation_date, created_by, ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR,
COMPONENT_ITEM_ID, BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_ref_desgs_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_ref_desgs_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key
and process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM bom_ref_desgs_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT COMPONENT_REFERENCE_DESIGNATOR,last_update_date,last_update_login,
last_updated_by, creation_date,created_by, ref_designator_comment,
change_notice, component_sequence_id,acd_type, request_id,
program_application_id, program_id, program_update_date,
attribute_category, attribute1, attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15,
new_designator, process_flag, transaction_id, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, ORGANIZATION_CODE, ORGANIZATION_ID,
ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR, COMPONENT_ITEM_ID,
BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_ref_desgs_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_ref_desgs_interface
WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
AND interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_revised_items_ifce_key) item_ifce_key
FROM bom_ref_desgs_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT COMPONENT_REFERENCE_DESIGNATOR,last_update_date,last_update_login,
last_updated_by, creation_date,created_by, ref_designator_comment,
change_notice, component_sequence_id,acd_type, request_id,
program_application_id, program_id, program_update_date,
attribute_category, attribute1, attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15,
new_designator, process_flag, transaction_id, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, ORGANIZATION_CODE, ORGANIZATION_ID,
ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR, COMPONENT_ITEM_ID,
BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_ref_desgs_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_ref_desgs_interface
WHERE bom_inventory_comps_ifce_key = g_revised_comp_ifce_key
AND interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(bom_inventory_comps_ifce_key) comp_ifce_key
FROM bom_ref_desgs_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT COMPONENT_REFERENCE_DESIGNATOR,last_update_date,last_update_login,
last_updated_by, creation_date,created_by, ref_designator_comment,
change_notice, component_sequence_id,acd_type, request_id,
program_application_id, program_id, program_update_date,
attribute_category, attribute1, attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15,
new_designator, process_flag, transaction_id, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, ORGANIZATION_CODE, ORGANIZATION_ID,
ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR, COMPONENT_ITEM_ID,
BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_ref_desgs_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_ref_desgs_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT substitute_component_id, last_update_date, last_updated_by, creation_date,
created_by, last_update_login, substitute_item_quantity,
component_sequence_id, acd_type, change_notice, request_id,
program_application_id, program_update_date, attribute_category, attribute1,
attribute2, attribute4, attribute5, attribute6, attribute8, attribute9,
attribute10, attribute12, attribute13, attribute14, attribute15, program_id,
attribute3, attribute7, attribute11, new_sub_comp_id, process_flag,
transaction_id, NEW_SUB_COMP_NUMBER, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, SUBSTITUTE_COMP_NUMBER, ORGANIZATION_CODE,
ORGANIZATION_ID, ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR,
COMPONENT_ITEM_ID, BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_sub_comps_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_sub_comps_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key
and process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM bom_sub_comps_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT substitute_component_id, last_update_date, last_updated_by, creation_date,
created_by, last_update_login, substitute_item_quantity,
component_sequence_id, acd_type, change_notice, request_id,
program_application_id, program_update_date, attribute_category, attribute1,
attribute2, attribute4, attribute5, attribute6, attribute8, attribute9,
attribute10, attribute12, attribute13, attribute14, attribute15, program_id,
attribute3, attribute7, attribute11, new_sub_comp_id, process_flag,
transaction_id, NEW_SUB_COMP_NUMBER, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, SUBSTITUTE_COMP_NUMBER, ORGANIZATION_CODE,
ORGANIZATION_ID, ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR,
COMPONENT_ITEM_ID, BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_sub_comps_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_sub_comps_interface
WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
AND interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_revised_items_ifce_key) item_ifce_key
FROM bom_sub_comps_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT substitute_component_id, last_update_date, last_updated_by, creation_date,
created_by, last_update_login, substitute_item_quantity,
component_sequence_id, acd_type, change_notice, request_id,
program_application_id, program_update_date, attribute_category, attribute1,
attribute2, attribute4, attribute5, attribute6, attribute8, attribute9,
attribute10, attribute12, attribute13, attribute14, attribute15, program_id,
attribute3, attribute7, attribute11, new_sub_comp_id, process_flag,
transaction_id, NEW_SUB_COMP_NUMBER, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, SUBSTITUTE_COMP_NUMBER, ORGANIZATION_CODE,
ORGANIZATION_ID, ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR,
COMPONENT_ITEM_ID, BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_sub_comps_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_sub_comps_interface
WHERE bom_inventory_comps_ifce_key = g_revised_comp_ifce_key
AND interface_entity_type = 'ECO'
AND process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(bom_inventory_comps_ifce_key) comp_ifce_key
FROM bom_sub_comps_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT substitute_component_id, last_update_date, last_updated_by, creation_date,
created_by, last_update_login, substitute_item_quantity,
component_sequence_id, acd_type, change_notice, request_id,
program_application_id, program_update_date, attribute_category, attribute1,
attribute2, attribute4, attribute5, attribute6, attribute8, attribute9,
attribute10, attribute12, attribute13, attribute14, attribute15, program_id,
attribute3, attribute7, attribute11, new_sub_comp_id, process_flag,
transaction_id, NEW_SUB_COMP_NUMBER, ASSEMBLY_ITEM_NUMBER,
COMPONENT_ITEM_NUMBER, SUBSTITUTE_COMP_NUMBER, ORGANIZATION_CODE,
ORGANIZATION_ID, ASSEMBLY_ITEM_ID, ALTERNATE_BOM_DESIGNATOR,
COMPONENT_ITEM_ID, BILL_SEQUENCE_ID, OPERATION_SEQ_NUM, EFFECTIVITY_DATE,
interface_entity_type, transaction_type, eng_changes_ifce_key,
eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
bom_sub_comps_ifce_key
--Bug 3396529: Added New_revised_Item_Revision
, New_revised_Item_Revision
FROM bom_sub_comps_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM bom_op_resources_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
FROM bom_op_sequences_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key -- Bug 4033384
FROM eng_change_lines_interface
WHERE process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
PROCEDURE Update_Interface_Tables(p_return_status VARCHAR2)
IS
l_process_flag NUMBER;
UPDATE eng_eng_changes_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE eng_eco_revisions_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE eng_change_lines_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE eng_revised_items_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE bom_inventory_comps_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE bom_sub_comps_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE bom_ref_desgs_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE bom_op_resources_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE bom_op_sequences_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
UPDATE bom_sub_op_resources_interface
SET PROCESS_FLAG = l_process_flag
WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
END Update_Interface_Tables;
PROCEDURE Update_Eco_Interface (
p_eco_rec ENG_Eco_PUB.Eco_Rec_Type
) IS
BEGIN
UPDATE eng_eng_changes_interface
SET ATTRIBUTE7 = p_eco_rec.attribute7
, ATTRIBUTE8 = p_eco_rec.attribute8
, ATTRIBUTE9 = p_eco_rec.attribute9
, ATTRIBUTE10 = p_eco_rec.attribute10
, ATTRIBUTE11 = p_eco_rec.attribute11
, ATTRIBUTE12 = p_eco_rec.attribute12
, ATTRIBUTE13 = p_eco_rec.attribute13
, ATTRIBUTE14 = p_eco_rec.attribute14
, ATTRIBUTE15 = p_eco_rec.attribute15
-- , REQUEST_ID = p_eco_rec.request_id
-- , PROGRAM_APPLICATION_ID = p_eco_rec.program_application_id
-- , PROGRAM_ID = p_eco_rec.program_id
-- , PROGRAM_UPDATE_DATE = p_eco_rec.program_update_date
-- , APPROVAL_STATUS_TYPE = p_eco_rec.approval_status_type
, APPROVAL_DATE = p_eco_rec.approval_date
-- , APPROVAL_LIST_ID = p_eco_rec.approval_list_id
-- , CHANGE_ORDER_TYPE_ID = p_eco_rec.change_order_type_id
-- , RESPONSIBLE_ORGANIZATION_ID = p_eco_rec.responsible_org_id
, APPROVAL_REQUEST_DATE = p_eco_rec.approval_request_date
-- , CHANGE_NOTICE = p_eco_rec.change_notice
-- , ORGANIZATION_ID = p_eco_rec.organization_id
-- , LAST_UPDATE_DATE = p_eco_rec.last_update_date
-- , LAST_UPDATED_BY = p_eco_rec.last_updated_by
-- , CREATION_DATE = p_eco_rec.creation_date
-- , CREATED_BY = p_eco_rec.created_by
-- , LAST_UPDATE_LOGIN = p_eco_rec.last_update_login
, DESCRIPTION = p_eco_rec.description
-- , STATUS_TYPE = p_eco_rec.status_type
-- , INITIATION_DATE = p_eco_rec.initiation_date
-- , IMPLEMENTATION_DATE = p_eco_rec.implementation_date
-- , CANCELLATION_DATE = p_eco_rec.cancellation_date
, CANCELLATION_COMMENTS = p_eco_rec.cancellation_comments
, PRIORITY_CODE = p_eco_rec.priority_code
, REASON_CODE = p_eco_rec.reason_code
-- , ESTIMATED_ENG_COST = p_eco_rec.estimated_eng_cost
-- , ESTIMATED_MFG_COST = p_eco_rec.estimated_mfg_cost
-- , REQUESTOR_ID = p_eco_rec.requestor_id
, ATTRIBUTE_CATEGORY = p_eco_rec.attribute_category
, ATTRIBUTE1 = p_eco_rec.attribute1
, ATTRIBUTE2 = p_eco_rec.attribute2
, ATTRIBUTE3 = p_eco_rec.attribute3
, ATTRIBUTE4 = p_eco_rec.attribute4
, ATTRIBUTE5 = p_eco_rec.attribute5
, ATTRIBUTE6 = p_eco_rec.attribute6
, process_flag = G_PF_SUCCESS --, p_eco_rec.process_flag
, APPROVAL_LIST_NAME = p_eco_rec.approval_list_name
-- , CHANGE_ORDER_TYPE = p_eco_rec.change_order_type
, ORGANIZATION_CODE = p_eco_rec.organization_code
-- , RESPONSIBLE_ORG_CODE = p_eco_rec.responsible_org_code
WHERE transaction_id = p_eco_rec.transaction_id
;
END Update_Eco_Interface;
PROCEDURE Update_Eco_Revisions_Interface (
p_rev_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type
) IS
BEGIN
FOR i IN 1..p_rev_tbl.COUNT LOOP
UPDATE eng_eco_revisions_interface SET
attribute11 = p_rev_tbl(i).attribute11,
attribute12 = p_rev_tbl(i).attribute12,
attribute13 = p_rev_tbl(i).attribute13,
attribute14 = p_rev_tbl(i).attribute14,
attribute15 = p_rev_tbl(i).attribute15,
-- revision_id = p_rev_tbl(i).revision_id,
comments = p_rev_tbl(i).comments,
-- program_application_id = p_rev_tbl(i).program_application_id,
-- program_id = p_rev_tbl(i).program_id,
-- program_update_date = p_rev_tbl(i).program_update_date,
-- request_id = p_rev_tbl(i).request_id,
-- change_notice = p_rev_tbl(i).change_notice,
-- organization_id = p_rev_tbl(i).organization_id,
-- revision = p_rev_tbl(i).rev,
-- last_update_date = p_rev_tbl(i).last_update_date,
-- last_updated_by = p_rev_tbl(i).last_updated_by,
-- creation_date = p_rev_tbl(i).creation_date,
-- created_by = p_rev_tbl(i).created_by,
-- last_update_login = p_rev_tbl(i).last_update_login,
attribute_category = p_rev_tbl(i).attribute_category,
attribute1 = p_rev_tbl(i).attribute1,
attribute2 = p_rev_tbl(i).attribute2,
attribute3 = p_rev_tbl(i).attribute3,
attribute4 = p_rev_tbl(i).attribute4,
attribute5 = p_rev_tbl(i).attribute5,
attribute6 = p_rev_tbl(i).attribute6,
attribute7 = p_rev_tbl(i).attribute7,
attribute8 = p_rev_tbl(i).attribute8,
attribute9 = p_rev_tbl(i).attribute9,
attribute10 = p_rev_tbl(i).attribute10,
new_revision = p_rev_tbl(i).new_revision,
organization_code = p_rev_tbl(i).organization_code,
process_flag = G_PF_SUCCESS --, p_rev_tbl(i).process_flag
WHERE transaction_id = p_rev_tbl(i).transaction_id;
END Update_Eco_Revisions_Interface;
PROCEDURE Update_Revised_Items_Interface (
p_rev_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type
) IS
BEGIN
FOR i IN 1..p_rev_item_tbl.COUNT LOOP
UPDATE eng_revised_items_interface SET
-- change_notice = p_rev_item_tbl(i).change_notice,
-- organization_id = p_rev_item_tbl(i).organization_id,
-- revised_item_id = p_rev_item_tbl(i).revised_item_id,
-- last_update_date = p_rev_item_tbl(i).last_update_date,
-- last_updated_by = p_rev_item_tbl(i).last_updated_by,
-- creation_date = p_rev_item_tbl(i).creation_date,
-- created_by = p_rev_item_tbl(i).created_by,
-- last_update_login = p_rev_item_tbl(i).last_update_login,
-- implementation_date = p_rev_item_tbl(i).implementation_date,
-- cancellation_date = p_rev_item_tbl(i).cancellation_date,
cancel_comments = p_rev_item_tbl(i).cancel_comments,
disposition_type = p_rev_item_tbl(i).disposition_type,
-- new_item_revision = p_rev_item_tbl(i).new_item_revision,
-- early_schedule_date = p_rev_item_tbl(i).early_schedule_date,
attribute_category = p_rev_item_tbl(i).attribute_category,
attribute1 = p_rev_item_tbl(i).attribute1,
attribute2 = p_rev_item_tbl(i).attribute2,
attribute3 = p_rev_item_tbl(i).attribute3,
attribute4 = p_rev_item_tbl(i).attribute4,
attribute5 = p_rev_item_tbl(i).attribute5,
attribute6 = p_rev_item_tbl(i).attribute6,
attribute7 = p_rev_item_tbl(i).attribute7,
attribute8 = p_rev_item_tbl(i).attribute8,
attribute9 = p_rev_item_tbl(i).attribute9,
attribute10 = p_rev_item_tbl(i).attribute10,
attribute11 = p_rev_item_tbl(i).attribute11,
attribute12 = p_rev_item_tbl(i).attribute12,
attribute13 = p_rev_item_tbl(i).attribute13,
attribute14 = p_rev_item_tbl(i).attribute14,
attribute15 = p_rev_item_tbl(i).attribute15,
status_type = p_rev_item_tbl(i).status_type,
-- scheduled_date = p_rev_item_tbl(i).scheduled_date,
-- bill_sequence_id = p_rev_item_tbl(i).bill_sequence_id,
mrp_active = p_rev_item_tbl(i).mrp_active,
-- request_id = p_rev_item_tbl(i).request_id,
-- program_application_id = p_rev_item_tbl(i).program_application_id,
-- program_id = p_rev_item_tbl(i).program_id,
-- program_update_date = p_rev_item_tbl(i).program_update_date,
update_wip = p_rev_item_tbl(i).update_wip,
-- use_up = p_rev_item_tbl(i).use_up,
-- use_up_item_id = p_rev_item_tbl(i).use_up_item_id,
-- revised_item_sequence_id = p_rev_item_tbl(i).revised_item_sequence_id,
use_up_plan_name = p_rev_item_tbl(i).use_up_plan_name,
-- descriptive_text = p_rev_item_tbl(i).descriptive_text,
-- auto_implement_date = p_rev_item_tbl(i).auto_implement_date,
-- requestor_id = p_rev_item_tbl(i).requestor_id,
-- comments = p_rev_item_tbl(i).comments,
process_flag = G_PF_SUCCESS, --p_rev_item_tbl(i).process_flag,
organization_code = p_rev_item_tbl(i).organization_code,
revised_item_number = p_rev_item_tbl(i).revised_item_name,
use_up_item_number = p_rev_item_tbl(i).use_up_item_name --,
-- alternate_bom_designator = p_rev_item_tbl(i).alternate_bom_designator
WHERE transaction_id = p_rev_item_tbl(i).transaction_id;
END Update_Revised_Items_Interface;
PROCEDURE Update_Revised_Comps_Interface (
p_rev_comp_tbl BOM_Bo_PUB.Rev_Component_Tbl_Type
) IS
BEGIN
FOR i IN 1..p_rev_comp_tbl.COUNT LOOP
UPDATE bom_inventory_comps_interface SET
supply_subinventory = p_rev_comp_tbl(i).supply_subinventory,
-- operation_lead_time_percent = p_rev_comp_tbl(i).op_lead_time_percent,
-- revised_item_sequence_id = p_rev_comp_tbl(i).revised_item_sequence_id,
-- cost_factor = p_rev_comp_tbl(i).cost_factor,
required_for_revenue = p_rev_comp_tbl(i).required_for_revenue,
-- high_quantity = p_rev_comp_tbl(i).high_quantity,
-- component_sequence_id = p_rev_comp_tbl(i).component_sequence_id,
-- program_application_id = p_rev_comp_tbl(i).program_application_id,
wip_supply_type = p_rev_comp_tbl(i).wip_supply_type,
-- supply_locator_id = p_rev_comp_tbl(i).supply_locator_id,
-- bom_item_type = p_rev_comp_tbl(i).bom_item_type,
-- operation_seq_num = p_rev_comp_tbl(i).operation_seq_num,
-- component_item_id = p_rev_comp_tbl(i).component_item_id,
-- last_update_date = p_rev_comp_tbl(i).last_update_date,
-- last_updated_by = p_rev_comp_tbl(i).last_updated_by,
-- creation_date = p_rev_comp_tbl(i).creation_date,
-- created_by = p_rev_comp_tbl(i).created_by,
-- last_update_login = p_rev_comp_tbl(i).last_update_login,
-- item_num = p_rev_comp_tbl(i).item_num,
-- component_quantity = p_rev_comp_tbl(i).component_quantity,
-- component_yield_factor = p_rev_comp_tbl(i).component_yield_factor,
-- component_remarks = p_rev_comp_tbl(i).component_remarks,
-- effectivity_date = p_rev_comp_tbl(i).effectivity_date,
-- change_notice = p_rev_comp_tbl(i).change_notice,
-- implementation_date = p_rev_comp_tbl(i).implementation_date,
disable_date = p_rev_comp_tbl(i).disable_date,
attribute_category = p_rev_comp_tbl(i).attribute_category,
attribute1 = p_rev_comp_tbl(i).attribute1,
attribute2 = p_rev_comp_tbl(i).attribute2,
attribute3 = p_rev_comp_tbl(i).attribute3,
attribute4 = p_rev_comp_tbl(i).attribute4,
attribute5 = p_rev_comp_tbl(i).attribute5,
attribute6 = p_rev_comp_tbl(i).attribute6,
attribute7 = p_rev_comp_tbl(i).attribute7,
attribute8 = p_rev_comp_tbl(i).attribute8,
attribute9 = p_rev_comp_tbl(i).attribute9,
attribute10 = p_rev_comp_tbl(i).attribute10,
attribute11 = p_rev_comp_tbl(i).attribute11,
attribute12 = p_rev_comp_tbl(i).attribute12,
attribute13 = p_rev_comp_tbl(i).attribute13,
attribute14 = p_rev_comp_tbl(i).attribute14,
attribute15 = p_rev_comp_tbl(i).attribute15,
-- planning_factor = p_rev_comp_tbl(i).planning_factor,
quantity_related = p_rev_comp_tbl(i).quantity_related,
so_basis = p_rev_comp_tbl(i).so_basis,
optional = p_rev_comp_tbl(i).optional,
-- mutually_exclusive_options = p_rev_comp_tbl(i).mutually_exclusive_opt,
include_in_cost_rollup = p_rev_comp_tbl(i).include_in_cost_rollup,
check_atp = p_rev_comp_tbl(i).check_atp,
shipping_allowed = p_rev_comp_tbl(i).shipping_allowed,
required_to_ship = p_rev_comp_tbl(i).required_to_ship,
include_on_ship_docs = p_rev_comp_tbl(i).include_on_ship_docs,
-- include_on_bill_docs = p_rev_comp_tbl(i).include_on_bill_docs,
-- low_quantity = p_rev_comp_tbl(i).low_quantity,
acd_type = p_rev_comp_tbl(i).acd_type,
-- old_component_sequence_id = p_rev_comp_tbl(i).old_component_sequence_id,
-- bill_sequence_id = p_rev_comp_tbl(i).bill_sequence_id,
-- request_id = p_rev_comp_tbl(i).request_id,
-- program_id = p_rev_comp_tbl(i).program_id,
-- program_update_date = p_rev_comp_tbl(i).program_update_date,
-- pick_components = p_rev_comp_tbl(i).pick_components,
-- assembly_type = p_rev_comp_tbl(i).assembly_type,
-- interface_entity_type = p_rev_comp_tbl(i).interface_entity_type,
-- reference_designator = p_rev_comp_tbl(i).reference_designator,
new_effectivity_date = p_rev_comp_tbl(i).new_effectivity_date,
old_effectivity_date = p_rev_comp_tbl(i).old_effectivity_date,
-- substitute_comp_id = p_rev_comp_tbl(i).substitute_comp_id,
-- new_operation_seq_num = p_rev_comp_tbl(i).new_operation_seq_num,
-- old_operation_seq_num = p_rev_comp_tbl(i).old_operation_seq_num,
-- substitute_comp_number = p_rev_comp_tbl(i).substitute_comp_number,
organization_code = p_rev_comp_tbl(i).organization_code,
-- assembly_item_number = p_rev_comp_tbl(i).assembly_item_number,
-- component_item_number = p_rev_comp_tbl(i).component_item_number,
location_name = p_rev_comp_tbl(i).location_name ,
-- organization_id = p_rev_comp_tbl(i).organization_id,
-- assembly_item_id = p_rev_comp_tbl(i).assembly_item_id,
-- alternate_bom_designator = p_rev_comp_tbl(i).alternate_bom_designator,
-- process_flag = p_rev_comp_tbl(i).process_flag,
basis_type = p_rev_comp_tbl(i).basis_type
WHERE transaction_id = p_rev_comp_tbl(i).row_identifier;
END Update_Revised_Comps_Interface;
PROCEDURE Update_Sub_Comps_Interface (
p_sub_comp_tbl BOM_Bo_PUB.Sub_Component_Tbl_Type
) IS
BEGIN
FOR i IN 1..p_sub_comp_tbl.COUNT LOOP
UPDATE bom_sub_comps_interface SET
-- substitute_component_id = p_sub_comp_tbl(i).substitute_component_id,
-- last_update_date = p_sub_comp_tbl(i).last_update_date,
-- last_updated_by = p_sub_comp_tbl(i).last_updated_by,
-- creation_date = p_sub_comp_tbl(i).creation_date,
-- created_by = p_sub_comp_tbl(i).created_by,
-- last_update_login = p_sub_comp_tbl(i).last_update_login,
substitute_item_quantity = p_sub_comp_tbl(i).substitute_item_quantity,
-- component_sequence_id = p_sub_comp_tbl(i).component_sequence_id,
acd_type = p_sub_comp_tbl(i).acd_type,
-- change_notice = p_sub_comp_tbl(i).change_notice,
-- request_id = p_sub_comp_tbl(i).request_id,
-- program_application_id = p_sub_comp_tbl(i).program_application_id,
-- program_update_date = p_sub_comp_tbl(i).program_update_date,
attribute_category = p_sub_comp_tbl(i).attribute_category,
attribute1 = p_sub_comp_tbl(i).attribute1,
attribute2 = p_sub_comp_tbl(i).attribute2,
attribute3 = p_sub_comp_tbl(i).attribute3,
attribute4 = p_sub_comp_tbl(i).attribute4,
attribute5 = p_sub_comp_tbl(i).attribute5,
attribute6 = p_sub_comp_tbl(i).attribute6,
attribute7 = p_sub_comp_tbl(i).attribute7,
attribute8 = p_sub_comp_tbl(i).attribute8,
attribute9 = p_sub_comp_tbl(i).attribute9,
attribute10 = p_sub_comp_tbl(i).attribute10,
attribute11 = p_sub_comp_tbl(i).attribute11,
attribute12 = p_sub_comp_tbl(i).attribute12,
attribute13 = p_sub_comp_tbl(i).attribute13,
attribute14 = p_sub_comp_tbl(i).attribute14,
attribute15 = p_sub_comp_tbl(i).attribute15,
program_id = p_sub_comp_tbl(i).program_id,
-- new_sub_comp_id = p_sub_comp_tbl(i).new_sub_comp_id,
-- process_flag = p_sub_comp_tbl(i).process_flag,
-- new_sub_comp_number = p_sub_comp_tbl(i).new_sub_comp_number,
-- assembly_item_number = p_sub_comp_tbl(i).assembly_item_number,
-- component_item_number = p_sub_comp_tbl(i).component_item_number,
-- substitute_comp_number = p_sub_comp_tbl(i).substitute_comp_number,
organization_code = p_sub_comp_tbl(i).organization_code --,
-- organization_id = p_sub_comp_tbl(i).organization_id,
-- assembly_item_id = p_sub_comp_tbl(i).assembly_item_id,
-- alternate_bom_designator = p_sub_comp_tbl(i).alternate_bom_designator,
-- component_item_id = p_sub_comp_tbl(i).component_item_id,
-- bill_sequence_id = p_sub_comp_tbl(i).bill_sequence_id,
-- operation_seq_num = p_sub_comp_tbl(i).operation_seq_num,
-- effectivity_date = p_sub_comp_tbl(i).effectivity_date,
-- interface_entity_type = p_sub_comp_tbl(i).interface_entity_type
WHERE transaction_id = p_sub_comp_tbl(i).row_identifier;
END Update_Sub_Comps_Interface;
PROCEDURE Update_Ref_Desig_Interface (
p_ref_desg_tbl BOM_Bo_PUB.Ref_Designator_Tbl_Type
) IS
BEGIN
FOR i IN 1..p_ref_desg_tbl.COUNT LOOP
UPDATE bom_ref_desgs_interface SET
-- component_reference_designator = p_ref_desg_tbl(i).ref_designator,
-- last_update_date = p_ref_desg_tbl(i).last_update_date,
-- last_updated_by = p_ref_desg_tbl(i).last_updated_by,
-- creation_date = p_ref_desg_tbl(i).creation_date,
-- created_by = p_ref_desg_tbl(i).created_by,
-- last_update_login = p_ref_desg_tbl(i).last_update_login,
ref_designator_comment = p_ref_desg_tbl(i).ref_designator_comment,
-- change_notice = p_ref_desg_tbl(i).change_notice,
-- component_sequence_id = p_ref_desg_tbl(i).component_sequence_id,
acd_type = p_ref_desg_tbl(i).acd_type,
-- request_id = p_ref_desg_tbl(i).request_id,
-- program_application_id = p_ref_desg_tbl(i).program_application_id,
-- program_id = p_ref_desg_tbl(i).program_id,
-- program_update_date = p_ref_desg_tbl(i).program_update_date,
attribute_category = p_ref_desg_tbl(i).attribute_category,
attribute1 = p_ref_desg_tbl(i).attribute1,
attribute2 = p_ref_desg_tbl(i).attribute2,
attribute3 = p_ref_desg_tbl(i).attribute3,
attribute4 = p_ref_desg_tbl(i).attribute4,
attribute5 = p_ref_desg_tbl(i).attribute5,
attribute6 = p_ref_desg_tbl(i).attribute6,
attribute7 = p_ref_desg_tbl(i).attribute7,
attribute8 = p_ref_desg_tbl(i).attribute8,
attribute9 = p_ref_desg_tbl(i).attribute9,
attribute10 = p_ref_desg_tbl(i).attribute10,
attribute11 = p_ref_desg_tbl(i).attribute11,
attribute12 = p_ref_desg_tbl(i).attribute12,
attribute13 = p_ref_desg_tbl(i).attribute13,
attribute14 = p_ref_desg_tbl(i).attribute14,
attribute15 = p_ref_desg_tbl(i).attribute15,
-- new_designator = p_ref_desg_tbl(i).new_designator,
-- process_flag = p_ref_desg_tbl(i).process_flag,
-- assembly_item_number = p_ref_desg_tbl(i).assembly_item_number,
-- component_item_number = p_ref_desg_tbl(i).component_item_number,
organization_code = p_ref_desg_tbl(i).organization_code --,
-- organization_id = p_ref_desg_tbl(i).organization_id,
-- assembly_item_id = p_ref_desg_tbl(i).assembly_item_id,
-- alternate_bom_designator = p_ref_desg_tbl(i).alternate_bom_designator,
-- component_item_id = p_ref_desg_tbl(i).component_item_id,
-- bill_sequence_id = p_ref_desg_tbl(i).bill_sequence_id,
-- operation_seq_num = p_ref_desg_tbl(i).operation_seq_num,
-- effectivity_date = p_ref_desg_tbl(i).effectivity_date,
-- interface_entity_type = p_ref_desg_tbl(i).interface_entity_type
WHERE transaction_id = p_ref_desg_tbl(i).row_identifier;
END Update_Ref_Desig_Interface;
PROCEDURE Update_Error_Table (
p_error_tbl ENG_Eco_PUB.Error_Tbl_Type,
p_top_ifce_key VARCHAR2 DEFAULT NULL,
x_unexp_error OUT NOCOPY VARCHAR2
) IS
BEGIN
FOR i IN 1..p_error_tbl.COUNT LOOP
IF (p_error_tbl(i).message_name is NOT NULL) THEN
INSERT INTO mtl_interface_errors
(ORGANIZATION_ID,
UNIQUE_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
TABLE_NAME,
MESSAGE_NAME,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
ERROR_MESSAGE,
TRANSACTION_ID)
VALUES
(p_error_tbl(i).organization_id,
mtl_system_items_interface_s.nextval,
sysdate,
FND_GLOBAL.USER_ID,
sysdate,
FND_GLOBAL.USER_ID,
FND_GLOBAL.USER_ID,
p_error_tbl(i).table_name,
p_error_tbl(i).message_name,
FND_GLOBAL.CONC_REQUEST_ID,
FND_GLOBAL.PROG_APPL_ID,
FND_GLOBAL.CONC_PROGRAM_ID,
sysdate,
p_error_tbl(i).error_message,
p_error_tbl(i).transaction_id);
END Update_Error_Table;
g_encoin_rev_item_tbl(k).last_update_date := c3rec.last_update_date;
g_encoin_rev_item_tbl(k).last_updated_by := c3rec.last_updated_by;
g_encoin_rev_item_tbl(k).last_update_login := c3rec.last_update_login;
g_encoin_rev_item_tbl(k).program_update_date := c3rec.program_update_date;
g_encoin_rev_item_tbl(k).update_wip := c3rec.update_wip;
g_encoin_rev_item_tbl(k).updated_item_revision := c3rec.updated_item_revision; -- Bug 3432944
g_encoin_rev_comp_tbl(v).last_update_date := c12rec.last_update_date;
g_encoin_rev_comp_tbl(v).last_updated_by := c12rec.last_updated_by;
g_encoin_rev_comp_tbl(v).last_update_login := c12rec.last_update_login;
g_encoin_rev_comp_tbl(v).program_update_date := c12rec.program_update_date;
g_encoin_rev_comp_tbl(v).last_update_date := c12rec.last_update_date;
g_encoin_rev_comp_tbl(v).last_updated_by := c12rec.last_updated_by;
g_encoin_rev_comp_tbl(v).last_update_login := c12rec.last_update_login;
g_encoin_rev_comp_tbl(v).program_update_date := c12rec.program_update_date;
g_encoin_ref_des_tbl(y).last_update_date := c15rec.last_update_date;
g_encoin_ref_des_tbl(y).last_updated_by := c15rec.last_updated_by;
g_encoin_ref_des_tbl(y).last_update_login := c15rec.last_update_login;
g_encoin_ref_des_tbl(y).program_update_date := c15rec.program_update_date;
g_encoin_ref_des_tbl(y).last_update_date := c15rec.last_update_date;
g_encoin_ref_des_tbl(y).last_updated_by := c15rec.last_updated_by;
g_encoin_ref_des_tbl(y).last_update_login := c15rec.last_update_login;
g_encoin_ref_des_tbl(y).program_update_date := c15rec.program_update_date;
g_encoin_ref_des_tbl(y).last_update_date := c15rec.last_update_date;
g_encoin_ref_des_tbl(y).last_updated_by := c15rec.last_updated_by;
g_encoin_ref_des_tbl(y).last_update_login := c15rec.last_update_login;
g_encoin_ref_des_tbl(y).program_update_date := c15rec.program_update_date;
g_encoin_sub_comp_tbl(z).last_update_date := c16rec.last_update_date;
g_encoin_sub_comp_tbl(z).last_updated_by := c16rec.last_updated_by;
g_encoin_sub_comp_tbl(z).last_update_login := c16rec.last_update_login;
g_encoin_sub_comp_tbl(z).program_update_date := c16rec.program_update_date;
g_encoin_sub_comp_tbl(z).last_update_date := c16rec.last_update_date;
g_encoin_sub_comp_tbl(z).last_updated_by := c16rec.last_updated_by;
g_encoin_sub_comp_tbl(z).last_update_login := c16rec.last_update_login;
g_encoin_sub_comp_tbl(z).program_update_date := c16rec.program_update_date;
g_encoin_sub_comp_tbl(z).last_update_date := c16rec.last_update_date;
g_encoin_sub_comp_tbl(z).last_updated_by := c16rec.last_updated_by;
g_encoin_sub_comp_tbl(z).last_update_login := c16rec.last_update_login;
g_encoin_sub_comp_tbl(z).program_update_date := c16rec.program_update_date;
SELECT eco_name, organization_code, change_type_code,
change_mgmt_type_name, name, description, sequence_number,
status_name, object_display_name, pk1_name, pk2_name, pk3_name,
pk4_name, pk5_name, assignee_name, need_by_date, scheduled_date,
implementation_date, cancelation_date, original_system_reference,
return_status, transaction_type
FROM eng_change_lines_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key
AND process_flag = 1
AND (g_all_org = 1
OR
(g_all_org = 2 AND organization_id = g_org_id));
SELECT change_notice, organization_code, assembly_item_number,
new_routing_revision, acd_type, alternate_routing_designator,
operation_seq_num, operation_type, effectivity_date,
new_operation_seq_num, old_start_effective_date, operation_code,
department_code, operation_lead_time_percent,
minimum_transfer_quantity, count_point_type, operation_description,
disable_date, backflush_flag, option_dependent_flag, reference_flag,
yield, cumulative_yield, cancel_comments, attribute_category,
attribute1, attribute2, attribute3, attribute4, attribute5,
attribute6, attribute7, attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13, attribute14, attribute15,
original_system_reference, transaction_type
-- Bug 3412268: Added New_Revised_Item_Revision
, New_Revised_Item_Revision
FROM bom_op_sequences_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key;
SELECT eco_name, organization_code, assembly_item_number,
new_routing_revision, acd_type, alternate_routing_designator,
operation_seq_num, operation_type, effectivity_date, resource_seq_num,
resource_code, activity, standard_rate_flag, assigned_units,
usage_rate_or_amount, usage_rate_or_amount_inverse, basis_type,
schedule_flag, resource_offset_percent, autocharge_type,
schedule_seq_num, principle_flag, attribute_category, attribute1,
attribute2, attribute3, attribute4, attribute5, attribute6,
attribute7, attribute8, attribute9, attribute10, attribute11,
attribute12, attribute13, attribute14, attribute15,
original_system_reference, transaction_type, setup_code
-- Bug 3412268: Added New_Revised_Item_Revision
, New_Revised_Item_Revision
FROM bom_op_resources_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key;
SELECT eco_name, organization_code, assembly_item_number,
new_revised_item_revision, new_routing_revision, acd_type,
alternate_routing_designator, operation_seq_num, operation_type,
effectivity_date, sub_resource_code, new_sub_resource_code,
schedule_seq_num, replacement_group_num, activity, standard_rate_flag,
assigned_units, usage_rate_or_amount, usage_rate_or_amount_inverse,
basis_type, schedule_flag, resource_offset_percent, autocharge_type,
principle_flag, attribute_category, attribute1, attribute2,
attribute3, attribute4, attribute5, attribute6, attribute7,
attribute8, attribute9, attribute10, attribute11, attribute12,
attribute13, attribute14, attribute15, original_system_reference,
transaction_type, setup_code
, new_basis_type -- Bug: 5067990
FROM bom_sub_op_resources_interface
WHERE eng_changes_ifce_key = g_ECO_ifce_key;
g_public_rev_item_tbl(k).update_wip := g_encoin_rev_item_tbl(k).update_wip;
g_public_rev_item_tbl(k).Updated_Revised_Item_Revision := g_encoin_rev_item_tbl(k).updated_item_revision; -- Bug 3432944
g_encoin_rev_item_tbl.DELETE(k);
g_encoin_rev_comp_tbl.DELETE(l);
g_encoin_ref_des_tbl.DELETE(k);
g_encoin_sub_comp_tbl.DELETE(p);
g_encoin_rev_item_tbl.DELETE;
g_encoin_rev_comp_tbl.DELETE;
g_encoin_sub_comp_tbl.DELETE;
g_encoin_ref_des_tbl.DELETE;
g_public_out_rev_tbl.DELETE;
g_public_out_lines_tbl.DELETE;
g_public_out_rev_item_tbl.DELETE;
g_public_out_rev_comp_tbl.DELETE;
g_public_out_sub_comp_tbl.DELETE;
g_public_out_ref_des_tbl.DELETE;
g_public_out_rev_operation_tbl.DELETE;
g_public_out_rev_op_res_tbl.DELETE;
g_public_out_rev_sub_res_tbl.DELETE;
g_public_rev_tbl.DELETE;
g_public_lines_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_sub_res_tbl.DELETE;
g_ECO_ifce_group_tbl.DELETE;
g_item_ifce_group_tbl.DELETE;
g_comp_ifce_group_tbl.DELETE;
UPDATE eng_eng_changes_interface eeci
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = eeci.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = eeci.organization_code);
UPDATE eng_eco_revisions_interface eeri
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = eeri.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = eeri.organization_code);
UPDATE eng_revised_items_interface erii
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = erii.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = erii.organization_code);
UPDATE bom_inventory_comps_interface bici
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = bici.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update, G_Cancel)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND interface_entity_type = 'ECO'
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = bici.organization_code);
UPDATE bom_sub_comps_interface bsci
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = bsci.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND interface_entity_type = 'ECO'
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = bsci.organization_code);
UPDATE bom_ref_desgs_interface brdi
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = brdi.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND interface_entity_type = 'ECO'
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = brdi.organization_code);
UPDATE bom_op_sequences_interface bosi
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = bosi.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = bosi.organization_code);
UPDATE bom_op_resources_interface bori
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = bori.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = bori.organization_code);
UPDATE bom_sub_op_resources_interface bsori
SET organization_id = (SELECT organization_id
FROM mtl_parameters mp1
WHERE mp1.organization_code = bsori.organization_code)
WHERE process_flag = 1
AND upper(transaction_type) in (G_Create, G_Delete, G_Update)
AND (organization_id is null OR organization_id = FND_API.G_MISS_NUM)
AND organization_code is not null
AND exists (SELECT organization_code
FROM mtl_parameters mp2
WHERE mp2.organization_code = bsori.organization_code);
UPDATE eng_eng_changes_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE eng_eco_revisions_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE eng_revised_items_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE bom_inventory_comps_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND interface_entity_type = 'ECO'
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE bom_sub_comps_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND interface_entity_type = 'ECO'
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE bom_ref_desgs_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND interface_entity_type = 'ECO'
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE bom_op_sequences_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE bom_op_resources_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
UPDATE bom_sub_op_resources_interface
SET transaction_id = mtl_system_items_interface_s.nextval,
transaction_type = UPPER(transaction_type)
WHERE process_flag = 1
AND (transaction_id is NULL
OR transaction_id = FND_API.G_MISS_NUM)
AND (p_all_org = 1
OR
(p_all_org = 2 AND organization_id = p_org_id));
Update_Interface_Tables(l_return_status);
Update_Interface_Tables(l_return_status);
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl(r).last_update_date := c8rec.last_update_date;
g_encoin_rev_item_tbl(r).last_updated_by := c8rec.last_updated_by;
g_encoin_rev_item_tbl(r).last_update_login := c8rec.last_update_login;
g_encoin_rev_item_tbl(r).program_update_date := c8rec.program_update_date;
g_encoin_rev_item_tbl(r).update_wip := c8rec.update_wip;
g_encoin_rev_item_tbl(r).updated_item_revision := c8rec.updated_item_revision; -- Bug 3432944
Update_Interface_Tables(l_return_status);
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_public_rev_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_public_rev_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_public_rev_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_comp_tbl(v).last_update_date := c12rec.last_update_date;
g_encoin_rev_comp_tbl(v).last_updated_by := c12rec.last_updated_by;
g_encoin_rev_comp_tbl(v).last_update_login := c12rec.last_update_login;
g_encoin_rev_comp_tbl(v).program_update_date := c12rec.program_update_date;
Update_Interface_Tables(l_return_status);
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_public_rev_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_encoin_rev_item_tbl.delete;
g_public_rev_tbl.delete;
g_encoin_rev_comp_tbl.delete;
g_encoin_ref_des_tbl.delete;
g_encoin_sub_comp_tbl.delete;
g_public_rev_tbl.DELETE;
g_public_rev_item_tbl.DELETE;
g_public_rev_comp_tbl.DELETE;
g_public_sub_comp_tbl.DELETE;
g_public_ref_des_tbl.DELETE;
g_public_rev_op_res_tbl.DELETE;
g_public_rev_operation_tbl.DELETE;
g_public_lines_tbl.DELETE;
Update_Interface_Tables(l_return_status);
g_public_ref_des_tbl.DELETE(y);
Update_Interface_Tables(l_return_status);
g_public_sub_comp_tbl.DELETE(z);
Update_Interface_Tables(l_return_status);
DELETE from eng_eng_changes_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from eng_eco_revisions_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from eng_revised_items_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from bom_inventory_comps_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from bom_ref_desgs_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from bom_sub_comps_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from eng_change_lines_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from bom_op_sequences_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from bom_op_resources_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
DELETE from bom_sub_op_resources_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;
SELECT change_notice ,
organization_id ,
revised_item_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
last_update_login ,
implementation_date ,
cancellation_date ,
cancel_comments ,
disposition_type ,
new_item_revision ,
early_schedule_date ,
attribute_category ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 ,
status_type ,
scheduled_date ,
bill_sequence_id ,
mrp_active ,
request_id ,
program_application_id ,
program_id ,
program_update_date ,
update_wip ,
use_up ,
use_up_item_id ,
revised_item_sequence_id ,
use_up_plan_name ,
descriptive_text ,
auto_implement_date ,
attribute1 ,
attribute6 ,
attribute10 ,
requestor_id ,
comments ,
1 process_flag ,
transaction_id ,
organization_code ,
revised_item_number ,
new_rtg_revision ,
use_up_item_number ,
alternate_bom_designator ,
transaction_type ,
ENG_REVISED_ITEMS_IFCE_KEY,
eng_changes_ifce_key ,
parent_revised_item_name ,
parent_alternate_name ,
updated_item_revision ,
New_scheduled_date -- Bug 3432944
,
from_item_revision -- 11.5.10E
,
new_revision_label ,
New_Revised_Item_Rev_Desc ,
new_revision_reason ,
from_end_item_unit_number
FROM eng_revised_items_interface
WHERE process_flag = -999
AND (g_all_org = 1
OR (g_all_org = 2
AND organization_id = g_org_id))
ORDER BY parent_revised_item_name desc ;
g_encoin_rev_item_tbl(r).last_update_date := c8rec.last_update_date;
g_encoin_rev_item_tbl(r).last_updated_by := c8rec.last_updated_by;
g_encoin_rev_item_tbl(r).last_update_login := c8rec.last_update_login;
g_encoin_rev_item_tbl(r).program_update_date := c8rec.program_update_date;
g_encoin_rev_item_tbl(r).update_wip := c8rec.update_wip;
g_encoin_rev_item_tbl(r).updated_item_revision := c8rec.updated_item_revision; -- Bug 3432944
UPDATE ENG_REVISED_ITEMS_INTERFACE
SET PROCESS_FLAG = l_process_flag
WHERE TRANSACTION_ID = l_transaction_id;
DELETE from eng_revised_items_interface
WHERE process_flag = 7
AND rownum < G_ROWS_TO_COMMIT;