To add a new material/work group to a supplier, enter all mandatory values.
The arguments of the INS_SUPMG procedure are listed below.
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER, m_user_securities.us_id |
IN |
|
P_COL_ARR |
RECORD |
IN |
|
P_RESULT |
VARCHAR2 |
OUT |
|
P_SMG_ID |
NUMBER, m_sup_material_groups.smg_id |
OUT |
|
P_SUP_ID |
NUMBER, m_suppliers.sup_id |
IN |
|
P_COMMIT_IND |
VARCHAR2, default ‘Y’ |
IN |
The procedure inserts a record into m_sup_material_groups.
The following table shows the values that can be transferred with P_COL_ARR in the INS_SUPMG procedure.
|
Column Name |
Mandatory |
Description |
|---|---|---|
|
MGTY_CODE |
Yes |
Supplier ID (NUMBER(12,0), m_matl_group_types.mgty_id) |
|
MG_CODE |
Yes |
Matl/Work Group ID (NUMBER(12,0), m_sup_material_groups.mg_id) |
|
MG_REVISION_ID |
YES |
Matl/Work Group Revision (NUMBER(2,0), m_material_groups.revision_id) |
|
QUALIFIED_IND |
Yes |
Qualified (VARCHAR2(1), m_sup_material_groups.qualified_ind) |
|
QUALIFIED_DATE |
No |
Qualified Date (DATE), m_sup_material_groups.qualified_date) |
|
APP_DEPARTMENT |
No |
Approval Department ID (NUMBER(12,0), m_sup_material_groups.dpt_id) |
|
QUALIFICATION_CLASS |
Yes |
Classification (VARCHAR2(1), m_sup_material_groups.qualification_class) |