The View Assembly Serial Number is not designed to display non-serialized components. This package enables you to view non-serialized components issued from the Express Transact Component page to a specific serialized assembly in the View Assembly Serial Number page.

Technical Specifications for using the Functions:

• wip_ws_custom.get_assy_serial_issue_qty

• wip_ws_custom.get_assy_serial_dff_column

/* Hook to get Component issued Quantity per Assembly Serial in Exp transact component page
as well as view assembly serial Page. */
Function get_assy_serial_issue_qty(p_org_id IN NUMBER,
p_job_id IN NUMBER,
p_op_seq IN NUMBER,
p_assy_item_id IN NUMBER,
p_assy_serial IN VARCHAR2,
p_comp_item_id IN NUMBER,
p_new_wip_entity_id IN NUMBER DEFAULT NULL)
return Number
IS
l_issue_qty Number := null;
BEGIN
/* Customize by mentioning the correct column of DFF which is mapped to Assembly Serial
Number in the below SQL. */
/*
select (nvl(sum(mmt.transaction_quantity),0)) * -1
into l_issue_qty
from mtl_material_transactions mmt
where mmt.transaction_source_type_id = 5
and ((mmt.transaction_source_id = p_job_id and mmt.operation_seq_num = p_op_seq)
or mmt.transaction_source_id = p_new_wip_entity_id)
and mmt.organization_id= p_org_id
and mmt.inventory_item_id = p_comp_item_id
and mmt.transaction_action_id in (1,27) --Only considering issue/return, and not -ve
issue/return
and mmt.attributeXX = p_assy_serial;
Custom Hooks Page 4 of 16
*/
return l_issue_qty;
END get_assy_serial_issue_qty;
/* Hook to get the DFF Column Mapping for Assembly Serial in Exp transact component page. */
Function get_assy_serial_dff_column
return Number
IS
l_attr_col Number := null;
BEGIN
/* Customize by defining the Transaction History DFF column mapping to Assembly Serial
Number below .
Valid values are only values between 1-15 which maps to the corresponding columns Attribute1 -
Attribute15 . */
/* l_attr_col := 1; */
return l_attr_col;
END get_assy_serial_dff_column;