v_context := '
';
fnd_file.put_line(fnd_file.output, v_context);
v_context := '
PII ECR / ECO Manage Revision control Report ';
fnd_file.put_line(fnd_file.output, v_context);
v_context := '
';
v_context := v_context || '';
v_context := v_context ||
'Part Number' ||
'ECO / ECR' ||
'ECO / ECR No' ||
'ECR / ECO Status' ||
'CREATION DATE ' ||
'Revision Approved' ||
'Revision Number' ||
'Updated by' ||
'Description' ||
'Technology' ||
'Unit Cost USD' ||
'WEA QOH' ||
'USA QOH' ||
'CEE QOH' ||
'CAN QOH' ||
'Average 12 Mth Global Net Usage
' ||
'Average Weekly Consumption' ||
'QOH (Weeks)' ||
'WEA REQ' ||
'USA REQ' ||
'CEE REQ' ||
'CAN REQ' ||
'WEA PO' ||
'USA PO' ||
'CEE PO' ||
'CAN PO' ||
'Total Global Supply Qty (Weeks';
v_context := v_context || '
';
fnd_file.put_line(fnd_file.output, v_context); --Add by liming on 02/05/2012
v_context := '
';
--v_context := v_context || '' || v_count || ' | ' || '
';
v_context := v_context || '' ||R.PART_NUMBER || ' | '
|| '' || R.ECO_ECR || ' | '
||'' || R.ECO || ' | '
|| '' || R.ECO_STATUS || ' | '
|| '' || R.CREATION_DATE || ' | '
|| '' || V_REVISED_STATUS ||' | '
|| '' || V_NEW_ITEM_REVISION || ' | '
|| '' || V_UPDATED_BY ||' | '
|| '' || R.DESCRIPTION ||' | '
|| '' || R.TECHNOLOG ||' | '
|| '' || V_UNIT_COST ||' | '
|| '' || V_WEA_OH_QTY ||' | '
|| '' || V_USA_OH_QTY ||' | '
|| '' || V_CEE_OH_QTY ||' | '
|| '' || V_CAN_OH_QTY ||' | '
|| '' || V_12M_NET_USAGE ||' | '
|| '' || V_AVG_WEEK_CONSUMP ||' | '
|| '' || V_QOH_QTY ||' | '
|| '' || V_WEA_REQ_QTY ||' | '
|| '' || V_USA_REQ_QTY ||' | '
|| '' || V_CEE_REQ_QTY ||' | '
|| '' || V_CAN_REQ_QTY ||' | '
|| '' || V_WEA_PO_QTY ||' | '
|| '' || V_USA_PO_QTY ||' | '
|| '' || V_CEE_PO_QTY ||' | '
|| '' || V_CAN_PO_QTY ||' | '
|| '' || V_TOTAL_GOLBAL_QTY ||' | '
|| '';
FND_FILE.PUT_LINE(fnd_file.output, v_context);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/269025/viewspace-1224174/
，如需转载，请注明出处，否则将追究法律责任。
